My Oracle Support Banner

EAP: EXCEL VOUCHER UPLOAD SPREADSHEET Primary Resolution for Setup and Issues (Doc ID 645715.1)

Last updated on FEBRUARY 19, 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.

This document was previously published as Customer Connection Solution 201002395









Purpose

The purpose of this knowledge document is to act as a repository for the Excel Voucher Upload Spreadsheet regarding Setup and Issues.

Questions and Answers

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
Purpose
Questions and Answers
 Configuration and setup document for the Excel Voucher Upload Spreadsheet
 How to setup security for Excel Voucher Upload
 VOUCHER_BUILD messages staying in "New" status
 Error -- An error occurred during the upload. Please check to make sure your settings are correct.
 Error -- Unable to find a Routing corresponding to the incoming request message.
 Error -- Error occurred while parsing XML: document is empty or is not XML. (0,0)
 Error -- No Vouchers were processed due to missing key information
 Error -- VOUCHER_BUILD error at FUNCLIB_APEIP.VOUCHER_ID.FieldFormula
 Error -- Invalid AP Business Unit found on the Voucher Header of the XML doc.
 Error -- Rate Multiplier must be provided when Currency Rate Source is "User Specified"
 Excel Voucher Upload does not load data into VCHR_HDR_STG table
 Excel Upload Voucher Vchr_line_stg.Vat_applicability Not Populated Although Xml File Has Values
 Excel Voucher Upload not populating staging tables
 Using ExcelUploadforVoucher.xls does not generate any error messages but the STG tables are not being loaded.
 Excel Voucher Upload is running slow -- Performance issue
 Voucher Build checking User Preferences Payables Online Vouchering options for XML Vouchers
 ExcelUploadforVoucher.xls has hidden sample data
 Excel Voucher Upload loads Vouchers in an incorrect random order
 SPEEDCHART_KEY field not available through Voucher ExcelUpload
 Unable to Load Vouchers with Remit Bank and Payment Message using Excel Upload
 Voucher Excel Upload performance issue after upgrade to Tools 8.48
 "DEST.XML" is not automatically populated in the Save As dialog box
 Not able to load Vouchers with Remit Bank and Payment Message
 Questions regarding associating a PO using ExcelUploadforVoucher Spreadsheet
 Single payment voucher processing
 SPEEDCHART_KEY field not available
 Double-byte Japanese characters are corrupted
References

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