Modifications to iby_fd_extract_ext_pub not getting reflected in xml
Hi
To get Remittance information, added Extra sql in function Get_Pmt_Ext_Agg of package iby_fd_extract_ext_pub,
if I execute sql through sql developer for payment_id able to see data in sql developer. But in output in xml getting blank tags.
Would like to know how this issue can be addressed. details of sql used given below
SELECT DISTINCT aia.INVOICE_NUM
, decode(aia.invoice_type_lookup_code,'STANDARD','CINV','CREDIT','CREN','DEBIT','DEBN')
, aia.invoice_date
, aia.invoice_amount
, aia.discount_amount_taken
, TO_CHAR(aipa.creation_date,'YYYYMMDD')
, idpa.document_description
, iba.payment_amount