PCARD: PO_CCSTMT_WF Flips All Of The CC_STATUS = 0 To CC_STATUS = 1

(Doc ID 2364492.1)

Last updated on FEBRUARY 22, 2018

Applies to:

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

Symptoms

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.


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