Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Mohammed Rafi
    Customize Disbursement Payment File Formats
    Topic posted May 8, 2019 by Mohammed RafiBlack Diamond: 60,000+ Points, tagged Payables 
    344 Views, 19 Comments
    Title:
    Customize Disbursement Payment File Formats
    Content:

    Hi,

    I need to add DFF segment in Disbursement File Formats for the data model named ZA 574

    As I am doing this for first time kindly advise how to customize to include the DFF segment

    Thank you

    Comment

     

    • Felix Beaudoin

      Hey Mohammed!

      I've had the same requirement in the past and after hours on OWCs with Oracle. In fact, I still do with new clients to this date. Turns out that Cloud doesn't let you do this as easily as it use to. It only let's you populate information in the seeded fields that are output in the Format Payment output after generating your payment file. Maybe this is what you are looking for?
      How to Edit the XML For the Payment Format File (Doc ID 2278579.1)

      Let me know if this helps and if you managed to make it happen with what I have provided.
      Regards,
      Felix

    • Mohammed Rafi

      Thanks Felix.

      As understood I need to create new template and then attach to payment process profile with the DFF segments

      Ouput should be made as XML

      Hope my understanding and way of doing is correct please advise

      • Felix Beaudoin

        Hey Mohammed!

        That is my understanding as well. The only main issue is that apparently... there are no more DFFs at PPP level :O
        Are you able to setup DFFs on that page? When I click "Highlight Flexfields" that page has no DFFs available.
        Let me know, thanks!
        Regards,
        Felix

    • Isaline Nguyen

      Hello Mohammed & Felix,

      Go to Task: Manage Payment System Connectivity Flexfields. Click search, select Payment Process Profiles, edit, and then you can add the global segment you want (or context segment), input the name, value set, default type, default value, display prompt and display type/size/height. Click save & close. Make sure to validate and deploy flexfield. 

      Now it should show the field you created under Additional information when editing Payment Process Profile.

      Let us know,

      Isaline

      • Felix Beaudoin

        Awesome, thanks Isaline! Now we only have to figure out how to pull this DFF from the PPP to the XML Payment Format driven by the Payment Disbursement File Format of BIP.

      • Mohammed Rafi

        Hello Isaline,

        My requirement is quite different. In the input XML ZA 574 need to edit and the include the DFF which is ATTRIBUTE2 enabled in the Supplier Page.

        Attached screenshot showing the DFF enabled in the Supplier page and the label name is BOP Code

        I have also attached the ZA 574 (V2.xsl) file which need to be modified.

        Kindly suggest the way to achieve the requirement

        Thanks

         

         

        • Felix Beaudoin

          Hey Mohammed!
          We are actually stuck with the same problem right now. We have a DFF in ATTRIBUTE1 of our PPP which we want to pull into the XML output but have no idea how to achieve this. Oracle is not being very helpful in our SR where the only instructions we are receiving is to "Customize your XLS Report in BIP to pull-in this information". I'll dig for some documentation and let you know if I find anything more concrete.
          Regards,
          Felix

          • Kamrul Alom

            Hi Felix,

            I came across some documentation that help me add xml that allows you to "Customize your XLS Report in BIP to pull-in this information". I did this for a RTF within the PPP process, upon which the Remittance Advice is sent.

            Based on my experiences, you can call fields in the PPP with codes like this in an rtf:

            <?xdofx:if OrganizationName = 'Limited' THEN ’ Ltd’ ELSE if OrganizationName = '(Pty) Ltd' THEN '(Pty) Limited' ELSE if OrganizationName = 'IFM Limited' THEN 'I. F. Managers Limited' ELSE OrganizationName end if?>

            <?//InstructionGrouping/Payer/Address/PreFormattedMailingAddress?>

            Once you run the Pay in Full process, the RTF generated produces the data from the field. I'm assuming the XML code will be different but could follow a similar process.

            I used the tables in the link to refer to the fields I needed. therefore for the DFF, I assume we can use it too. But we will need to find the table that the DFF is nested into.

            Documentation https://docs.oracle.com/cd/E18727_01/doc.121/e13416/T387353T486430.htm

            https://docs.oracle.com/cd/E18727_01/doc.121/e13416/T387353T486429.htm

    • Mohammed Rafi

      Uploaded the image

      • Felix Beaudoin

        Yep, looks almost exactly like our but instead of being at the supplier level, it's in the configuration pages. Part of the "Additional Information" area. Now, let's figure out how to get this data into our XML outputs.

        • Mohammed Rafi

          Thanks Felix. I will be raising SR let me if some one helps me out.

          Keep you posted on the progress of SR

        • Mohammed Rafi

          Meanwhile please help me is there way to identify the tag for the field which we need to include in the XSL file

          • Felix Beaudoin

            Once you have your payment formatted, use this query to identify the XML tags available in your output.
            SELECT document FROM IBY_TRXN_DOCUMENTS WHERE payment_instruction_id in (
            select payment_instruction_id from IBY_PAYMENTS_ALL where payment_process_request_name = 'PAYMENT_PROCESS_REQUEST_NAME')

            The PPR name is the value you input in the query.

            • Marcus Comins
              Hi Felix Check my reply to Mohammed and see if this works for PPP DFFs. Thanks Marcus
              • Felix Beaudoin

                Hey Marcus!
                Thanks for the update. I agree with your comment above. Oracle told me the same thing on the SR. The only issue we have is that there is no data model for "Disbursement Payment File Format" and also, our template is XLS and not RTF. I've done many modifications using DFFs in the past but not for payments which is why I am struggling. I would typically just add the query logic in the data model to pull the field and then export the sample data to be used in BI Publisher for Word (RTF). Any idea how we achieve this for an XLS without a data model?
                Regards,
                Felix

      • Marcus Comins
        Hi I think that if you need the supplier DFF to be in the disbursement XML you need to make it a CONTEXT DFF segment, not global. It should work fine then and you can use it on your template. Give it a go and let me know Thanks Marcus
        • Felix Beaudoin

          Hey Marcus and everyone!

          On our end, adding the context DFF on the PPP made it appear automatically in the XML output. No additional steps were required.
          Therefore, if it is in the XML output, technically, all we need to do is provide the path within the XLS Payment Template such that the attribute configured gets pulled into the payment output?
          Let me know if this makes sense.
          Thanks!
          Regards,
          Felix

    • Felix Beaudoin

      Hi Everyone!

      I have the solution for mapping the DFF to a payment file output. Depending on whether you are using an RTF or a XLS, the mapping is slightly different. I'll start with the common steps:
      1- Configure the DFF in the Payment Process Profile. Make sure that this DFF is a "Context" DFF and that once it is setup, on the main configuration page of that DFF area, it is not marked as "Hidden". I was wondering why it would not appear for me and it's because this drop-down was not flagged as "List of Values".
      2- Once configured, deploy the DFF and go into your PPP to assign the Context and the Value of the DFF.
      3- Create an invoice (if it does not already exist) and then Submit the Payment Process Request. This is assuming that your PPR Template is already setup and linked to your PPP.
      4- Submit the payment once the installments are validated and then resume the payment process request (this depends on your setups of course) so that the Payment File gets formatted.
      The next steps is where it differs. If you have an RTF, follow these steps:
      1- Navigate the Scheduled Processes and find the "Format Payment File" job. Download the XML output.
      2- Download your RTF template from the BI Publisher (XMLPSERVER) area and then open it in Word.
      3- Upload your XML file from step 1 into the RTF template using the BI Publisher add-on.
      4- Dynamically insert your value (Attribute of your context DFF) OR provide the XML path to the field depending on how you are handling your RTF.
      5- Save and upload your RTF.
      6- Test and confirm that your value is being pulled.
      Now, if you have an XLS file, it's the same steps as above except that an XLS, you cannot dynamically insert the values using the BI Publiser add-on.
      You should download your template from the XMLPSERVER and then open it in NOTEPAD++ or any other tool you prefer to modify your file with.
      Then, you provide the XML path (ex: /OutboundPaymentInstruction/PaymentProcessProfile/DescriptiveFlexField/Attribute1) for the XML ID you are trying to populate. Save, upload, retest. If it does not output, you should validate your XML path and the location you have put it in.

      This worked like a charm for me! Don't hesitate if you have any questions.

      Regards,
      Felix

      • Felix Beaudoin

        My bad! I confused the "Format Payment File" with the XML that has the tags. You need to query the system to get those tags. Replace steps 1 above with a query to obtain your XML output.

        SELECT document FROM IBY_TRXN_DOCUMENTS WHERE payment_instruction_id in (
        select payment_instruction_id from IBY_PAYMENTS_ALL where payment_process_request_name = 'PPR Name');

        You can then copy the value obtained from this query into NOTEPAD++, use CTRL-SHIFT-ALT-B to format it automatically into XML to facilitate the path definition of your XLS in the final step.