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 DOCUMENT_CLOB gets populated in IBY_TRXN_DOCUMENTS table?

We have requirements to create custom payment documents. We are reusing ISO20022CGI.xsl file from Disbursement Payment File Formats. The data model has SELECT DOCUMENT_CLOB FROM IBY_TRXN_DOCUMENTS WHERE TRXN_DOCUMENT_ID =:TRXN_DOCUMENT_ID query. When I query DOCUMENT_CLOB, it shows empty. I want to understand if we have to fetch some information which is not available in the ISO20022CGI.xsl file how can we do it?

I have seen IBY_TRXN_DOCUMENTS.DOCUMENT holds 2 xml file after doing the payment. One xml file holds many information. Another one has only those xml tags which gets generated through ISO20022CGI.xsl.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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