Loading Procurement Card (PO_CCLOADLD) Process Abended at Step PO_CCLOADLD.CC33452.STEP02
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.
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
-- 01:09:41.180 SQL Error: ORA-00001: unique constraint
(SYSADM.PS_CC_LINE_TAO) violated >>>
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms