EAP: Voucher Spreadsheet Upload Issue- Message /Vchr Logs Shows Success But No Transaction Loaded (Doc ID 2194828.1)

Last updated on DECEMBER 25, 2016

Applies to:

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

Symptoms

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.

STEPS:

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.


Cause

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