EAP: Voucher Spreadsheet Upload Issue- Message /Vchr Logs Shows Success But No Transaction Loaded
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms