My Oracle Support Banner

EAP: Voucher Build Staging Table Does Not Accommodate Fields TAG_NUMBER And SERIAL_ID (Doc ID 2734085.1)

Last updated on DECEMBER 09, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Unable to populate vouchers with fields TAG_NUMBER and SERIAL_ID after running Voucher Build.

  
STEPS

1. Run the following SQL:


    SELECT * FROM PSRECFIELD WHERE RECNAME IN ('VCHR_DIST_STG','DISTRIB_LINE') AND FIELDNAME IN ('TAG_NUMBER','SERIAL_ID');

    Above query yields rows where the fields TAG_NUMBER and SERIAL_ID are present only in PS_DISTRIB_LINE but not in the staging table VCHR_DIST_STG.
 


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
Cause
Solution


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