Party Merge Gives ORA-00923 in HZ_PARTY_MERGE.GET_RECORD_DESC for entity IBY_EXTERNAL_PAYERS_ALL (Doc ID 1062366.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version: 12.1.1 to 12.1.3 - Release: 12.1 to 12.1
Information in this document applies to any platform.

Symptoms

Party Merge is failing with the following error message in the concurrent program log:

**** Error ****
Error: Merge failed in procedure HZ_PARTY_MERGE.GET_RECORD_DESC for entity IBY_EXTERNAL_PAYERS_ALL
This error occurred in retrieving the description column for IBY_EXTERNAL_PAYERS_ALL:
ORA-00923: FROM keyword not found where expected

Steps to Reproduce:
1. Trading Community Manager > Data Quality Management > Party Merge.
2. Enter the From and To Party.
3. Submit the merge.

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