My Oracle Support Banner

EAP: How to populate VCHR_LINE_STG data in Excel Voucher Upload Spreadsheet when multiple distribution line exists (Doc ID 1466679.1)

Last updated on JUNE 12, 2023

Applies to:

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


When using the Excel Voucher Upload Spreadsheet to load Voucher data with multiple distribution lines, the system loads VCHR_LINE_STG incorrectly.  It is only loading the first line and skips other lines.

* No. of Vouchers = 1
* No. of Invoice lines = 3
* No of Distribution lines for Invoice Line 1 = 51
* No of Distribution lines for Invoice Line 2 = 1
* No of Distribution lines for Invoice Line 3 = 4

1. Populate VCHR_HDR_STG data only once in the Data sheet of the Template
2. Populate VCHR_LINE_STG data with as many rows as there are Distribution Lines for each Invoice Line.  For example, 51 times for Invoice Line 1, 1 time for Invoice Line 2 and 4 times for Invoice Line 3.
3. Populate VCHR_DIST_STG data for each row
4. Generate and Post XML

PS_VCHR_LINE_STG = 1 row (There should be 3 rows)
PS_VCHR_DIST_STG  = 56 rows


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

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