For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
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!
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
does this mean the Payment XML Extract is the same XML being used by SRA? There aren't any new or missing fields in it? thank you!
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
Thanks for the confirmation. I was thinking their XML sources might be different.
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 -
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