R12 Table Level Changes

Suppliers:

New R12 tables  -> Old 11i Tables

AP_SUPPLIERS - replaces PO_VENDORS

AP_SUPPLIER_SITES_ALL- replaces PO_VENDOR_SITES_ALL

Additional supplier related tables in IBY (Payments) and HZ (TCA):

IBY_EXTERNAL_PAYEES_ALL - stores Payee(supplier) information.

HZ_PARTIES - Party data for the suppliers.

HZ_PARTY_SITES - Party site data for the supplier sites.

Invoices:

Additional table in R12: AP_INVOICE_LINES_ALL

we were capturing the invoice break up details directly in the distribution, whereas in release 12, one is allowed to capture the invoice information at the line level, and then make distributions for every line captured. The information that can be captured at the line level could be any of the following:
Item purchased, the price, the quantity, and other item related information.

AP_INVOICE_DISTRIBUTIONS_ALL:

It holds the distribution information that is manually entered or system-generated.

There is one row for each invoice distribution and a distribution must be associated with an invoice.

An invoice can have multiple distributions.

Allocations - AP_CHRG_ALLOCATIONS_ALL is obsolete in R12

R12’s New Payment Process Request:
The 11i Accounts Payable Payment Batch functionality has been replaced by the Payment Process Request (PPR) in R12. PPR can be accessed via Payment Manager, a fund disbursement HTML page (as opposed to the prior 11i Oracle forms).

Taxes:

Functionality provided by E-Business Tax

New tables in R12

ZX_LINES - Detailed Tax lines for the invoice (trx_id = invoice_id)

ZX_LINES_SUMMARY - Summary tax lines for the invoice (trx_id = invoice_id)

ZX_REC_NREC_DIST  - Tax distributions for the invoice (trx_id = invoice_id)

ZX_LINES_DET_FACTORS - Tax determination factors for the invoice (trx_id = invoice_id)

Payments:

Functionality moved to central Payments (IBY)

New IBY tables in R12:

IBY_PAY_SERVICE_REQUESTS  - Payment Process Request information

Accounting:

Functionality moved to SubLedger Accounting (SLA)

New R12 tables:

XLA_EVENTS -> replaces AP_ACOCUNTING_EVENTS_ALL 

XLA_AE_HEADERS -> replaces AP_AE_HEADERS_ALL

XLA_AE_LINES-> replaces AP_AE_LINES_ALL

XLA_DISTRIBUTION_LINKS

Trial Balance:

New R12 Table

XLA_TRIAL_BALANCES

AP_LIABILITY_BALANCE-> not used in new R12 transactions

AP_TRIAL_BALANCE -> not used in new R12 transactions

Bank Accounts:

Functionality moved to Cash Management.

CE_BANK_ACCOUNTS -> replaces AP_BANK_ACCOUNTS_ALL

CE_BANK_ACCT_USES_ALL  -> replaces AP_BANK_ACCOUNT_USES_ALL

CE_PAYMENT_DOCUMENTS -> AP_CHECK_STOCKS_ALL

Inventory r12 new concefts:

OPM Inventory Conversion
11i:
1) OPM Inventory 2) Discrete Inventory
r12)
Oracle Inventory
Dual UOM Functionality:
Material Status Control:
Specify which transaction types can be resticted by status
1)Subinventory 2)Locator 3)LOT 4)serial

Difference Between 12.1 and 12.2
Online Patchin

R12 features:

cloning is simplified

64 bit java is supported which can handle large amounts of data compared to 32bit java

display user name insted of user id for the last updated by field.