Payables and Cash Management - EBS (MOSC)

MOSC Banner

Custom IBY_FD_EXTRACT_EXT_PUB.Get_Doc_Ext_Agg Please help

edited Jul 17, 2017 4:43AM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered

Hi All

I need Remiitance_message1 in my SEPA xml output

So I customized Get_Doc_Ext_Agg:

Get_Doc_Ext_Agg(p_document_payable_id IN NUMBER)

RETURN XMLTYPE

IS

XMLTYPE;


CURSOR l_doc_ext_csr (p_document_payable_id IN NUMBER) IS

SELECT XMLCONCAT(

XMLElement("IIK",

XMLElement("MESSAGE1",REMITTANCE_MESSAGE1),

XMLElement("MESSAGE2",REMITTANCE_MESSAGE2))

)

FROM iby_docs_payable_all

document_payable_id=p_document_payable_id;

BEGIN

OPEN l_doc_ext_csr(p_document_payable_id);

FETCH l_doc_ext_csr INTO l_doc_ext_agg;

CLOSE l_doc_ext_csr;

RETURN l_doc_ext_agg;

END Get_Doc_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