Voucher Build is not Generating Correct VAT Information When Procurement Card Statements have VAT (Doc ID 2991648.1)

Last updated on DECEMBER 07, 2023

Applies to:

Symptoms

Voucher Build is not Generating Correct VAT Information When Procurement Card Statements have VAT.

When the load voucher stage process it is not transferring the VAT_RCVRY_PCT_SRC value from Procurement Card to Voucher. Voucher Build is updating the VAT_RCVRY_PCT_SRC as “A”(Automatically Calculated) in DISTRIB_LINE table but it is “M” (manual) in CC_TRANS_DS_VAT table.

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

1. Run Load PCard Stage. Navigation: Menu > Purchasing > Procurement Cards > Process Statements > Load Pcard Stage
2. Error listed. Navigation: Menu > Purchasing > Procurement Cards > Process Statements > Correct PCard Statement Errors
3. Cardholder Profile. Add the card number. Navigation: Menu > Purchasing > Procurement Cards > Definitions > Cardholder Profile
4. Go Back to Correct Statement Errors. No error listed
5. Run Load Pcard Statement. Navigation: Menu > Purchasing > Procurement Cards > Process Statements > Load Pcard Statement
6. Reconcile page. Navigation: Menu > Purchasing > Procurement Cards > Reconcile > Reconcile PCard Statement
7. Go to distribution icon and go to Distribution VAT
8. Recovery Percent is 100.00. Change it to 40 and recalculate. Return to Distribution page. Ok and save
9. Query: SELECT A.VAT_RECOVERY_PCT, A.* FROM PS_CC_TRANS_DS_VAT A; It is showing VAT_RECOVERY_PCT = 40
10. Go back to Reconcile Statement page and click on distribution icon again and go to Distribution VAT icon
11. It is showing the original Recovery Percent. The information is not matching to backend information
12. Approve the transaction at Reconcile page and save.
13. Run Load Voucher Stage. Navigation: Menu > Purchasing > Procurement Cards > Process Statements > Load Voucher Stage
14. Run Voucher Build. Navigation: Menu > Accounts Payables > Batch Process > Vouchers > Voucher Build
15. Voucher created. Navigation: Menu > Accounts Payables > Vouchers > Add/Update > Regular Entry
16. Go to Distribution Lines VAT link. It is exactly the same information from Pcard Reconcile page. It is showing Recovery Percent 100.
17. Go to Voucher VAT summary page link. It is also showing VAT Recovery 100.
18. Check Voucher VAT Details. Navigation: Menu > Account Payables > Review Account Payables Info > vouchers > VAT Details. VAT recovery is not matching to Voucher page summary

Changes

Cause

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