My Oracle Support Banner

Concurrent Process PAAPIMP_SI: PRC: Interface Supplier Costs Completed With Error "MSG-20003 ORA-20003 import1_prog PA_TRANSACTION_XFACE_CTRL_U1" (Doc ID 2872079.1)

Last updated on MAY 24, 2022

Applies to:

Oracle Project Costing - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.11 version, Purchase to Pay Flow

Concurrent process PAAPIMP_SI: PRC: Interface Supplier Costs completed with below error

ERROR
----------
MSG-20003: ORA-20003: import1_prog:ORA-00001: unique constraint (PA.PA_TRANSACTION_XFACE_CTRL_U1) violated After calling pre_import Extension
SQL COUNT 1 ORA-06512: at "APPS.PA_TRX_IMPORT"

STEPS
----------
The issue can be reproduced at will with the following steps:

1. Go into the Project responsibility
2. Run the concurrent process PRC: interface supplier cost



Cause

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
Symptoms
Cause
Solution
References


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