My Oracle Support Banner

EAP: Voucher Build Process Failed After Applying Patches Related to RegularEntry Page Performance Issue (Doc ID 2615503.1)

Last updated on JANUARY 03, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After applying the following patches to resolve a performance issue in PI 9.2.26, UPN_ID field was added to VOUCHER_LINE.  

Image 27 Bug 27069931 : AP: PERFORMANCE ISSUE WHEN OPENING AN AP VOUCHER WITH 1000 OR MORE LINES
Image 28 Bug 27441778 : INVALID VALUE IN VOUCHER LINE. TAX_CD_VAT: (7030,607) ERROR FOR RECYCLE VOUCHER
Image 32 Bug 29260244 : AP: LOG OUT ERROR OPENING VOUCHER WITH 386 LINES AFTER UPGRADE TO TOOLS 8.56

When AP_VCHRBLD (Voucher Build) process was ran, it failed with error that VED_VLN_TAO table doesn’t have UPN_ID field.

ERROR
 
Error Step: Step APVEDTMOVE.MAIN.Step11 with SQL Error: ORA-00904: "UPN_ID": invalid identifier


STEPS
 
1.  Use Excel Upload for Voucher Template and load the Invoice. (PT 8.56)
2.  Run Voucher Build.
     Navigation: Account Payables > Batch Processes > Vouchers > Voucher Build


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.