EEX 9.1/9.2 : EX_DATA_LOAD Failed with Unique Constrain Error While Loading Master Card CDF3 Transaction File (Doc ID 1994316.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Load External Data process Failed with unique constraint error at Step EX_LOAD_MCV3.StgError.InsErr, When loading the Master Card CDFv3 credit card transaction file.


Steps:
--------
1. Place the Master card CDFv3 transaction file in the server.
2. Run the process EX_DATA_LOAD to load the file.


Error:
------
Process run in to No success with below error:

Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_EX_MC_STG_ERR) violated Failed SQL stmt: INSERT INTO PS_EX_MC_STG_ERR (TRANS_NBR, SEQ_NBR, ITEM_SEQ_NBR, PROCESS_INSTANCE, M C_MERCH_ACT_FLG, MC_ACCT_NUM, MC_TRANS_TYPE, MC_DEB_CRD_FLG, MC_TRANS_AMNT, MC_TRANS_DATE, MC_MERCH_ NAME, MC_MERCH_CITY, MC_MERCH_STATE, MC_MERCH_CNTRY, MC_MERCH_TYPE, MC_ORIG_AMNT, MC_ORIG_CURR_CD, M C_POST_CURR_CD, MC_INET_EXCH_RT, MC_MERCH_TYPE1, MC_MERCH_POSTAL, MC_CRDHLD_NAME, AIRFARE_RCPT_NBR, MC_CHCK_IN_DT, MC_CHCK_OUT_DT, NBR_NIGHTS, TXN_LOCATION, ADVANCE_SOURCE, EMPLID, TXN_CURRENCY_CD, CU RRENCY_CD, EXPENSE_TYPE, EXPEND_MTHD, COUNTRY, EX_TRANS_TYPE, INVALID_EMPLID, INVALID_EX_TYPE, INVAL ID_MON_CURR, INVALID_TXN_CURR, RELOAD_TRANS_SW, CRDMEM_ACCT_NBR, DATA_SOURCE_EX, MC_TRANS_DT, MC_ARR

Process 27561 ABENDED at Step EX_LOAD_MCV3.StgError.InsErr (SQL) -- RC = 805


Please see Replication Steps for more details related to complete configuration and the replication steps necessary to reproduce the issue.

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