Integrated Supplier Import Concurrent Program (and Interface Duplicate Identification) Completed with Error and Warnings - ORA-06512: at "APPS.HZ_IMP_DQM_STAGE" ORA-06510 (Doc ID 1361925.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.
ARHDIDIP
ARHDIDIW
POSSUPIMP


Symptoms

On : 12.1.3 version, Import Workbench

Attempting to run the Integrated Supplier Import Program and receive the following error:

POSSUPIMP module: Integrated Supplier Import Program
---------------------------------------------------------------------------
Current system time is 27-APR-2011 16:42:21
---------------------------------------------------------------------------
Message: Inside PROCEDURE check_party_contact_exist Parameters: p_batch_id: 12003 Rows inserted in hz_imp_contacts_int: 0
After pre_processing
l_batch_status : PROCESSING l_import_status : PENDING
l_import_run_option : WHAT_IF
UIC***** Batch de-duplication program errored...exiting
Message: Inside PROCEDURE IMPORT_BATCH output parameters from hz_batch_import_pkg errbuf : WARNING**** Unexpected error occured Batch de-duplication program. retcode : 1
l_batch_status2 : ACTION_REQUIRED

Additionally, the following two concurrents are failing with an error too:
1. ARHDIDIP module: Interface Duplicate Identification

**Starts**27-APR-2011 17:02:23
ORACLE error 6510 in FDPSTP

Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.HZ_IMP_DQM_STAGE", line 857
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
The SQL statement bein

2. ARHDIDIW module: Interface Duplicate Identification Worker

**Starts**27-APR-2011 16:43:24
ORACLE error 6510 in FDPSTP
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.HZ_IMP_DQM_STAGE", line 705
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1

Steps to Reproduce:
Responsibility:  Supplier Data Librarian Super User
Navigation:  Supplier Home > Administration > DQM
1. Select DQM matching rule to Bulk import process
2. Go to Supplier Data Librarian Super User > Supplier Home > Import
3. See the warning and errors in the called files.

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