My Oracle Support Banner

PCARD: PO_CCSTMT_WF Flips All Of The CC_STATUS = 0 To CC_STATUS = 1 (Doc ID 2364492.1)

Last updated on NOVEMBER 23, 2019

Applies to:

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


After Running PO_CCSTMT_WF all Staged transactions are set to CC_STATUS = 1 (Initial)
Upon Opening Purchasing > Procurement Cards > Reconcile > Reconcile Statement and Filtering for Statement Status = "Initial" the results displayed will include only CC_TRANS_LINES with CC_STATUS = 1.
Clicking "Save" will then update all CC_TRANS_LINES with CC_STATUS = 1 to CC_STATUS = 0 because the displayed CC_STATUS is "Staged" or 0.  CC_STATUS "Initial" is not displayed.

When filtering a second time using the same criteria, the user now has lost all transactions because the Statement Status for those transactions has been changed from CC_STATUS = 1 to CC_STATUS = 0

Steps to Replicate:

Go to Procurement Card, Reconcile Statement page.
There should be transaction rows already there. Set all rows with status = STAGED
Run the Bank Statement Workflow process.
From the Recon Statement Search page, search for transactions with status = INITIAL
Returned results shows rows with status = STAGED. This is incorrect.
Save the page.
Exit the page
Repeat the search for transactions with status = INITIAL
Message pops up = No Transactions found, specify different search criteria.
(10700,311). this is correct.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.