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 AUGUST 02, 2016

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Endorsement Adjustment to Bill Receivable will not process with Create Accounting.
Adjustment Type of E is for Endorsement Adjustment.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms