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 JULY 11, 2018

Applies to:

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

Symptoms



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

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




STEPS
-----------------------
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)

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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