XLAMERGEACCT - "Create Accounting For Third Party Merge" Fails With ORA-1422
Last updated on AUGUST 24, 2016
Applies to:Oracle Receivables - Version: 12.0.6
Information in this document applies to any platform.
XLAMERGEACCT - Create Accounting For Third Party Merge
XLAMERGEACCT Create Accounting for Third Party Merge fails with
Please inform your system administrator or support representative that: An unexpected error occurred in the function xla_third_party_merge.create_accounting: ORA-01422: exact fetch returns more than requested number of rows
Steps to reproduce:
Party Merge Accounting Option = 'Transfer Third Party Control Account Balances'
You have overlapping adjustment periods defined in your calender. For example:
Adj1 from 31-DEC to 31-DEC and Adj2 also for 31-DEC to 31-DEC.
Adj1 and Adj2 is open in GL.
Run Customer Merge this kicks of Create Accounting For Third Party Merge, which is running into error.
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