My Oracle Support Banner

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 JUNE 23, 2021

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.

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

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
Changes
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.