Clarification on Lockbox File Naming Requirements for JP Morgan Integration — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Clarification on Lockbox File Naming Requirements for JP Morgan Integration

in Receivables & Collections 3 comments

Summary:

Name of Lockbox file for AR receipts

Content (please ensure you mask any confidential information):

We are currently configuring the JP Morgan integration and would like to confirm the file naming requirements for Lockbox.

The documentation suggests that the file name must end with “_mmddyyyy,” and testing with this format worked successfully.
https://docs.oracle.com/en/cloud/saas/financials/25c/fairp/lockbox-transmission-formats.html

However, JP Morgan indicated the following format, and a file received with this naming convention could not be imported into Oracle:
ORAIAYXQY.ORALB.2037267.021000021.SHMA.<H2HSequenceNumber>.<MMddyyyyHHmmssSSS>.txt

Could you confirm which file naming formats are supported in Oracle, and what other clients using JP Morgan integration typically adopt?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!