My Oracle Support Banner

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 SEPTEMBER 19, 2022

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information 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:

  1. 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
  2. Cardholder Profile. Add credicard Number '1234567898166' to 'DeJackome,Isobel' . Navigation: Purchasing > Procurement Card > Definitions > Cardholder Profile

Steps:

  1. Run Load PCard Stage. Navigation: Purchasing > Procurement Card > Process Statement > Load Pcard Stage
  2. 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. 3. Run Load PCard Statement. Navigation: Purchasing > Procurement Card > Process Statement > Load Pcard Statement
  4. 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
  5. Run Load Voucher Stage. Navigation: Purchasing > Procurement Card > Process Statement > Load Voucher Stage
  6. 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
  7. 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
  8. 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


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