My Oracle Support Banner

Procurement Card - CC Transactions With CC_STATUS = 1 Reset CC_STATUS = 0 After Saving (Doc ID 2421936.1)

Last updated on FEBRUARY 02, 2019

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


PCARD - CC Transactions with CC_STATUS = 1 reset CC_STATUS = 0 after saving

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 (See attached).

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

No Transactions found, specify different search criteria. (10700,311)

The issue can be reproduced at will with the following steps:
1. Run the Pcard Bank Statement Workflow process.
2. Using the Recon Statement Search page, search for transactions with status = INITIAL.
3. Search results displayed transactions with status = STAGED.
4. Exit the page.
5. Do the search again for Status = INITIAL.
6. Message displayed (correct) - No Transactions found, specify different search criteria. (10700,311)

The issue has the following business impact:
The search page is not working properly


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.