Tiêu đề Fusion R13 - Oracle Fusion R13 Check Template Setups and Process Training Manul.pdf ✅

Fusion R13 - Oracle Fusion R13 Check Template Setups and Process Training Manual Raju Ch 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. RAJU CHINTHAPATLA
Fusion R13 - Oracle Fusion R13 Check Template Setups and Process Training Manual Raju Ch 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. RAJU CHINTHAPATLA
Fusion R13 - Oracle Fusion R13 Check Template Setups and Process Training Manual Raju Ch Pre-requisite Setups: 1. BI Publisher Desktop 2. Approval Setups (Optional) a). Employee/User – Super Visor Setup b). AP Invoice Approval c). AP Payment Approval 3. Supplier Setup a. Supplier b. Supplier Address c. Supplier Sites d. Supplier Contacts 4. Bank Account Setups a. Banks b. Branches c. Bank Accounts 5. Payment Setups a. Payment Templates b. Payment Formats c. Payment Document d. Payment Process Profile (PPP) e. Payment Process Request Template (Optional) Process Flow with Above Setups 1. Create Invoice and Pay in Full 2. Manual Payment Create invoice and run the Manual Payment 3. Run the Payment Process Request (PPR) Create Invoice Void the Payment (Cancel the Existing payment) Create the PPR for New Invoices and Void Payments 4. Accounting Post the Invoice to General Ledger Post the Payment to General Ledger RAJU CHINTHAPATLA
Fusion R13 - Oracle Fusion R13 Check Template Setups and Process Training Manual Raju Ch 1. BI Publisher Desktop 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. RAJU CHINTHAPATLA