My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.