EAP: Voucher Spreadsheet Upload Issue- Message /Vchr Logs Shows Success But No Transaction Loaded
(Doc ID 2194828.1)
Last updated on MAY 29, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When the Excel file has some "invalid" formats, the upload process still says the transactions loaded successfully and New log file says that too but it doesn't tell what failed and the data is not loaded in the staging tables.
The issue can be reproduced at will with the following steps:
1. Gross invoice amount has an invalid format in the ExcelUploadforVouchers Spreadsheet. I have set the amount as 24357,1.
2. Click on Generate XML and Post.
3. Per the message and the Log file, Vouchers are successfully imported.
4. Checking the transaction in Staging Header Table (PS_VCHR_HDR_STG):
No data is loaded in staging table even the log is showing the vouchers are successfully imported.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!