How to fetch the ultimate creditor information from the CAMT.053 file in Oracle Cash Management? — 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

How to fetch the ultimate creditor information from the CAMT.053 file in Oracle Cash Management?

edited Aug 1, 2025 9:05AM in Payables, Payments & Cash Management 1 comment

Summary:

We have a requirement to create external transactions rule in Oracle Cloud Cash Management based on the information available in CAMT053 file. The information is captured in the following section of the CAMT053.001.02 file:

<NtryDtls> —> <TxDtls> —> <RltdPties> —> <UltmtCdtr> —> <Id> —> <OrgId>


We cannot find this ID in the CE_STATEMENT_LINES table. In which table this data will be available?

How can we fetch the details in front-end? Can parse rule sets be used?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):


<?xml version="1.0" encoding="UTF-8"?><Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.053.001.02" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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