Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

where is the dID in Revisions table generated?

654963Jan 2 2009 — edited Jan 7 2009
Hello everyone. When we check-in a document in UCM, it inserts a row in Revisions table (and also in docMeta and Documents tables) in the database. The primary key for revisions table is dID. Can anyone tell me where is this dID generated. Let's take an example:

I insert a row in revisions table, docMeta and Documents tables manually with dID = X (say). from the front-end i can find the file and everything works fine. However when i check-in a document now it throws an error because it is again trying to insert into the revisions table with dID = X. I tried to find if there is a sequence but apparently it is not using any sequence or at least i couldn't find one.

So how is this dID generated? I would highly appreciate some pointers.

Regards,
Sadik Bhimani
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2009
Added on Jan 2 2009
1 comment
1,265 views