Issues extending Get_Pmt_Ext_Agg in IBY_FD_EXTRACT_EXT_PUB package
Hi,
EBS version is 12.2.6.
I am trying to add custom tags in Get_Pmt_Ext_Agg function as below. However, when 'Send Separate Remittance Advices' program runs, these tags are not added in the xml document.
Note: when I run the sql on its own, I do get a record for that payment_id.
FUNCTION Get_Pmt_Ext_Agg(p_payment_id IN NUMBER) RETURN XMLTYPE IS l_pmt_ext_agg XMLTYPE; CURSOR l_pmt_ext_csr (p_payment_id IN NUMBER) IS SELECT XMLConcat( XMLElement("Extend", XMLELEMENT ("CheckDate", aca.check_date), XMLELEMENT ("CheckNumber", aca.check_number) ) ) FROM apps.ap_checks_all aca where payment_id = p_payment_id ; BEGIN OPEN l_pmt_ext_csr (p_payment_id); FETCH l_pmt_ext_csr INTO l_pmt_ext_agg; CLOSE l_pmt_ext_csr; RETURN l_pmt_ext_agg; EXCEPTION when others then fnd_file.put_line(fnd_file.log,'ERROR: '||SQLERRM); raise; END Get_Pmt_Ext_Agg;