Loading Procurement Card (PO_CCLOADLD) Process Abended at Step PO_CCLOADLD.CC33452.STEP02 (Doc ID 2250373.1)

Last updated on APRIL 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Loading Procurement Card (PO_CCLOADLD) process ABENDED at Step PO_CCLOADLD.CC33452.Step02 in the following situation:

When running PO_CCLOADLD for a Visa file transaction the process fails where there are at least 2 or more eligible POs apart from the one which is being paid via P-Card, having the same merchandise amounts.
When trying to load PO_ID having the PO_DT as 09-Jan-2017, the program tries to match the TRANS_DT from the file and the PO_DT. Due to this it fails to pick up the PO due to date mismatch. This is the reason why it is picking up other POs where that has the same PO_DT as 10-jan-2017 and the Supplier Location is NOT a Procurement Card Location.

<<<
-- 01:09:41.129 .......(PO_CCLOADLD.CC33452.Step02) (SQL)
INSERT INTO PS_CC_LINE_TAO [...]
-- Row(s) affected: 0
-- 01:09:41.175 Process 8374392 ABENDED at Step PO_CCLOADLD.CC33452.Step02
(Action SQL) -- RC = 805
ROLLBACK
/
-- 01:09:41.180 SQL Error: ORA-00001: unique constraint
(SYSADM.PS_CC_LINE_TAO) violated >>>



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