Document Sequencing

1 Set Profile Option Sequence Numbering : Partially Used/Always Used.

2 Give permission on AR_DOC_SEQUENCE_AUDIT (for AR module) to public.

3. Define Category : Ensure you use the exact same name for your category name as the name of the associated transaction type, payment method, or adjustment activity. This provides the link between the document type and the sequence when transactions are created.

4 Create a sequence and assign it to AR user. You can use either manual sequence or automatic sequence for any of the activity other than Automatic Receipts, Automatic Adjustments, Lock Box Receipts, Charge back Adjustments, Commitment Adjustments, Charge back Reversals, Adjustments Reversals, and Finance Charge Adjustments. If you are using Auto Invoice, you may manually enter sequential numbers in the Auto Invoice interfacetables. However, Receivables will automatically assign sequence numbers to the transactions you import if you use an automatic sequence type for these transactions.

5 Assign sequence to Categories. You can assign a sequence to multiple categories.

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.