Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Juan Miguel Isip
    Obtain the XML extract for Send Separate Remittance Advice...Answered
    Topic posted September 15, 2018 by Juan Miguel IsipSilver Medal: 2,000+ Points, last edited January 30, 2019, tagged Configuration, Financials, Payables, Reports, Sample Reports 
    377 Views, 5 Comments
    Title:
    Obtain the XML extract for Send Separate Remittance Advice (SRA) in Oracle Fusion Payments
    Summary:
    How can I obtain the XML extract for Send Separate Remittance Advice (SRA) in Oracle Fusion Payments?
    Content:

    I have the same question as the one posted in the Community forums (https://community.oracle.com/thread/4056438?parent=MOSC_EXTERNAL&sourceId=MOSC&id=4056438)

    We need to modify the report layout and need the XML data for testing purposes. 
    How can I obtain the XML extract for Send Separate Remittance Advice (SRA) in Oracle Fusion Payments?
    I found the Document 1578383.1 (R12: AP: How to get XML data for Send Separate Remittance Advice format) but it is applicable only to EBS.
    There is no other information on how to get XML Extract of Separate Remittance Advise in metalink.

    Thanks!

    Best Comment

    Nishanth B Jain

    Yes it is same XML for both  payment and SRA. We don't have access to data model to add our custom columns.

    Thanks,

    NJ

    Comment

     

    • Nishanth B Jain

      Hi,

      In order to generate xml, you need to run PPR(Make one payment). Once PPR completes successfully check the ESS job log, It will contain xml for the payment which is used in Separate remittance advice.

      Thanks,

      NJ

    • Kamrul Alom

      Hi,

      How can I obtain the XML extract for Send Separate Remittance Advice (SRA) in Oracle Fusion Payments?

      The key is that there is an extract documentation that allows you to build XLS tags to call a field. Or you can tweak the seeded format and move the fields around or copy a code and tweak it to your needs.

      The Solution to create your own layout/Remittance advice wherein you require the XML tags/extract for Send Separate Remittance Advice (SRA) in Oracle Fusion Payments. To do this, you can download the seeded format and edit from there, Disbursement Separate Remittance Advice Formats (Separate Remittance Advice), or you can start from scratch. But it's best to use the seeded template (click Edit and it will download), as the tags are there and you can rearrange it for your own needs (i.e. order, tweak...). My advice would be to use the Template Builder Extension and Click on the BI Publisher Tab on the Seeded RTF and it will show you their tags and how they achieved it (the XLS/XML code extracting it).

      Alternatively use the extract document:

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

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

      These documents tell you the tags associated with the fields you need for testing. The way you can insert a field into your RTF is to use an expression in the following format:

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

      Logic based ones:

      <?xdofx:if OrganizationName = 'IAM Limited' THEN ’accounts.payable@investecmail.com’ ELSE if OrganizationName = 'ZA Ltd' THEN 'iamsaaccountspayable@investecmail.com' ELSE if OrganizationName = 'Limited' THEN 'accounts.payable@mail.com' ELSE OrganizationName end if?>

      Using the links, find the tag and them add <?//"Table; i.e. OutboundPaymentInstruction"/"Tag needed; i.e. PaymentFormat"?>

      Hope this helps,

      Kam -