Home » Applications » Oracle Fusion Apps & E-Business Suite » Sequences for IDs of fnd_documents tables
Sequences for IDs of fnd_documents tables [message #187382] Sun, 13 August 2006 03:20 Go to next message
kaps
Messages: 2
Registered: August 2006
Location: Gandhinagar,India
Junior Member
Hi all,
we want a custom form for doing notes attachment.
this as i have understood can be done through the fnd_documents and its supporting tables.
we need to figure out which sequence apps uses to generate the ids used in these tables.
say in fnd_documents we have a document_id .. from which sequence this id gets generated ???
similarly the media_id in fnd_documents_long_text
and attached_document_id in fnd_attached_documents.

Grateful for your replies.

Thanks & Regards.
Kaps

Report message to a moderator

Re: Sequences for IDs of fnd_documents tables [message #188774 is a reply to message #187382] Mon, 21 August 2006 10:52 Go to previous message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
Generally, ID columns come from a sequence with the same name as the base table.
Check for FND_DOCUMENTS_S and FND_DOCUMENTS_LONG_TEXT_S

Report message to a moderator

Previous Topic: Oracle Apps Location of generated report files
Next Topic: Transaction Controls - Oracle Projects
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 11 07:38:55 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.