February 8, 2011

Release 12 Oracle E-Business Financials


Oracle Payable:
Supplier has been moved into TCA model.And more important we understood three old PO Vendors tables obsolete, by Views provided for backward compatibility
• AP_SUPPLIER_CONTACTS
• AP_SUPPLIER_INT_REJECTIONS
• AP_SUPPLIERS
• AP_SUPPLIER_SITES_ALL

New Views
The following are the new views added in Release 12 as a part of this initiative.
These are backwards compatible views that join the Suppliers table in Payables and the TCA tables,
so that any teams using the old suppliers tables have no impact.
• PO_VENDORS
• PO_VENDOR_SITES_ALL
• PO_VENDOR_CONTACTS
The following tables are obsolete:
• PO_VENDORS
• PO_VENDOR_SITES_ALL
• PO_VENDOR_CONTACTS










Changed Views
AP_INVOICES_V
AP_INVOICE_DISTRIBUTIONS_V
PO_LINE_LOCATIONS_AP_V
AP_PO_DISTRIBUTIONS_AP2_V
PO_AP_RECEIPT_MATCH_V
AP_APPLY_PREPAYS_V

Obsolete Tables
AP_BANK_BRANCHES replaced by CE_BANK_BRANCHES_V
AP_BANK_ACCOUNTS_ALL Replaced by CE_BANK_USES_OU_V/IBY_EXT_BANK_ACCOUNTS_V
AP_BANK_ACCOUNTS_USES_ALL
AP_CHECK_STOCKS_ALL replaced by CE_PAYMENT_DOCUMENTS.
AP_CHRG_ALLOCATIONS_ALL

at
Labels:

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...

  • FND_CANONICAL
    In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
  • HRMS API with tables
    Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...
  • Wip Move Transaction Migration
    WIP Migration: Create a job in Work in Process 1.        Create a job with item which is billable on and define routing sequence for the ...