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