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:

Goal

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.

STEPS
* 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

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

Solution

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