Thursday, August 25, 2011

IBY_FD_EXTRACT_EXT_PUB



Oracle Payments provides the IBY_FD_EXTRACT_EXT_PUB extensibility package to construct custom XML element structure that can be added to the payment XML extract generated by Oracle Payments. The package specification and body definition can be found in files ibyfdxes.pls and ibyfdxeb.pls respectively. These files are located in the $IBY_TOP/patch/115/sql directory.

The package allows custom elements to be created at following levels.

• Instruction
• Payment
• Document Payable
• Document Payable Line
• Payment Process Request

You cannot customize the package specification, but package body contains stubbed functions that you can customize. The five functions are as follows:

• FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER) RETURN XMLTYPE

This function allows XML element to be introduced at instruction level and run only once for the instruction.

• FUNCTION Get_Pmt_Ext_Agg(p_payment_id IN NUMBER) RETURN XMLTYPE

This function allows XML element to be introduced at payment level and run once for each payment in the instruction.

• FUNCTION Get_Doc_Ext_Agg(p_document_payable_id IN NUMBER) RETURN XMLTYPE

This function allows XML element to be introduced at document payable level and run once for each document payable in the instruction.

• FUNCTION Get_Docline_Ext_Agg(p_document_payable_id IN NUMBER, p_line_number IN NUMBER) RETURN XMLTYPE

This function allows XML element to be introduced at document payable line level and run once for each document payable line in the instruction.

• FUNCTION Get_Ppr_Ext_Agg(p_payment_service_request_id IN NUMBER) RETURN XMLTYPE

This function allows XML element to be introduced at document payable level and run once for each payment process request.

Example using the Extensibility Utility Function

The following example shows how custom XML element ReferenceFormatCode is introduced at the payment instruction level.

The function Get_Ins_Ext_Agg in the IBY_FD_EXTRACT_EXT_PUB package is altered as shown, to build custom XML elements, that are included in the XML payment extract at the Payment Instruction level. The sample code that builds a new XML element ReferenceFormatCode using the payment_instruction_id is as follows:

PACKAGE : IBY_FD_EXTRACT_EXT_PUB

/*PAYMENT INSTRUCTION LEVEL*/

/*Before Change*/

FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
RETURN XMLTYPE
IS
BEGIN
RETURN NULL;
END Get_Ins_Ext_Agg;

/*After Change */

FUNCTION Get_Ins_Ext_Agg(p_payment_instruction_id IN NUMBER)
RETURN XMLTYPE
IS
l_ins_ext_agg XMLTYPE;
BEGIN
SELECT XMLElement("ReferenceFormatCode", reference_format_code)
INTO l_ins_ext_agg
FROM iby_pay_instructions_all ipmtins
WHERE ipmtins.payment_instruction_id = p_payment_instruction_id;
RETURN l_ins_ext_agg;
END Get_Ins_Ext_Agg;;

Similar customizations are carried out on the other customizable functions described above.
Following is the list of views used for building the Funds Disbursement’s Payment XML Extract:

• IBY_XML_HR_ADDR_1_0_V
• IBY_XML_HZ_ADDR_1_0_V
• IBY_XML_FD_PAYER_1_0_V
• IBY_XML_FD_PAYEE_1_0_V
• IBY_XML_FD_PEBA_1_0_V
• IBY_XML_FD_PRBA_1_0_V
• IBY_XML_FD_DOCLINE_1_0_V
• IBY_XML_FD_DOC_1_0_V
• IBY_XML_FD_PMT_1_0_V
• IBY_XML_FD_INS_1_0_V
• IBY_XML_FD_DOC_ERR_1_0_V
• IBY_XML_FD_PMT_ERR_1_0_V
• IBY_XML_FD_PPR_1_0_V
• IBY_XML_FD_PEBAM_1_0_V
• IBY_XML_FD_PAYEEM_1_0_V
• IBY_XML_FD_PEBA_1_0_VD
• IBY_XML_FD_PEBAM_1_0_VD
• IBY_XML_FD_INS_1_0_V0
• IBY_XML_FD_PMT_1_0_V0
• IBY_XML_FD_PRBA_1_0_V0
• IBY_XML_FD_ACCT_SETTINGS_1_0_V

2 comments:

  1. nice blog good information about oracle fusion financials online training
    Thanks for posting this weblog i absolutely cherished it and submit a few specific blogs approximately oracle........visit our website related to oracle fusion all modules training for more information please check the site
    oracle all modules trainings

    ReplyDelete
  2. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here.
    Kindly keep blogging. If anyone wants to become a Front end developer learn from javascript and jquery training in chennai .
    or learn thru Javascript Training in Chennai.
    Nowadays JavaScript has tons of job opportunities on various vertical industry. javascript and jquery training in chennai

    ReplyDelete

Note: Only a member of this blog may post a comment.