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.
Document sequence tables in oracle apps
FND_DOCUMENT_SEQUENCES
FND_DOC_SEQUENCE_ASSIGNMENTS
FND_DOC_SEQUENCE_ASSIGNMENTS
No comments:
Post a Comment
Please review my topic and update your comments
Note: only a member of this blog may post a comment.