Error 'Unable to determine the VAT Code and/or the Transaction Type' When Build a Voucher From P-Card Transaction
(Doc ID 2871298.1)
Last updated on JUNE 03, 2024
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
Error message when build a voucher from P-Card transaction.
When run Voucher Build process to create Pre-payment voucher from PCard Statement getting the error message:
'Unable to determine the VAT Code and/or the Transaction Type'.
This is happening due to VCHR_LINE_STG.VAT_TXN_TYPE_CD that is populated with blank in PO_CCVCHRSTG process.
The issue can be reproduced at will with the following steps:
Setup:
- US Bank PCard Issuer. Create Prepayment Voucher checked and AP Business Unit = 'CAN01'. Navigation: Setup Financials/supply Chain > Product related > Procurement Options > Purchasing > Pcard Card Issuers
- Cardholder Profile. Add credicard Number '1234567898166' to 'DeJackome,Isobel' . Navigation: Purchasing > Procurement Card > Definitions > Cardholder Profile
Steps:
- Run Load PCard Stage. Navigation: Purchasing > Procurement Card > Process Statement > Load Pcard Stage
- At Correct Pcard Statement Erros update statement #4 to Card Number: ‘1234567898166’. Save it. Navigation: Purchasing > Procurement Card > Process Statement > Correct PCard Statement Errors
- 3. Run Load PCard Statement. Navigation: Purchasing > Procurement Card > Process Statement > Load Pcard Statement
- 4. Go to PCard Reconciliation page. Approve transaction of P-card for Credit Card ‘1234567898166’. And save it. Navigation: Purchasing > Procurement Card > Reconcile > Reconcile PCard Statement
- Run Load Voucher Stage. Navigation: Purchasing > Procurement Card > Process Statement > Load Voucher Stage
- Execute query: Select A.VAT_TXN_TYPE_CD ,A.* From Ps_Vchr_Line_Stg A Where Business_Unit = 'CAN01'; Note that VCHR_LINE_STG.VAT_TXN_TYPE_CD is blank
- Now run AP_VCHRBLD to build vouchers from staging tables. Due to VCHR_LINE_STG.VAT_TXN_TYPE_CD is blank, voucher is not built. Navigation: Accounts Payables > Batch Process > Vouchers > Voucher Build
- When process finished. Go to Build Error. Voucher not created due to error message: ‘Unable to determine the VAT Code and/or the Transaction Type’
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 |