Friday, March 2, 2012

R12 Table 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
Allocations - AP_CHRG_ALLOCATIONS_ALL is obsolete in R12

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
Posted by at

11 comments:

  1. AnonymousJune 5, 2012 at 2:46 AM

    very good

    ReplyDelete
  2. UnknownAugust 15, 2012 at 5:15 PM

    Good Atricle Amit, thanks very much

    ReplyDelete
  3. Sji Infotech Pvt Ltd.October 1, 2012 at 6:53 PM

    I would like to appreciate you the way you have shared the post with us. It is really hard to find the quality post, but you have done this job nicely dear.
    six month industrial training | Oracle Technologies

    ReplyDelete
  4. AnonymousAugust 22, 2013 at 2:09 PM

    Nice Article and it is very useful.

    ReplyDelete
  5. AnonymousApril 15, 2016 at 5:40 PM

    very useful info

    ReplyDelete
  6. UnknownAugust 4, 2016 at 11:46 AM

    nice article

    ReplyDelete
  7. AnonymousJanuary 23, 2017 at 6:35 PM

    nice article. Can you please tell what is the equivalent to PO_VENDORS in oracle fusion cloud ?

    ReplyDelete
  8. UnknownFebruary 18, 2017 at 11:11 PM

    Thank you

    ReplyDelete
  9. AnonymousJune 12, 2017 at 5:01 PM

    it is POZ_SUPPLIERS

    ReplyDelete
  10. AkhilaSeptember 21, 2017 at 11:55 AM

    Informative post! I really like and appreciate your work, thank you for sharing such a useful information about taxation management strategies, keep updating the information, hear i prefer some more information about jobs for your career hr jobs in hyderabad .

    ReplyDelete
  11. AnonymousNovember 29, 2017 at 2:38 PM

    nice article. Can you please tell what is the equivalent to AP_CHRG_ALLOCATIONS in oracle fusion cloud ?

    ReplyDelete

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)