Subledger Accounting: Create Accounting Completes with Error When There is an Endorsement Adjustment to Bill Receivable - ORA-24381: Error(s) in Array DML (Doc ID 1631818.1)

Last updated on MAY 08, 2018

Applies to:

Symptoms

When attempting to run Create Accounting program, the Endorsement Adjustments are not processing via Create Accounting and completes with the following error:

An internal error has occurred in the program XLA_AE_HEADER_PKG.InsertHeaders. ORA-24381: error(s) in array DML.

Steps to Reproduce:
Responsibility:  Receivables Manager
1. Generate Invoice that will be attached to a Bill Receivable
    Navigation: Transactions>Transactions
2. Generate Bill Receivable and Attach Invoice Created in Step 1.
    Navigation: Bill Receivable>Transactions
    You can make this Bill Receivable as Unsigned BR for Type
    Click on Assignments and Assign your Transaction to this BR
    Complete.
3. Access your Receivables Activity and ensure that you have an Endorsement Adjustment Activity Setup
    Navigation: Setup>Receivables>Receivables Activity
    Ensure that the Type is Endorsement and assign a Activity GL Account to this Activity
    GL Account Source:  Activity GL Account
    Tax Rate Code Source: None
4. Access your Bill Receivable
    Navigation:  Bill Receivable>Transactions
    Click on Tools>Endorse
    Fill in the Dates and Save
    NOTE: This will automatically Close the BR and Generate an Endorsement Adjustment

5. Run Create Accounting
   Navigation: Control>Request>Run
         LOV: Create Accounting
         Category:  Adjustment      

Cause