Home » Applications » Oracle Fusion Apps & E-Business Suite » Clinicals
Clinicals [message #102427] Thu, 30 May 2002 13:23 Go to next message
sandhya
Messages: 15
Registered: February 2002
Junior Member
Hello Orafaq,

While i was going through the Dice.com site i happen to see the requirement for oracle clinicals.I have browsed through the internet immensely to find out what is this oracle clinicals but i could not get the information about it and if there is anything like that i want to know and learn more about it.

Please help me find what it ia and how to learn
Hope answer for my request is met quickly.

thank you

bye
sandhya
Re: Clinicals [message #102497 is a reply to message #102427] Thu, 27 June 2002 07:40 Go to previous messageGo to next message
Syed Sabdar Hussain
Messages: 4
Registered: June 2002
Junior Member
PURPOSE
-------

Understanding of and maintainance of sequences for Oracle Clinical.


SCOPE & APPLICATION
-------------------

Functional Clinicals, DBA, Applications Developer

Sequences for Oracle Clinical
-----------------------------

Rules for regenerating sequence numbers:
****************************************
Patch# 738866 (for RDBMS 7.3.3.6 only):
ORACLE NUMBERS >= 100000000 CANNOT BE QUERIED FROM A CALLOUT.

This patch must be installed if Sequence numbers will approach 100000000.

The increment size required for all OC tables except responses must be
100.
For responses, it must be 2000.
If you run out of id's for a particular sequence, you can start the sequence
over with a different 'seed' value - as long as that seed is not and will
never be used by another database that replicates with the current database.
The seed is the number, from 01 to 99, that is in the lowest two places of
the id.

If the sequence was originally started with a min value of 1 and increment
by value of 2000, you should have entries for 1, 2001, 4001, 6001 and so on.
You may drop the sequence and recreate it starting from 10 with the same
increment (10, 2010, 4010) with no problem, provided there are no
inconsistencies on slave sites (ie sequences must be in sync accross all).

Make sure that when dropping/recreating the sequence the minimum value
starts higher than the last minimum value used.

Using sqlplus to verify seed and sequence:
******************************************
To see the start seed number:

SQL> select ocl.dbseed from dual;

DBSEED
----------
3

To see the increment value:

SQL> select INCREMENT_BY from all_sequences
2 where sequence_name = 'RESPONSE_SEQ';

INCREMENT_BY
------------
10

To verify that the system is incrementing correcty:

SQL> select response_seq.nextval from dual;

NEXTVAL
----------
174493

SQL> /

NEXTVAL
----------
174503

The system start seed number is 3 and is incremented by 10.


RELATED DOCUMENTS
----------------
.

For further info contact me..Bye sabdar
Re: Clinicals [message #102629 is a reply to message #102427] Sat, 03 August 2002 00:58 Go to previous message
rajesh
Messages: 173
Registered: November 1998
Senior Member
Hi there,
Did any one install oracle clinical version 4.0? If so please let me know, I'm stuck in the middle of installation. I have one or two questions to ask.
I appreciate it very much if some one replies to my question.
Thank you,
Rajesh.
Previous Topic: Government re-engineering
Next Topic: gl set of books ID
Goto Forum:
  


Current Time: Thu Mar 28 17:57:06 CDT 2024