Mg Vendor Merge Failing With Error Rep-1401 'C_duplicate_yes_noformula' (Doc ID 420456.1)

Last updated on JULY 14, 2015

Applies to:

Oracle Payables - Version 11.5.9 and later
Information in this document applies to any platform.
APXINUPD module: Supplier Merge Program
Payables Module

Symptoms

-- Problem Statement:
On 11.5.9 in Production:
When attempting to submit the Supplier Merge Program the following error occurs:

ERROR
MSG-00200: Updating ap_invoices.......
REP-1401: 'c_duplicate_yes_noformula': Fatal PL/SQL error occurred.


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Go to Vendor Customer responsbility
2. Maintain Supplier>Supplier Merge

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot merge suppliers.

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