XLAMERGEACCT - "Create Accounting For Third Party Merge" Fails With ORA-1422 (Doc ID 1358781.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version: 12.0.6 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
XLAMERGEACCT - Create Accounting For Third Party Merge

Symptoms


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:

Setup:

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.




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