My Oracle Support Banner

Troubleshooting Document Sequences in Receivables (Doc ID 1087122.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions
Form:ARXRWMAI.FMB - Receipts
Form:RAXSUCTT.FMB - Define Transaction Types

Executable:ARXREC - Recurring Invoice Program
Executable:ARLPLB - Process Lockboxes
Executable:ARXAAP - AutoAdjustment
Executable:RAXTRX - Autoinvoice Import Program

ConcurrentProgram:ARZCAR_RECEIPT - Automatic Receipts Creation Program


Purpose

Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1087122.1

Oracle Receivables (AR): Transactions Workbench Information Center > Note 1087122.1

 

ATTENTION:

We have a Document Sequence Analyzer that can automate troubleshooting your setup. Please review <Note 2021711.1> EBS Oracle Receivables Document Sequence Analyzer.


Document sequence numbers are unique numbers that can be assigned to transactions you create in Receivables. This feature is used across the Receivables application in both the Transactions and Receipts workbenches, and in manual and concurrent processes.

This article contains troubleshooting tips for issues regarding Document Sequences. If you are unsure about your setup, please review Note 1086565.1, How To Setup Document Sequences In Receivables.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 1. Review the General Setup of Document Sequences.
    a. Transactions
    b. Receipts
    c. Receivable Activities
 2. Explanation of Document Sequence Behavior
    a. Automatic Transaction Numbering vs. Copy Document Number to Transaction Number vs. Document Number Generation Level
    b. Document Sequence = Manual & Document Category = Automatic
 3. Common Errors from Concurrent Processes
    a. Error: APP-01702: An assignment does not exist for these parameters and one is mandatory.
    b. Error: Issues due to Initial value exceeding 10 digits
    c. Error: ORA-20001 : Document Sequencing is not Defined for the Adjustment Reversal Activity
    d. Error: 95342: The document sequence category xxxxxx is invalid.
    e. Error: The assigned sequence is inactive
 4. Errors while Processing Transactions
    a. Error: APP-AR-201995: This transaction type does not have a document sequence category code assignment. 
    b. Error: APP-11603: You must assign a document number for this document when the profile option 'Sequential Numbering' is set to 'Always Used'
    c. Silent failure in Transaction workbench when creating or updating a transaction.
    d. Error:  ORA-01403 FRM-40735 ON-COMMIT
    e. The document sequencing feature is enabled, but no 'Automatic' document sequence exists within Oracle Receivables for this document category and date.
    f. Document sequence does not exist for the current document even though profile option Sequential Numbering is set to Partially Used.
 5. Unexpected Results When Processing Transactions 
    a. AutoInvoice fails to generate document sequence numbers as expected.
           i. Custom Request Set
           ii. Transactions created from AutoInvoice do not have document sequence values populated.
           iii. Document Sequence not generated for Interface from Project Accounting
 6. Errors Encountered while Processing Receipts
    a. APAR-96251: Cannot submit Automatic Receipt Creation process because an active document sequence assignment does not exist for this payment method
       i. Setup is incorrect or incomplete
       ii. Setup was corrupted
    b. LockBox Error 'SEQUENCE NOT ASSIGNED'
    c. Silent failure When Creating or Updating a Receipt.
    d. Apply Receipt to Activity Refund Error: INVALID ASSIGNMENT
 7. Errors While Processing Adjustments
    a. Running Adjustment API and hitting the error Validate_Adj_Insert: failed to validate doc seq
 8. Errors While Processing Bills Receivable
    a. Issues with Bills Receivable Maturity / Remittance
 9. Errors While Processing Late Charges
    a. Header error interest_header_id:10021:UNIQUE-ALWAYS USED:
 10. Errors While Processing Netting Receipts
    a. Settle Netting Batch program fails with 'An error occurred while creating a Cash Receipt.'
 11. Errors Encountered while processing Prepayments
    a. Create_Prepayment: Document sequence does not exist for the current document even though profile option Sequential Numbering is set to Partially Used
    b. Corrupted Sequence data
 12. Patching issues
    a. Transaction workbench, ARXTWMAI.pld:
    b. Invoice API, ARXVINUB.pls:
 13. JG Localization / Globalization issues
    a. Check profile option: JG: Territory Profile
    b.  Ensure the following post patch SQL has been run (these SQLs apply to all point releases of Release 12, e.g. 12.1.x, 12.2.x, etc.):
    c.  Large gaps in system generated transaction numbers
 14. Invoice Numbers Showing as ~$~$$$
 15. Still Have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.