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 APRIL 10, 2019
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.
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