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 later
Information in this document applies to any platform.

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’

	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

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