EBS Customizations (MOSC)

MOSC Banner

Issues extending Get_Pmt_Ext_Agg in IBY_FD_EXTRACT_EXT_PUB package

edited May 23, 2018 5:00AM in EBS Customizations (MOSC) 1 commentAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center