Friday 25 October 2013

Remittance Advices R12 (Send Separate Remittance Advices)

To Configure e-mail Remittances in R11, AP Remittance Advice (APPEWF) Workflow will be fired automatically based on business Event oracle.apps.ap.payment
 
R12 this workflow obsoleted. Oracle has given Send Separate Remittance Advices . To work this before we need to disable the below Business Event.

1. Login using the SYSADMIN user
2. Responsibility: Workflow Administrator Web Applications
3. Navigate:  Administrator Workflow -> Business Events.
4. Search Criteria  = oracle.apps.ap.payment , Click Go.
5. Click the "Subscriptions" icon for the Payment Event.
6. Click the Edit icon for ap_payment_event_wf_pkg.rule_function
7. Change the Status from "Enabled" to "Disabled" in Execution Condition Region.
8. Click Apply.

Step1
First we need to set up xdodelivery.cfg  based on e-mail,print and fax  which ever we want.
If the requirement is Email then find the correct SMTP host name and save the file in $XDO_TOP/resource/xdodelivery.cfg

<?xml version="1.0" encoding="UTF-8" ?> 
<config xmlns="http://xmlns.oracle.com/oxp/delivery/config"> 
<servers> 
<server name="mysmtp1" type="smtp_email" default="true"> 
<host>myhost.mydomain</host> 
<port>25</port> 
</server> 
</servers> 
<properties> 
<property name="ds-temp-dir">/tmp</property> 
<property name="ds-buffering">true</property> 
<property name="SMTP_CONTENT_TYPE:String">"application/pdf"</property> 
</properties> 
</config>

Step2
Set the Profile Option IBY: XML Publisher Delivery Manager Configuration File
Ex /u01/app/UATBAU/apps/apps_st/appl/xdo/12.0.0/resource/xdodelivery.cfg

Step3
Configure Profile options

IEX: SMTP From
Should Specify the E-mail From Address

IEX: SMTP Host
Should Specify the E-Mail host.

Step4
Login to the application.
Responsibility = Application Developer
Navigate : Application -> Messages

Query
IBY_FD_SRA%

Two Messages are returned.
IBY_FD_SRA_EMAIL_FROM
The Seeded message is...
account_payables@visioncorp.com

and the other
IBY_FD_SRA_EMAIL_SUBJ
The Seeded message is...
Separate Remittance Advice: payment reference number - &PMT_REF_NUM

Modify those messages to meet your requirement.

Step5

Configure the Separate Remittance Advice Delivery Method at Supplier and Supplier Site.

Step6

Specify the Separate Remittance Advice Format when configuring the Payment Process Profile.

Reporting Tab

Format - Specify The Remittance Advice Format you wish to use for this PPP Automatically Submit at Payment Completion Point -
              Check the Box for Automatic Submission
              Allow Multiple Copies for Payment Instruction - Check The Box if you want the user to be able to  print more than once.Condition



Step7.

Now Send Separate Remittance Advices will triggered after Payment Process Request. After finishing request supplier receive an automatic email with content designed in IBYR_SRA.rtf.

You can amend if you have any changes then upload it.

P.S.
Send Separate Remittance Advices will not send the output as an PDF attachment, because of  Bug 8208646  its an oracle enhancement request.
So this is going to be customization and have to create own data definition,template  and we need to attach bursting file to data definition for automatic Email functionality.
       
          
Posted by at

25 comments:

  1. OracleAppsCentral4 February 2014 at 08:15

    Well done Anil! Clear and concise steps..

    ReplyDelete
  2. Anonymous6 February 2014 at 15:15

    For my client we have ACH Payment cycle that runs Send Remittance Advice. This cycle further alse runs a Card Services ACH Payment cycle... here again Send Remittance Advice is submitted.

    Is there any way to disable this for one program and keep it going for another?

    Thanks

    ReplyDelete
    Replies
    1. Anonymous13 February 2014 at 02:43

      You can stop remittance when you create Payment Process Profile

      Delete
  3. Anil M7 February 2014 at 01:46

    I have no idea on ACH payments.
    The only way we can stop Send Remittance Advice when ACH Payment Cycle & Card Services ACH Payment cycle uses two different payment profiles.

    ReplyDelete
  4. omughal26 March 2014 at 20:01

    Hi Anil,
    Thanks for your blog. Do you know how to solve the problem of having two different remittance formats in the SAME payment run?
    Omar

    ReplyDelete
  5. Anil M27 March 2014 at 02:21

    Omar,
    We can't handle that scenario.
    The Payment run is combination of Unique Format & Unique Profile.
    Anil

    ReplyDelete
  6. Anonymous8 May 2014 at 17:26

    Hi Anil,

    I have a requirement where in Oracle R12 Under Suppliers > Payment details > Send separate Remittance > Delivery Method ..I need Delivery Method's List of values to be customized ,As in there are various values in the lOV like Emain,Print,Post ,Blank..I need Blank to be removed..Would you know the source of this LOV..I tried finding the Lookup values,Valuesets.


    Rgds,Meenu

    ReplyDelete
  7. Anil M12 May 2014 at 09:42

    Meenu,

    The lookup is IBY_DELIVERY_METHODS (application =Payments)
    But there is no null value in the lookup definition. There is no pulic API to update this.

    Anil

    ReplyDelete
  8. Anonymous26 August 2014 at 02:29

    Is there any way to find out from where in EBS application(12.2) an email has been sent to below email address:

    account_payables@visioncorp.com

    ReplyDelete
  9. Anonymous2 September 2014 at 02:25

    Hi Anil... I have to incorporate new tags in my custom remittance report.
    I have customized the PL/SQL package 'IBY_FD_EXTRACT_EXT_PUB' to generate the extra tags in the xml file generated by the "Format Payment Instructions with Text Output" program.

    Please let me know how we can incorporate these custom tags in the remittance report template.
    Following is the custom tag in the XML file.


    CheckrunNameQuick Payment: ID=2727624

    -----------------

    I need the XML tag to incorporate this value in my report.

    Thanks
    Bhaskar

    ReplyDelete
  10. Anonymous2 September 2014 at 02:28

    Extend
    Name>CheckrunNameQuick Payment: ID=2727624
    - /Extend

    ReplyDelete
  11. Oracle apps SOA18 December 2014 at 03:55

    Dear Anil
    I am successfully able to send mail to supplier and the same copy need to send business(internally) also like CC copy.
    Can you please advise on this and pls send me if any @vzsirigireddy@gmail.com

    Thanks and Regards

    ReplyDelete
  12. raoof30 December 2014 at 01:16

    Hello sir

    In step 4 change the subject how to change the payment reference number with paper document number. from where this payment reference number in PMT_REF_NUM is being populated. As per my requirement subject should have paper document number. So can you pls help me and guide me how to change and where to change the payment reference number with paper document number. Pls help me

    ReplyDelete
  13. Unknown10 June 2015 at 16:19

    Note you can have multiple email addresses in the Supplier email field separated by commas.

    ReplyDelete
    Replies
    1. Anonymous19 August 2016 at 09:36

      For seeded report can multiple emial ids be set where the Remittance Advice Statement will be sent?

      Delete
  14. Unknown26 August 2015 at 11:50

    HI Anil,

    I'm getting a time out error even for valid email addresses of Suppliers.

    javax.mail.MessagingException: 421 4.4.2 smtp1.mtgalert.com Error: timeout exceeded.

    Can you please let me know, what may be the resolution for this kind of error.

    Thanks,
    Sai P

    ReplyDelete
  15. Anonymous28 June 2016 at 11:41

    Hi Anil,

    Because we have multiple entities using the same EBS instance, I need to have the IBY_FD_SRA_EMAIL_FROM value different for each entity. I cannot seem to figure out how to do this. Any ideas?

    ReplyDelete
    Replies
    1. Unknown4 September 2018 at 01:09

      I am also facing same requirement.Did u get the solution of your requirement.
      Please reply.

      Delete
  16. Unknown12 September 2016 at 21:09

    Hi Anil,
    the payment remittance advice isn't going to the correct email address for vendor Coffee Analysts .

    the remittance email address for Coffee Analysts, has been changed to chris@coffee-ent.com back in July 2015.
    The vendor is still receiving the remittance advice to the previous email address, judy@coffee-ent.com.

    Pls advise me where i have to set that correct email id

    ReplyDelete
  17. Unknown12 September 2016 at 21:12

    Instance Vi 12.2.4

    ReplyDelete
  18. Anil M13 September 2016 at 09:42

    Check the email address got updated properly!

    select payee_party_id, REMIT_ADVICE_DELIVERY_METHOD, REMIT_ADVICE_EMAIL
    from iby_external_payees_all
    where payee_party_id = ;

    ReplyDelete
  19. Anonymous14 November 2016 at 13:36

    Anil -
    Have just moved to Office 365 after successfully using Send Separate Remittance Advice through Outlook Exchange. The request completes successfully and internal emails send just fine, but external emails never appear to get sent. Please advise how to resolve this issue. Thanks.

    ReplyDelete
  20. Anil M16 November 2016 at 00:56

    Check SMTP server host

    ReplyDelete
  21. Unknown31 January 2017 at 19:21

    Hi,

    In message 'IBY_FD_SRA_EMAIL_FROM' we have setup the from to be '[Instance] Payment '.
    But, when the 'Send Separate Remittance Advices' program is run, we are getting the mail with From address as 'Payment ', where the instance in square bracket is missing.

    If the same is provided as ' Instance - Payment ' OR 'Payment [Instance] ' then we are getting the mail with sender as given in the message.

    Please advise, why the same is not occurring when the square bracket is used in the starting of From Address in message 'IBY_FD_SRA_EMAIL_FROM'

    Thanks
    Naga

    ReplyDelete
  22. teste13 January 2021 at 08:38

    There is a option to confirm if a payment remittance was sent to supplier, using SQL? Or some repository table that archive this data?

    ReplyDelete

Subscribe to: Post Comments (Atom)