EAP: Excel Voucher Upload not loading Voucher into Staging tables when a Comma exists in the Amount field

(Doc ID 2273196.1)

Last updated on JUNE 02, 2017

Applies to:

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

Symptoms

Bug 23343886 - AP: VOUCHER SPREADSHEET UPLOAD-VCHR LOGS SHOWS SUCCESS BUT NO TRANSACTION LOADED has been applied.

Trying to load a Voucher using the Excel Voucher Upload spreadsheet with an amount that has a comma in the thousands position (1,500).  When Generate XML and Post, receive a message that the Voucher is imported. In addition, the Log file has the following message:

Imported  1 vouchers: (Unit, Invoice ID, Invoice Date), Description:
  (xxxxx, yyyyy, zz/zz/zzzz)  ,

Both the Synchronous Services page and the Synchronous Details page show the Status = DONE for the Service Operations = EXCELUPLOADFORVOUCHER.v1.

However, the Voucher is not loading into the VCHR_HDR_STG table.

STEPS
1.  Setup the Service Operations for EXCELUPLOADFORVOUCHER
2.  Enter a Voucher on the Excel Voucher Upload spreadsheet with Gross Invoice Amount = 1,500
3.  Generate XML and Post
4.  Generate the log file
5.  Receive the message, Imported 1 vouchers
6.  Verify that both the Synchronous Services page and the Synchronous Details page shows the Status = DONE for the Service Operations = EXCELUPLOADFORVOUCHER.v1.
7.  Check the VCHR_HDR_STG table
8.  Voucher is not being loaded in the VCHR_HDR_STG table

Changes

 

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