EeS: cXML Invoice Load Process EM_XML_LOAD GIVES ERROR WHEN FILE ATTACHMENT IS URL With Type SFTP

(Doc ID 2264019.1)

Last updated on MAY 09, 2017

Applies to:

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

Symptoms

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."

STEPS
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

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