Thursday, 30 August 2018

Document sequence tables in oracle apps

Document sequence tables in oracle apps

In this post , We will discuss about Document sequence tables in oracle apps. Document sequence helps to assign the number to Oracle transactions which occurs more than once, by numbering them you can identify the order of its generation. It acts like a chain and if a number goes missing, the link is broken and you can see that there was a deletion or removal of the transaction. Document sequence tables in oracle apps stores the unique sequence for each transaction based on the category and then after that, system refer that sequence number for generating numbers for that category transactions. In general business practice we create the document sequences for each transaction every year for audit point of view. Here below I will share the detail description of Document sequence tables in oracle apps.
 
If you want to refer the Document sequence setup in oracle apps then you can refer this Document Sequence Setup r12.
 

Document sequence tables in oracle apps


FND_DOCUMENT_SEQUENCES

FND_DOC_SEQUENCE_ASSIGNMENTS

FND_DOC_SEQUENCE_ASSIGNMENTS

1 comments:

Anonymous said...

Thank you.

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *