EAP: Sam Load Process Abends at Step AP_SAM_LOAD.UPDCNTCT.ADDRTEMP (SQL) -- RC = 805, SQL Error: ORA-00001: Unique Constraint (SYSADM.PS_USF_ADDR_TAO4) Violated
(Doc ID 2863926.1)
Last updated on JULY 14, 2022
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
The SAM Load process has multiple rows in PS_USF_VNDR_HDR where the DUNS / UEID combination, each with a different USF_EFT_IND. The different USF_EFT_IND values also exist in PS_USF_VNDR_XREF.
The SQL in Step AP_SAM_LOAD.UpdtVndr.UpdtVndr.DoSelect, selects the same Vendor_SetID / Vendor_ID combination twice, will cause a unique constraint inserting into PS_USF_ADDR_TAO temp table.
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