Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Monday, June 27, 2016

Oracle Cloud ERP (Fusion) Check Template Setups and Process Training Manul

EXECUTIVE OVERVIEW
Generating payment checks from the Fusion has traditionally required either a third party or considerable customization of the delivered check print reports. The check print format is very specific to each banking organization, requiring specific fonts and pixel-perfect layout. The existing E-Business Suite reports generate flat text output and do not support these features. Oracle XML Publisher now offers an integrated, cost-effective method to generate the check output directly from the Fusion.
 

INTRODUCTION
Check printing from the Fusion has historically required a third-party solution that can either query the necessary data and format the output or accept the existing flat text output generated by the provided check print programs. To then generate the checks, the format components had to be placed with pixel-perfect precision onto the page using the necessary MICR font to format the bank routing number and bank account of the payee. Alternatively customers could take the existing check print program and customize it to format the output correctly. These solutions are costly in terms of their implementation, their ongoing maintenance and their complexity. This all adds to the total cost of ownership for the E-Business Suite.

Oracle XML Publisher offers integrated functionality that allows customers to design their own check format using familiar desktop tools that can then be applied to a check print data source, whether that is the seeded Fusion Report or a custom solution. This format is easily maintainable and can include all the necessary components required in the final output to be printed onto blank check stock.

Taking this approach reduces the complexity of the systems surrounding the check generation and thereby reducing the total cost of ownership of the Fusion.

Pre-requisites:
Download BI Publisher Template Builder for Word version 10.1.3.4.1 from download.oracle.com

Basic requirements to start creating checks are to have an RTF file (Template) and an XML file (data definition).

There are 2 ways that you can have an RTF file:
o Create your own, or
o (Recommended) Download standard oracle Template
‘Standard Check Format’ IBYDC_STD1.rtf or
Standard Check Format : IBYDC_STD1A.rtf

àBetter way is to follow the instructions in Doc ID: 465389.1 R12 Create Or Modify A Payment Format Using XML Builder. This note explains the same steps that I have defined below

MICR Fonts
This is another important requirement which you will run into later on. So I have decided to address it right away because you may end up spending a lot more time if you start thinking about it later. One of the easiest way is to buy the MICR font from a third party like IDAutomation (http://www.idautomation.com/) and use MICRW1B.ttf. Typical cost is around $750.00 per user license – you may need to purchase only one license. You may also download their Demo version which is good for testing.

The good news is that Oracle also provides a MICR font which is available if you have downloaded the BI Template Builder. Some banks reject this font, but so far I did not have any problem with the bank that we used.

Download and install BI Publisher ver 10.1.3.4.1
Font File Location: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\fonts\ MICR____.TTF


In order to use this file in the RTF template, copy the font file MICR____.TTF to C:\WINDOWS\Fonts


At this stage, you may or may not have designed the Check template. But you can still use IBYDC_STD1.rtf downloaded earlier.

Following steps are needed to create a check in AP from scratch. These steps may also be used to create the initial payment to get the XML file.



Step 1 : Creating Template
Go to Navigator and click on Reports and Analytics

Click on Browse Catalog

Expand the Shared Folder then Expand Financials then click on Payments and click on the edit link in Disbursement Payment file Format

Click on the Add new Layout link

Click on the upload layout link

Enter the Layout name and select the RTF file and save
Name
Value
Layout Name 
 XXAA_CHECK_FORMAT
Type 
RTF Template
 Locale
English 


Click on view list and set the custom layout as default
Select the output types as PDF and XML and click on Save.

Step 2: Creating Payment Format
Go to Navigator and click on Setup and Maintenance

Search with Manage Formats and click on Go To Task

Select Disbursement Payment File Formats and click on Create

Enter the details and click on Save and Close
Name
Value
Name
XXAA_CHECK_FORMAT
Code
XXAA_CHECK_FORMAT
 BI Publisher Template
XXAA_CHECK_FORMAT (Created in Step1)


Step 3: Creating Payment Document
Go to Navigator and click on Setup and Maintenance

Search with Manage Bank Accounts and click on Go To Task

Search with bank : Bank of America and click on Go To Task then click on the bank account : BofA-2869

Click on the Edit button to add the new document

Click on the create  button

Enter the details and click on ok
Name
Value
Payment Document
XXAA_CHECK_FORMAT
Format
XXAA_CHECK_FORMAT (Created in Step2)
Paper Stock Type
Numbered Stock
First Available Doc No
10000
Last Available Doc No
99999


Click on Save and Close button

Step 4: Creating Payment Process Profile
Go to Navigator and click on Setup and Maintenance

Search with Manage Payment Process Profiles and click on Go To Task

Click on create  button

Enter the details and save
Name
Value
Name
XXAA_CHECK_FORMAT
Code
XXAA_CHECK_FORMAT
Payment File Format
XXAA_CHECK_FORMAT (Created in Step3)
Processing Type
Printed
Enable
Send to File

Note : Don’t select the payment document at this step
Note ID : Cannot Save New Payment Process Profile (Doc ID 1981556.1)

Click on Ok then select the Payment Document : XXAA_CHECK_FORMAT BofA-2869 and save

Step 5 : Creating PPR Template
Nav : Payables àPayments àTasks à Manage Payment Process Request Templates àActions àCreate

Enter the below values save it
Name
Value
Template Name
XXAA_CHECK_FORMAT
Payment Method
Check
Disbursement Bank Account
BofA-2869
Payment Document
XXAA_CHECK_FORMAT (Created in Step2)
Payment Process Profile
XXAA_CHECK_FORMAT (Created in Step4)
Payment Conversion Rate
Corporate
Review Proposed Payments
Enable
Create payment File Immediately
Enable


Step 6 : Void the Payments
Nav : Payables àPayments àTasks à Manage Payments

Search the payment and select any payment and void the payment

Click on Submit

Step 7 : Submitting PPR
Nav : Payables àPayments àTasks à Submit Payment Process Request
Enter the PPR name and select the PPR template created in Step 5 then it will populate the all default values and click on submit


Go to Manage Payment Process Request
Search with above created PPR and click on the Action button

Click on Resume Payment Process

If the payment struck with “Waiting For Payment File Processing” status then submit “Create Printed Payment Files”

Nav : Payables àPayments àTasks à Create Printed Payment Files
Enter the below details:
Name
Value
Disbursement Bank Account
BofA-2869
Currency
USD
Business Unit
US1 Business Unit
Payment Process Profile
XXAA_CHECK_FORMAT
Payment Process Request
PPR001
Payment Document
XXAA_CHECK_FORMAT
Print Now
No


Now Go to “Manage Payment Process Request” Search with above created PPR and click on the Action button

Click on Submit

Click on “Record the Print Status”


Go to Navigator and click on and click on Scheduled Processes

Refresh and click on output link:



1 comment:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect