EAP: PSARCHIVE abends at Step PSARCHIVE.SETBASED.Step003 (PeopleCode) -- RC = 8 (Doc ID 1937123.1)

Last updated on MARCH 18, 2016

Applies to:

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

Symptoms

PSARCHIVE is abending at Step PSARCHIVE.SETBASED.Step003 with an error.

ERROR
SQL error. Function:
SQLExec Error Position:  0 Return:  805 - ORA-00001: unique constraint (EMDBO.PS_AP_ARC_VND_GC_H) violated Statement:
INSERT INTO PS_AP_ARC_VND_GC_H (PSARCH_ID, PSARCH_BATCHNUM, SETID, VENDOR_ID, CERTIF_S OURCE, EFFDT, GOV_CLASS, GOV_CERTIF_NBR, CERTIFICATE_EXP_DT, CERTIFICATE_BEG_DT) SELECT 'AP_VNDR', 9 , OL.SETID, OL.VENDOR_ID, OL.CERTIF_SOURCE, OL.EFFDT, OL.GOV_CLASS, OL.GOV_CERTIF_NBR, OL.CERTIFICAT E_EXP_DT, OL.CERTIFICATE_BEG_DT FROM PS_VNDR_GOV_CERT OL, PS_AP_ARC_VENDOR_H BTH WHERE OL.SETID = BT H.SETID AND
OL.VENDOR_ID = BTH.VENDOR_ID AND BTH.PSARCH_ID = 'AP_VNDR' AND BTH.PSARCH_BATCHNUM = 9

Original Statement:
%InsertSelectWithLongs(AP_ARC_VND_GC_H, VNDR_GOV_CERT OL,  PSARCH_ID = 'AP_VN          

SQL error in Exec. (2,280)
PSARCHIVE.SETBASED.GBL.default.1900-01-01.Step003.OnExecute  PCPC:247  Statement:6          

Process 14409 ABENDED at Step PSARCHIVE.SETBASED.Step003 (PeopleCode) -- RC = 8

STEPS
1.  Used Vendor ID = IND0000094
2.  Update the Government Classifications with 2 Effective Fates for 01/01/1900 and Certification Source: is ISO so the data in the select * from ps_vndr_gov_cert is as follows:

SETID VENDOR_ID  CERTIF_SOURCE GOV_CLASS  EFFDT     GOV_CERTIF_NBR          
                         CERTIFICATE_EXP_DT CERTIFICATE_BEG_DT
----- ---------- ------------- ---------- ---------
-------------------------------------------------- ------------------
------------------
SHARE IND0000094 ISO           ISO-001    01-JAN-00 1245454654              
                                                              
SHARE IND0000094 ISO           FBC-001    01-JAN-00 1245454654

3.  Run the Archive Data to History  - for last updated dt < today's date
4.  Process will abend with the above error

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