AP/AR Netting automatically compares Payables to Receivables and creates the appropriate transaction in each system to net supplier invoices and customer invoices. With this functionality, A receivables user can

• View netted receipt details directly from the receipt
• Create Netting Agreements and Netting Batches

With this functionality, there is significant increase in user productivity and effectiveness because of tight integration and automation.

You can access the process via:

As we have seen Contra charging has been replaced by AP/AR Netting, lets take a setup walk though to use this functionality.

1.Define netting control account

Setup>Financials>Flex field>key>values

2.Create bank

Setup>payment>Bank and Bank Branches

You should note ,Payment document is not required for netting bank account.

3.Go to receivables responsibility, receipt class definition form

Setup>Receipts>Receipt class

Query the ‘AP/AR Netting’ receipt class which is a seeded one.

4. Attach your bank account in this receipt class.

5.Go to system options, transaction and customer tabbed region, there enable ‘Allow payment of Unrelated Transactions’check box

6. Create netting agreement

Receipts>Netting>Netting Agreement

7. Enter an Invoice in Payables, validate and run create accounting.

8. Enter a transaction in receivables.

9. Create Netting Batch

Receipts >Netting >Netting Batch

10. Query your netting batch and see the status as Complete. also click on view report icon on right side.click on run push button, you can see the final netting report.

11.Go to view>request>find

You can see 3 concurrent request programs

• Create Netting batch
• Settle netting batch
• Netting Data Extract

12.Now go to receipts and query the AP/AR netting receipt.

13.Now Go to Tools >view Accounting, you can see Netting control account (defined in first step a) debited and receivable account credited.

14. Now go to payables and query your invoice number and click the tab view payments. You can see the payment details and copy the document number.

15.Query your copied payment document number.What you can see the payment type as Netting .

16.Click actions button and enable the check box create accounting .

17.Go to tools>view accounting .You can see the accounting entry

Is your company is in process of enabling credit card functionality within Oracle Internet Expense?

If answer is yes…
It means, once the credit card functionality is enabled in i-Expense, then its allows users to select open credit card transactions and include them in their expense report. The only pre-requisite for your organization would make an agreement with the credit card company to import an electronic file of credit card transactions that summarizes employees’ expenses for a period. Once the electronic file is imported and validated, employees would be able to see their credit card transactions and then select them for expensing on their expense report.

AMEX (American Express) Corporate card is most popular one normally companies providing there employee who have requirement to frequent travel or other similar requirement.

American Express Corporate Service does provide these services to there corporate customer:

1. KR/KP-1205 Cardmember Listing Report
2. KR-1600 Corporate Express Cash Billed Data
3. KR/KP-1300 Monthly (Cyclic) Aging Analysis
4. KR/KP-1301 Interim Aging Analysis
5. KR/KP-1100 Industry Summary
6. KR-1022 Monthly (Cyclic) Billed Reconciliation Data
7. KR-1025 Daily Unbilled Reconciliation Data
8. KR-1072 Line Item Detail
9. KR-1075 Line Item Detail-Daily Unbilled

Once your company is decided, to go for AMEX Corporate Card, then Finnace IT/ERP team tries to find out the way to do integration within Oracle.From the above mentions list Oracle does only provide the direct integration for Items #7, which is KR-1025 Daily unbilled Reconciliation Data.

Item #8, 9 are treated as level 3 data, and important to know these kinds of data is not currently supported in Oracle.

Level 3 transaction data refers to the detailed transactions that constitute a single transaction line on the credit card statement. For example, a single hotel transaction can contain the detailed transactions of room charge, meals, and room service.

Not only Amexm there are few more for which Oracle does support credit card transactions data file formats in EBS:

• American Express KR-1025 format (file name is Card Daily Data Feed)
• Diner’s Club Standard Data File format (file name is TRANS.DAT)
• Master Card Common Data Format, version 2.0
• Master Card Common Data Format, version 3.0
• Visa VCF4 format
• US Bank Visa format
• Bank of America Visa TS2 format

What is offered as a feature in EBS Suite:

1. Import Credit Card Transactions :As discussed above, if employees in your company use corporate credit cards, you can set up Internet Expenses to enable users to automatically import credit card charges from the card issuer into an expense report. Employees can also categorize each charge as either Business or Personal and, depending on your implementation, place items in dispute.
2. Flexible Credit Card Payment and Reimbursement Setup: Internet Expenses supports several different scenarios for paying the credit card company and reimbursing employees for corporate credit card charges. You can set up your system to indicate how payment must be remitted to the card issuer. Your choices are:

Next will share some setup activity to enable this functionality.

Read this:

1. http://www.oracleappshub.com/account-payable/r12-ebs-banking-model-in-demanding-and-changing-world/
2. http://www.oracleappshub.com/account-payable/welcome-to-r12-account-payable/

Three key CE tables now as:

• CE_BANK_ACCOUNTS for bank accounts
• CE_BANK_ACCT_USES_ALL for account uses by Operating Units & Legal Entities
• CE_GL_ACCOUNTS_CCID for bank account use accounting data

Within TCA model, here is various attributes how they fits inside the model.

Read this :
http://www.oracleappshub.com/account-payable/quick-note-for-supplier-in-ebs/

In earlier post,we have seen supplier has been moved into TCA model. Comparing to 11i version, three new AP tables containing supplier unique data been introduced. They have the links to TCA tables:

• AP_SUPPLIERS
• AP_SUPPLIER_SITES_ALL
• AP_SUPPLIER_CONTACTS

And more important we understood three old PO Vendors tables obsolete, by Views provided for backward compatibility

Here is data model .This will really helps to understand while designing integration with EBS R12.

Hey did you notice there is one thing that keep changing since last 2 releases …the bank. We have seen there was once from pre 10.x to 11i when supplier bank separated from suppliers data and now its again in R12 when it become part of TCA.This time , because of changing business need and high demand of global partners working model. Not only your company is operating globally,your partner too operating global,then why not use them. In typical business cost model, if corporate office is using Citibank for payroll for USA operation then why not Citibank Singapore branch is used for payroll for Singapore if they are operating there. Sound bit low…why ..

As we aware the key message of R12 while release was .

• Think Globally - using business intelligence and analysis tools
• Work Globally - using the global capabilities of the applications
• Manage Globally - using the latest system architecture and middleware

so what , think globally and work globally is factor driving for the changes .This release have witness the great changes ever into the bank model. Now the bank accounts is attached to your legal entity level rather than Operating Unit in which current and existing versions Offers. This makes bank with strong capability to pay across operating units. More over its important to understand banks accounts can be shared by applications and can be designed for use by Payables, Receivables and Payroll.

What is new in R12 for Bank

These changes make easier and more reliable by

• Single access point
• Single Legal Entity ownership
• Usage rights granted to one or more Organizations
  • Reconciliation option defined at Bank Account level
  • More flexibility and control

Take a looks of some of the releases

Release 10.6 character/10.7 NCA to 11i
How 10.x supplier banks are mapped to 11i

Release 11i

These are tables which hold the bank details irrespective of supplier or internal banks.

Comparing the 11i Vs R12

If we compare the bank with 11i vs R12, we can notice the bank was utilized into three different places , finance ,payroll and treasury, which requires altogether a different setup. It was one of the big issues with integration aspect, as significant problem was recognized once the Expense management and payroll uses same bank for the respective person.

There was a common question/confusion between the Integration Existence between Bank Data in Accounts Payable and Bank Data In Payroll ?

As discussed above , you know most of release of 11i family of oracle Application does not have integration between HR and AP for bank account data.

We have notice in 11i there was functionality in which Payables in which we will create an employee type supplier from HR data and it will contain name and address info but not bank information. The reason for this is that HR/Payroll does not store the bank information in a standard way that makes the integration possible.

So now r12 this was well taken care and integration is built. There are plans under way for all bank account data models in the various products to be consolidated in the new TCA architecture. The Cash Management team is working on this project. Payables and HR/Payroll are working so that the eventual idea will be that you can set up bank accounts in one place and then indicate the usage (pay, expense reimbursement, etc).

For understanding it is comparison between 11i and release 12 , where TCA community take cares of every things.

Release 12 , what is new than

Bank Accounts will be stored in a new table called CE_BANK_ACCOUNTS and will be located at a Bank Branch.

The new table which hold the bank information are as:

1. CE_BANK_ACCOUNT:stores bank account attributes
2. CE_BANK_ACCT_USES_ALL : This stores the bank account use attributes specific to Operating Unit (AR, AP) and Legal Entity (Treasury).
3. CE_GL_ACCOUNTS_CCID :The accounting data pertaining to the bank account use will be stored in the table.

This new data model allows the bank and bank branch entities to be defined separately allowing users to establish a hierarchical relationship between them.

Missing link between Supplier And Supplier Banks?

You should know

• The link between PO_VENDORS and HZ_PARTIES is PO_VENDORS.party_id.
• The link between PO_VENDOR_SITES_ALL and HZ_PARTY_SITES is PO_VENDOR_SITES_ALL.party_site_id.
• When a Supplier is created Record will be Inserted in HZ_PARTIES. When the Supplier Site is created Record will be Inserted in HZ_PARTY_SITES. When Address is created it will be stored in HZ_LOCATIONS
• When a bank Is Created, the banking information will be stored in

IBY_EXT_BANK_ACCOUNTS IBY_EXT_BANK_ACCOUNTS.BANK_id = hz_paties.party_id

• When the Bank is assigned to Vendors then it will be updated in HZ_CODE_ASSIGNMENTS.

HZ_CODE_ASSIGNMENTS.owner_table_id = IBY_EXT_BANK_ACCOUNTS.branch_id.

Internal Bank Accounts & Supplier and Customer Bank Accounts in R12

Internal Bank Accounts
In Release 12, each internal bank account is assigned to a Legal Entity. Any or all operating units associated with that legal entity are permitted to use that bank account.
Supplier and Customer Bank Accounts
In Release 12 provides a centralized repository for suppliers’ and customers’ bank account and credit card information. All data is stored in one, secure place, providing shared service centers and collection departments consistent information that they need.

Any comment guys..

In Oracle supplier can be entered from three different place.These are the Setup required to perform for a suppliers.

• Supplier Accounts
• Taxes
• Payments
• Term Date Basis
• Due Date Basis
• Invoice Currency
• Holds

In Oracle these are the important features through the screen:

• Enter Suppliers
• Enter employees as Suppliers
• Merge duplicate Suppliers

Supplier Data Entry

Other Details

• Classification Information (Significant for type and employee name)
• Parent subsidiary relationship
• Supplier bank information
• Appropriate GL accounts information
• Record tax information
• Hold conditions to supplier site (rather than on individual invoices)

and these are the optional field

• Tax payer ID
• VAT registration number
• Inactive date (to prevent invoice/PO entry after a certain date)

Important Table that holds supplier

• PO_VENDORS : this hold a suppliers information

Some important columns:

• • SEGMENT1 – SYSTEM GENERATED OR MANUALLY ENTERED NUMBER FOR SUPPLIER (PO_UNIQUE_IDENTIFIER_CONTROL)
  • VENDOR_ID – SYSTEM GENERATED UNIQUE NUMBER
  • CREDIT STATUS –GOOD/POOR
  • ORGANIZATION_TYPE_LOOKUP_CODE
  • VENDOR_TYPE_LOOKUP_CODE – VENDOR/EMPLOYEE (EMPLOYEE_ID)
  • ONE_TIME_FLAG
• PO_VENDOR_SITES_ALL : This hold corresponding site information Contains Details of the site like Full Address/Work of site
  and its link with vendor_id.Important columns includes:
  • PURCHASING_SITE_FLAG, VENDOR_SITE_CODE, RFQ_ONLY_SITE_FLAG, PAY_SITE_FLAG,HOLD_ALL_PAYMENTS_FLAG, HOLD_FUTURE_PAYMENTS_FLAG, HOLD_UNMATCHED_INVOICES_FLAG
• PO_VENDOR_CONTACTS : This hold supplier contact information for respective sites.

How they connected

These are typically connected as:

Take a note Segment1 is holding suppliers Number.

Quick query for new babies

select * from po_vendors
where segment1 = ‘1001‘;

select *
from po_vendor_sites pvs,
po_vendors pov
where pov.segment1 = ‘1001′
and pov.vendor_id = pvs.vendor_id;

select *
from po_vendor_contacts pvc,
po_vendor_sites pvs,
po_vendors pov
where pov.segment1 = ‘1001′
and pov.vendor_id = pvs.vendor_id
and pvs.VENDOR_SITE_ID = pvc.vendor_site_id;

Supplier Interface

Yes, that was one of the enhancement in oracle 11.5.10 release. Prior to that version, there was no interface or Public exist for supplliers, thus it was a tricky to handle supplier. As we have already seen AP availability of AP some time back.

If you are having 11.5.10+ version,and if you have requirement to create supplier from your legacy data than use Supplier Interface, life will be easier. Is n’t.

How we start

This consist in 2 steps process:

Step 1. Populate the new interface tables with data. This can be done via SQL*Loader or typically used to load data in a table.

Step 2. Run the Supplier Open Interface Request Set (FNDRSSUB1703)

Alternatively, run the individual import programs to load one table at a time

Some important notes for suppliers Interface

• When you load the data it should be ‘NEW’ initially. After the Supplier Sites Open Interface is run the status gets changed to PROCESSED’/'REJECTED’.

The entire flow can be shown as:

A Note with R12 for Suppliers

As we know in R12 Supplier is part of TCA , thus the link between PO_VENDORS and HZ_PARTIES is PO_VENDORS.party_id. The link between
PO_VENDOR_SITES_ALL and HZ_PARTY_SITES is PO_VENDOR_SITES_ALL.party_site_id.

When a Supplier is created Record will be Inserted in HZ_PARTIES. When the Supplier Site is created Record will be Inserted in HZ_PARTY_SITES. When Address is created it will be stored in HZ_LOCATIONS.

Do you know, there are many default value which can be controlled at set up level. Here is the explanation based out of close microscopic view of default values of Account Payable.

Do we have any General Setup Hierarchy for Default values???

Yes , we have a General Setup Hierarchy for Default values, which can be typically described as:

AP takes care of all payments in Oracle Applications. This module has active interaction with Purchasing and General Ledger modules.

The different functionality of the Payables module are:

• Set up Supplier.
• Enter, review and Approve invoices.
• Pay invoices and reconcile payments to bank a/c.
• Enter and apply pre-payments.
• Create journal entries for posting to GL.

An top level overview of the module can be given as :

1.Enter Suppliers

This step consist of set up as well as maintenance of existing one.During the setup, we need to do setup for

• Supplier Accounts
• Taxes
• Payments
• Term Date Basis
• Due Date Basis
• Invoice Currency
• Holds

Importantly the other features in this area consist is :

• Enter employees as Suppliers : this is for managing and controlling Expense report
• Merge duplicate Suppliers

2.Invoices

This consist Setup for;

• Distribution Set
• Tax
• Setup tolerance, matching options

3. Approve invoice

This required set up for rule, so that approval and validation process can validate based on some parameter.

4.Payments

This requires set up for payment related dependency which include ;

• Format
• Bank
• Bank account
• Build program
• Payment Methods
  • Manual
  • Quick Check
  • Automatic Check

Take a note in manual and Quick check, you have to simply enter payment details and correlate to invoices. Automatic check is applicable for batch payments.

5. Create Journal entries

Typical flow for creating Journal entries is summarized as:

And here is final note of accounting Entries of AP :

• During Invoicing
  • Expenses A/C Dr to vendor liability
• During Payment
  • Vendor liability A/C Dr to Cash/Bank A/C

…And, This is Four Rule of Payables

• You must have a vendor to do anything
• Every Invoice must be fully Charged out before paid or posting to GL.
• All Payments must have an invoice
• Every Invoice must run through approval process.

Hope this is a brief overview of the Payable business flow, will discuss & share some more in next couple of post.Till then keep watching this space.

This is in continuation to API’s availability,Here are the API’s availability in AP.

Credit Card Transaction Processing

• Manual Credit Card Entry: A form is available for entry through the Oracle Payables application.
• Credit Card Transaction Interface Table: This process loads transaction data from the credit card issuer (American Express, Diner’s Club, MasterCard and Visa) into Oracles AP module. Oracle Payable then uses this data to confirm transactions with employees. Once the transactions have been approved the credit card transaction lines are imported into Payables Open Interface using the Credit Card Invoice Interface Summary program. The credit card transactions are then available for final import to Oracle Payables where the transactions become invoices.

Creating Invoices
In Oracle Payables four methods are available for entering an invoice into the system.

• Manual Invoice Entry: Two methods for manual invoice entry exist. Using Oracle Payables system Invoice Workbench which includes the Invoice Batches window and Distribution window users can enter complex invoices, and invoices requiring online validation. In addition this functionality is useful in processing invoices that require special attention such as immediate payment.
• The second method of manual invoice entry, Invoice Gateway, is used when entering high volumes of invoices. Generally these invoices do not require online validation or defaulting of accounting information. After entering invoices using the gateway, the invoice import must be run, at that time validation and defaulting is performed. This method of entry can be used in lieu of invoice interfaces. Although, using the gateway can accomplish similar results to that found with an interface process, manual entry is no substitute.
• Automatic Invoice Creation: Oracle Payables provides functionality to produce periodically recurring invoices. This functionality may be used to substitute manual invoice entry or the payables open interface. In the case of recurring invoices that would normally come from an external system choosing to setup a recurring invoice formula may be an alternative.
• Using Payables Open Interface: Choose this method for processing large volumes of invoices that originate in external system. Additionally, this process is useful in handling employee expense reports generated through self-service applications, expense reports entered by the Payables Department, invoices for employee credit card expenses, Oracle Projects billing and time and expenses, and EDI invoices transferred from the Oracle EDI gateway.

Purchase Order Matching

Oracle Payables can be implemented without Oracle Purchasing, to allow this several purchasing tables are installed initially which must be populated using custom interfaces. Only two-way matching is available when data is loaded using the interface method. Two-way approval verifies that purchase order and invoice information match within your tolerances as follows: Quantity billed on the purchase order shipment is less than or equal to Quantity ordered on the purchase order shipment. Invoice price on the purchase order shipment is less than or equal to Purchase order price on the purchase order shipment.
Receipts can only be matched in an install that also includes Oracle Purchasing.
The only method for interfacing data into the purchasing tables described in this section is through a customized interface from an external source. Note: Interfacing this information is not supported by Oracle.

• Loading PO_HEADERS: Each record in this table represents a purchase order, which is an order for goods or services from a single supplier. Each purchase order may have multiple lines (PO_LINES). In addition, each blanket purchase order may have multiple blanket releases (PO_RELEASES), which release an amount from the blanket.
• Loading PO_LINES: Each record in this table represents a purchase order line, which identifies the items and unit price for the goods ordered on a purchase order. Each purchase order line may have multiple shipments (PO_LINE_LOCATIONS).
• Loading PO_LINE_LOCATIONS: Each record in this table represents a purchase order line, which identifies the items and unit price for the goods ordered on a purchase order. Each purchase order line may have multiple shipments (PO_LINE_LOCATIONS).
• Loading PO_DISTRIBUTIONS/PO_DISTRIBUTIONS_AP_V: Each record in this table/view represents a purchase order distribution, which identifies the account charged for the items on a purchase order shipment.
• Loading PO_RELEASES: Each record in this table represents a blanket release for a purchase order. A blanket release may create multiple shipments.
• Loading AP_INVOICES/AP_INVOICE_DISTRIBUTIONS: Each purchase order shipment can be matched to multiple invoices(AP_INVOICES), and a single invoice may be matched to multiple purchase order shipments. When you match an invoice to a purchase order shipment, Payables creates an invoice distribution AP_INVOICE_DISTRIBUTIONS) from each purchase order distribution on the shipment. When you match an invoice to a single purchase order distribution, Payables creates a single invoice distribution from the purchase order distribution.

Vendor Interface

Existing and new vendors must be loaded into the Oracle Payables application to support payables activities. Two methods may be used to enter vendors into Oracle Applications, manual entry and direct loading using a customized loader program.

• Manual Vendor Loading: Use the Enter Vendor window. Using this functionality vendor header information as well as vendor site information can be entered.
• Vendor Interface: When interfacing vendors into Oracle Applications two tables must be loaded the PO_VENDORS and PO_VENDOR_SITES_ALL. The vendor table contains all header information and the site table contains information about each the vendor locations such as “ship to” and “bill to”. Using this method makes sense when the volume of new vendors is large. Note: Interfacing this information is not supported by Oracle.
• Those who are in 11.5.10 they will find yet another method ie by interface.
  You have to Load data into the staging tables first ie.AP_SUPPLIERS_INT - Supplier Information
  AP_SUPPLIER_SITES_INT - Supplier Sites Information ,AP_SUP_SITE_CONTACT_INT - supplier Contact details This uses Vendor ID, Vendor Site Code to relate the contacts to specific vendor. Once data get loaded three interface program should be kicked out which is as
  • Supplier Open Interface Import.
  • Supplier Sites Open Interface Import
  • Supplier Site Contacts Open Interface Import

This is new enhancement we have seen in 2nd generation i-expense version, where there is provision of setting up of Itemization rule. In layman language, it can be explained as ..when an employee stays in a hotel on a business trip, he receives one receipt for his stay. That one receipt includes hotel stay, food, room service, laundry and other personal expenses (of course.). The Expense Itemization feature allows an employee to enter one receipt for the whole amount and lets them itemize the same.

This feature allows you to require itemization and determine which expense types for the itemization are independent of each other. If itemization is required, you can also identify into which expense types a receipt can or should be itemized. This expedites the expenses entry process and ensures more accurate accounting. This also helps in easy reconciliation for your finance department, and also no argument for clarifying personal stuff.

Take a note, oracle 11.5.10.2 does not have any seeded report that will have drill down information for itemized claim. So don’t get surprised , if Finance will ask you for detailed Itemized report.