Account s Payable Scenarios – R12 Instance

Account s Payable Scenarios – R12 Instance
Topics covered
1. Bank Setup
2. Supplier Setup
3. Invoice creation
4. Creation of Quick Payments
5. Changing Check Format Templates
6. Extracting XML to input Word Templates for Check Printing

Responsibility used: Payables Manager.
Scenario 1
Setup: Banks and Bank Branches.
After Logging in to the application and clicking on “Bank and Bank Branches” a Java based window will open up. Clicking on Create button will open up the screen to Create New Banks.

Choose “Create New Bank” and enter the details.
“Save and Next”

Step 3 : Need to create an Address for the bank.

Step 4: Enter Address and “Apply”
Step 5: Make sure the screen looks like this
Step 6 : Create Contact
On Applying, a confirmation that the bank is created
Next step is to create a branch for the bank we just created.
Click on Bank Branches Tab.
Branch Details: Enter details and click finish.
Next is to create an Account for this branch.
Navigation: In Bank Branches, scroll to bottom and you will see “Create Account”
Bank Account Owner is the Legal Entity i.e Vision Operations in our case. Tick Payables.
Details
Only Cash account is mandatory, leave others as default. Next add Organization, as one organization is mandatory.
Next we need to create Payment Documents to setup a check format this bank.

Click on Manage Payment Documents, create new and enter the format. How to Create Formats is discussed later in this exercise. Apply and Close Window. Scenario 1 is complete.


Scenario 2: Creation of Suppliers
Click on create Supplier
After creating supplier the next step is to create an Address Book for this supplier and in the same screen create a site.
After creating a supplier you need to create a supplier site if u did not create the site in the address screen.
Next is to attach a payment method to this supplier
Next is to create bank details for this supplier
This completes the creation of Suppliers.
Scenario 3: Creation of Invoices.
Set the profile option “AP: Use Invoice Batch Controls” to No, otherwise only Invoice Batches Screen will popup.


Enter Lines and amount
Enter Distributions, make sure the account no and the line total matches the distribution total.
Save the Invoice.
Validate the invoice -> Actions-> Validate-> OK
Scenario 3: To make a Quick Pay and apply to the invoice we just created.
Actions-> Pay in full-> Ok will open up the payments screen.
Payment Screen

Save, will trigger the Format Payment Instructions concurrent request.
Go to View->Concurrent Request
To verify the details, on the invoice screen->Payment schedules click on Payments Overview

Scenario 4
Changing AP Check Formats
n Can create an XML output and then use this XML to populate the word template.
n Search for an existing format and download the RTF and make modifications to that template and attaching them to the custom template.
Steps for creating an XML output
Nav-> Payment Administration-> formats-> Click on Task

Create a new Format
NavigateOracle Payments Set UpFormats - Formats - Go to TaskCreate a new Format and attach XML Publisher Template = Extract IdentityData Extract = Oracle Payments Funds Disbursement Payment Instruction Extract, Version 1.0

Query a Bank AccountSelect the Account and Click Manage Payment Documents.Create a New Document and attach the Format you created.


Create a Profile Class this is used in the payments screen.
NavigateOracle Payments Set UpPayment Process Profiles - Go to TaskCreate a Payment Process Profile and attach the Format you just created.
This profile is used during the creation of the payment.

Now we will create an Invoice and make a quick payment
Enter an Invoice.Account the Invoice.Create a Quick Payment use the profile we created and save.Use the New PPP and Payment Document you created to produce an output fileThis Output file will be in XML format and will include all the fields of the Data Extract.
The Format Payment Instructions would give the output as follows. Make sure that the output of this program is set to an output of XML, otherwise if its PDF then the XML would not open.
Sample XML file would looks like this

In Microsoft Word (or other Format editor)
Load the XML file into the template builder.Open the Template that you wish to modifySelect the fields from the extract that you wish to add to your template.The new Template when finished can be attached to a new Payment Format which can be used on a new PPP and Payment Document.

Once the changes are completed attach the newly build format to your bank account.

Metalink Access Reference Doc id : 465389.1
For modifying of the formatting like 'Amout in words in Arabic" etc mofidy IBY_FD_EXTRACT_EXT_PUB.pkb package.