Here is a list that shows the changes occur in tables and views in R12 in the area of Accounts Payable. However this may be a full comprehensive list of all the changes, but useful for checking the changes in some major tables in AP.
New Tables:
| Table Name | Feature Area |
| CE_BANK_ACCOUNTS | Internal Bank Accounts |
| CE_PAYMENT_DOCUMENTS | Payment Documents to be used for Printed type Payments |
| IBY_EXTERNAL_PAYEES_ALL | Payee (Trading Partner Info for paying invoices) |
| IBY_PMT_INSTR_USES_ALL | Used for Remit to Bank Accounts |
| AP_INVOICE_LINES_ALL | Invoice Lines |
| AP_ALLOCATION_RULES | Invoice Lines |
| AP_ALLOCATION_RULE_LINES | Invoice Lines |
| AP_ALLOCATION_RULE_LINES_GT | Global Temp Table for Invoice Lines – Allocations |
| AP_SELF_ASSESSED_TAX_DIST_ALL | E-Business Tax |
| AP_PRODUCT_REGISTRATIONS | Invoice Lines |
| AP_PRODUCT_SETUP | Multi Org Access Control |
| AP_TOLERANCE_TEMPLATES | Support of complex PO Contracts |
| AP_NEGOTIATION_HIST | Holds Resolution Workflow |
Changed Tables:
| Table Name | Feature Area | Brief Description of Change |
| AP_INVOICES_ALL | Invoice Lines, eBusiness Tax, Payments, SLA, Complex Work POs… | Numerous columns were added to this table. |
| AP_INVOICE_DISTRIBUTIONS_ALL | Invoice Lines, eBusiness Tax… | Numerous columns were added to this table. |
| AP_INV_APRVL_HIST_ALL | Holds resolution workflow | Hold_ID column was added. |
| AP_CHECKS_ALL | Payables Payments Data | Some new columns are added to AP_CHECKS_ALL table for maintaining real time synchronization with Oracle Payments and Cash Managements. Some existing columns from the same tables have been made obsolete. |
| AP_HOLDS_ALL | Holds Resolution Workflow | New Columns Added were: Hold_id and wf_status. |
| AP_HOLD_CODES | Holds Resolution Workflow | New Columns Added were: hold_instruction, wait_before_notify_days, reminder_days |
| AP_INV_APRVL_HIST_ALL | Holds Resolution and Invoice Approval Workflow | This will be used to record history for both the Invoice level Approvals and Invoice Line level approvals. New Columns Added were: line_number, hold_id and history_type |
| AP_APINV_APPROVERS | Invoice Approval Workflow | New Columns Added were: child_process_item_key, child_process_item_type, item_type and item_key. |
Obsolete Tables:
| Table Name | Feature Area | Replaced By |
| AP_BANK_BRANCHES | Bank/Bank Branches | CE_BANK_BRANCHES_V |
| AP_BANK_ACCOUNTS_ALL | Bank Accounts including Internal and External | CE_BANK_USES_OU_V, IBY_EXT_BANK_ACCOUNTS_V |
| AP_BANK_ACCOUNTS_USES_ALL | Remit to Bank Account Uses | |
| AP_CHECK_STOCKS_ALL | Payments Documents | CE_PAYMENT_DOCUMENTS |
| AP_CHECK_FORMATS | Payments Format | |
| AP_TAX_RECVRY_RULES_ALL | EBusiness Tax | Replaced by relevant EBTax tables/views. |
| AP_TAX_RECVRY_RATES_ALL | EBusiness Tax | Replaced by relevant EBTax tables/views. |
| AP_CHRG_ALLOCATIONS_ALL | Invoice Lines – Allocations | This feature is replaced by distributions itself, distributions itself represent the allocation of charges. |
| AP_TAX_DERIVATIONS | EBusiness Tax | Replaced by relevant EBTax tables/views. |
| AP_LINE_APRVL_HIST_ALL | Invoice Approval Workflow | AP_INV_APRVL_HIST_ALL |
New Views:
| View Name | Feature Area |
| CE_BANK_BRANCHES_V | Bank/Branches Info |
| CE_BANK_ACCT_USES_OU_V | Internal Bank Account Uses Info |
| IBY_EXT_BANK_ACCOUNTS_V | Remit to Bank Account Info |
| AP_DOCUMENTS_PAYABLE | This view will store interim payables check and payment schedules information. Based on this view Oracle Payments will process data for formatting and building payment. |
| AP_INVOICE_LINES_V | Invoice Lines project. This is the base view for the Lines block on invoice workbench. |
| AP_PO_CORRECTIONS_V | PO Corrections. |
| AP_MATCH_CORRECTION_DISTS_V | Distribution level PO/RCV Corrections. |
| AP_RECEIPT_CORRECTIONS_V | Receipt Corrections. |
| AP_ALLOCATION_RULES_V | Invoice Lines – Allocations. |
Changed Views:
| View Name | Feature Area |
| AP_INVOICES_V | All the columns that were added to the base table due to the various projects were added to this view too. |
| AP_INVOICE_DISTRIBUTIONS_V | All the columns that were added to the base table due to the various projects were added to this view too. |
| PO_LINE_LOCATIONS_AP_V | PO Matching |
| AP_PO_DISTRIBUTIONS_AP2_V | PO Matching at distribution level. |
| PO_AP_RECEIPT_MATCH_V | Receipt Matching view |
| AP_APPLY_PREPAYS_V | Invoice Lines – Prepayment Application |
| AP_UNAPPLY_PREPAYS_V | Invoice Lines – Prepayment Application |
| AP_WF_APPROVAL_HISTORY_V | Invoice Approval Workflow |
Obsolete Views:
| View Name | Feature Area |
| AP_BANK_ACCOUNTS | Internal/External Bank Accounts Multi-Org View |
| AP_BANK_ACCOUNT_USES | External Bank Account Uses Multi-Org View |
| AP_BANK_ACCOUNT_USES_V | External Bank Accounts Uses Reference View |
TCA Changes for Suppliers:
New Tables:
The following are the new tables added in Release 12 as a part of this initiative. Refer to the Oracle E-Business Suite Electronic Technical Reference Manual for the table and column descriptions.
• AP_SUPPLIERS
• AP_SUPPLIER_SITES_ALL
• AP_SUPPLIER_CONTACTS
• AP_SUPPLIER_INT_REJECTIONS
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 obsoleted:
• PO_VENDORS
• PO_VENDOR_SITES_ALL
• PO_VENDOR_CONTACTS
0 comments