Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Amarnath Govindu
    XML file for Disbursement Payment FormatsAnswered
    Topic posted April 19, 2019 by Amarnath GovinduBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers 
    125 Views, 4 Comments
    Title:
    XML file for Disbursement Payment Formats
    Summary:
    XML file for Disbursement Payment Formats
    Content:

    All, I cannot see any Data model attached to disburse payment templates. how to get XML file for them if we need to modify the templates?

    Best Comment

    Manish Pesswani

    Make sure you are changing output type of  'BI Template' associated with 'Payment Process Profile' (PPP) which you are going to select while doing the payment

    Comment

     

    • Manish Pesswani

      Change Output type as XML at template level in BI Catalog.

       

      Make a payment , you will get xml as output file in ESS job (Format Payment File).

      Oracle may not allow you to change output type on seeded path , hence you need to customize the template by navigating to BI publisher.

    • Manish Pesswani

      Make sure you are changing output type of  'BI Template' associated with 'Payment Process Profile' (PPP) which you are going to select while doing the payment

    • Kamrul Alom

      Hi,

       

      Having just editing Payment Files myself for a client's bank, this is the process you want to follow:

       

      1. Go to BI Publisher (Reports & Analytics > Browse Catalogue > Folders)
      2. Copy across the report, Disbursement Payment File Formats, across from the folder Payments (In Financials) into Custom
      3. Now Open it and click edit on ISO20020SEPAV5_0 V5 and it will download the XML code you need
      4. This code then needs to be edited (use notepad ++) for the best experience and tailor it to the experience you need and save it as a XSL file
      5. Now upload the file to BI Publisher in the same folder, as an XSL and change the output format (click View as a List and change) as XML
      6. Now, create a payment process profile with a name for the payment file you uploaded
      7. Create a Payment Process (Pay In Full) on a Invoice and test for the experience