Payables and Cash Management - EBS (MOSC)

MOSC Banner

Adding invoice description to payment advice

edited Apr 2, 2020 5:02AM in Payables and Cash Management - EBS (MOSC) 4 commentsAnswered

In 12.1.3, when adding invoices description to EFT payment advice through IBY_FD_EXTRACT_EXT_PUB the solution works fine in all non-prod instance. However, the same pulls no descriptions and leaves it blank. Is there some sort of setup I need to check to ensure the is working? Not that non-prod instance are refresh from production.

  FUNCTION Get_Doc_Ext_Agg(p_document_payable_id IN NUMBER)

  RETURN XMLTYPE

  IS

    l_ins_doc_agg XMLTYPE;

  BEGIN

    --

    Select XMLConcat(XMLElement("Extend", XMLELEMENT("DocumentDescription", ai.description)))              

    INTO l_ins_doc_agg

    FROM iby_docs_payable_all dp,ap_invoices_all ai

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