My Oracle Support Banner

Procurement Card Issues With Negative Balance Days (Doc ID 2760196.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

Procurement card Issues with negative balance days:

1.  When a Credit day does occur, no prepaid voucher is created. Which we expect. If next day’s total amount of transactions is enough to offset pervious day neg amount, a pre-paid voucher is created with the sum of the two days transaction. Which we expect. However, when the next day transactions are loaded it is also deducting the credit day amount. Not expected results. Noticed that the PREPAID_REF field on the PS_CC_TRANS_LINE table for already processed transactions are not getting updated. Normally this field is updated once the transactions are included on a prepaid voucher.

2. Issue is if the PCard file comes in on the last billing day with a credit balance. The negative day’s balance does not carry over to the next billing cycle. The negative day is never adjusted in the following days charges.

 

The issue can be reproduced at will with the following steps:

Setup:

1. ProCard Card Issues VISA. Check Create Prepayment Voucher
2. Cardholder Profile. Add Card Number '1111111234567890' to 'Gina Angelini' (DEMO Data)


Steps:

1. Run Load ProCard Stage (file 1 with negative amount 159.75)
2. Run Load Statement
3. Negative amount loaded in Pcard tables. Queries:
  SELECT * FROM PS_CC_TRANS_HEADER;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_LINE A;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_DIST A;
4. Run Voucher build. Prepaid not created. That is correct.

5. Run Load ProCard Stage (file 2 with positive amount = 2919.65)
6. Run Load Statement
7. Positive amount loaded in Pcard tables. Queries:
  SELECT * FROM PS_CC_TRANS_HEADER;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_LINE A;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_DIST A;
  Positive amount loaded 2919.65
8. Run Voucher Build. Prepaid voucher created. Negative amount applied: 2919.65 – 159,75 (negative amount) = 2759.90. That is correct.

9. Run Load ProCard Stage (file 3 with negative amount 7328.36 last day of the billing cycle)
10. Run Load Statement
11. Negative amount loaded in Pcard tables. Queries:
  SELECT * FROM PS_CC_TRANS_HEADER;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_LINE A;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_DIST A;
  Negative amount loaded: 7328.36
12. Run Voucher Build. Negative voucher not created. That is correct.

13. Run Load ProCard Stage (file 4 positive amount 7434.4 next billing cycle)
14. Run Load Statement
15. Positive amount loaded in Pcard tables. Queries:
  SELECT * FROM PS_CC_TRANS_HEADER;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_LINE A;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_DIST A;
  Positive amount loaded: 7434.40 (next billing cycle)
16. Run Voucher Build
17. Prepaid Voucher created for 7434.4 (negative amount 7328.36 not applied and should be)

18. Run Load ProCard Stage (file 5 with positive amount 8515.89 - first billing cycle to see if is charges will off set neg)
19. Run Load Statement
20. Positive amount loaded in Pcard tables. Queries:
  SELECT * FROM PS_CC_TRANS_HEADER;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_LINE A;
  SELECT A.MERCHANDISE_AMT, A.* FROM PS_CC_TRANS_DIST A;
  Positive amount loaded: 8515.89 (first billing cycle to see if pos charges will off set neg)
21. Run Voucher Build
22. Voucher created. All Negative amount applied: 8515.89 – 7328.36 – 159.75 (this one already applied).


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.