EeS: cXML Invoice Load Process EM_XML_LOAD GIVES ERROR WHEN FILE ATTACHMENT IS URL With Type SFTP
Last updated on MARCH 08, 2018
Applies to:PeopleSoft Enterprise FIN eSettlements - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When running the Load Attached Invoices EM_XML_LOAD process, the process ends in success but the following message is received in the log:
"Supplier xxxxx had the following error: An invalid parameter has been passed to the file attachment function. (2,788) EM_PACKAGE.Supplier.
Supplier xxxxx had the following number of invoice files processed: 0"
This happens when Administer File Attachments is set to URL.
The issue occurs on the method LoadXMLInvoice called from EM_PACKAGE.Supplier.OnExecute. The trace shows the following:
"IsURLValid (error): specified URL (URL:COMMON_ATTS_RECORD/) does not start with a supported destination-indicating prefix.
Caught Exception: An invalid parameter has been passed to the file attachment function. (2,788) EM_PACKAGE.Supplier.OnExecute Name:LoadXMLInvoice PCPC:39983 Statement:529
Called from:EM_XML_LOAD.LOAD_INV.GBL.default.1900-01-01.Step01.OnExecute Statement:5"
After applying the fix for <Bug 25814159>, the following errors are received:
"ExecuteGetAttachment (error): Error: URL Identifier not provided. Use URL Identifier to connect."
"EvalGetAttachment (error): return code (1) indicates attempt to download file from storage failed."
1. Setup the system to load invoices
2. Navigate to eSettlements > Supplier Information > Load and Review Invoices
3. Choose Supplier then add attachment by clicking the Attachment link
4. Navigate to eSettlements > Batch Processes > Load Attachment Invoices
5. Run load Attached process EM_XML_LOAD
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