Supplier Merge Program Completes Error: MSG-07460: Error In Function Duplicate_Sites

(Doc ID 1314783.1)

Last updated on MAY 13, 2013

Applies to:

Oracle Payables - Version: 12.0.0 to 12.0.6 - Release: 12.0 to 12.0
Information in this document applies to any platform.

Symptoms

In 12.0, Supplier Merge Program ending with following error

MSG-07460: Error in function Duplicate_sites
MSG-03060: Failure in function BeforeReport
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-03000: Start Before Reports Trigger.
MSG-03010: After SRWINIT
MSG-03011: Checking whether from vendor id and vendor site id are passed or not
MSG-03020: Check CHV installation status.
MSG-03030: Check MRP installation status.
MSG-03040: CHV status: Y and MRP status: Y
MSG-03050: Call function get_company_name
MSG-03070: Call function GET_NLS_STRINGS
MSG-03090: Call function get_base_curr_data
MSG-03110: Call

The issue can be reproduced with the following steps:
  1. Run Supplier Merge Program

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