Subledger Accounting: Create Accounting Completes with Error When There is an Endorsement Adjustment to Bill Receivable - ORA-24381: Error(s) in Array DML
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