My Oracle Support Banner

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.

Symptoms

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.

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.