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.
       
          

Error: '500 Internal Server Error' When Clicking The LOV( Discoverer)

The following error is encountered when clicking List Of Values in Discoverer Viewer:

"500 Internal Server Error"


Change the timeout for the EXISTING individual workbooks, do the following:

1. In the Viewer, open the workbook and click on the Preferences link and increase value

'Cancel list-of-values'

2. In the PLUS, open the workbook -> Tools -> Tools -> option -> Query Governor -> increase the time for 'Cancel list-of-values retrieval after'