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