EAP EXCEL UPLOAD FOR VOUCHER ERROR WHEN VCHR_PYMNT_STG.PYMNT_MESSAGE HAS '&' (Doc ID 2238987.1)

Last updated on FEBRUARY 28, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

During the Spreadsheet Voucher upload, an error is encountered due to an ampersand in VCHR_PYMNT_STG.PYMNT_MESSAGE field

ERROR
-----------------------
"An error occurred during the upload.
Please check to make sure your settings are correct."



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable Financial Sanctions
2. Open Excel Upload for Vouchers file
3. Update value at VCHR_PYMNT_STG.PYMNT_MESSAGE to have an embedded ampersand ('&')
4. Click Generate XML and Post button
5. Click Save when prompted to save DEST.XML
    Message says 'The process successfully finished.'
6. Click Ok
    Error is generated.

  The error message only reads:
  "An error occurred during the upload.
  Please check to make sure your settings are correct."

  This is the issue.

7. Replace the value of VCHR_PYMNT_STG.PYMNT_MESSAGE by removing the embedded ampersand ('&')
8. Save the spreadsheet
9. Click Generate XML and Post
10. Supply Id and Password when prompted.
11. Click OK
12. Save the generated DEST.XML
13. Message says 'The process successfully finished.'
14. Click Ok
15. No error is generated which proves that the ampersand ('&') at VCHR_PYMNT_STG.PYMNT_MESSAGE caused the issue.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot embed ampersand on VCHR_PYMNT_STG.PYMNT_MESSAGE if needed.

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