R12 AP
R12 AP
Payables
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_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 | Invoice Requests |
AP_NEGOTIATION_HIST | Holds Resolution Workflow |
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 due to almost all the projects done for R12, for list of columns added please refer to the TDD of the respective projects. |
AP_INVOICE_DISTRIBUTIONS_ALL | Invoice Lines, eBusiness Tax… | Number of columns were added to this table due to almost all the projects done for R12, for list of columns added please refer to the TDD of the respective projects. |
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 |
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. As described in the “Single Payment real-time Flow” diagrams this view will store real time payables data. As a result of this until or unless payment is created, this view will not contain any data for quick payments. |
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 |
New TablesTCA Changes for Suppliers
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
R12 FA AND AR
R12 FA I AR
Fixed Assets
New Tables
Table Name
Feature Area
Brief Description
CSI_FA_HEADERS
Notification Process for newly added assets.
This table captures asset related information about Fixed assets that are manually added using the Assets Workbench – The generated data is then used in the Generate Notification concurrent process.
CSI_FA_TRANSACTIONS
Notification Process for newly added assets.
This table captures transactional information about Fixed assets that are manually added using the Assets Workbench – The generated data is then used in the Generate Notification concurrent process.
CSI_I_ASSET_INTERFACE
Open Interface for Instance to Fixed Asset Association
This table if loaded with the instance and asset link information will be used by the “Install Base Open Interface” program to create the association between the item instance and the fixed asset.
Changed Tables
Table Name
Feature Area
Brief Description of Change
CSI_I_ASSETS
Improved Integration with Fixed Assets/Common Asset Repository
Added NEW Columns
· FA_SYNC_FLAG – This tracks whether the Fixed Assets and Item Instances are in sync with respect to quantities and Location Mapping.
· FA_MASS_ADDITION_ID – This is the new linking column that stores the information about the record that is written in to FA_MASS_ADDITIONS table when the Asset Tracking concurrent program creates the interface data to create a fixed asset.
· CREATION_COMPLETE_FLAG – Column that determines whether the instance to asset link is complete or not.
CSI_INSTANCE_INTERFACE
Install Base Open Interface
· Added Asset Maintenance (EAM) support columns
· Added instance attributes from 16 to 30
· Added operational status code column
· Added Sync up family column for internal processing.
Obsolete Tables
Table Name
Feature Area
Optional - Replaced By
CSI_I_ASSET_TXN_TEMP
Improved Integration with Fixed Asset
This table was used to temporarily hold data before creating assets in FA. Primarily used for grouping purpose. The grouping logic is now handled in the code.
iReceivables
New Tables
Table Name
Feature Area
AR_IREC_SELFREG_CUST_QS
Self Registration
AR_IREC_SELFREG_SITE_QS
Self Registration
ARI_REG_VERIFICATIONS_GT
Self Registration
AR_IREC_PRINT_REQUESTS
Print Request
Changed Tables
Table Name
Feature Area
Brief Description of Change
AR_SYSTEM_PARAMETERS_ALL
System Options Setup, the Receivables Activity type used for Convenience Charges.
Added column column IREC_SERVICE_CHARGE_REC_TRX_ID NUMBER(15)
Obsolete Tables
Table Name
Feature Area
Optional - Replaced By
AR_CUST_SEARCH_GT
Customer Search
AR_CUST_SEARCH_GT_ALL
AR_IREC_CUSTOM_CUST_GT
Custom Customer Search
AR_IREC_CSTM_CUST_GT_ALL
AR_IREC_CUSTOM_SRCH_GT
Custom Transaction Search
AR_IREC_CSTM_SRCH_GT_ALL
AR_IREC_PAYMENT_LIST_GT
Transaction List/Payment Page
AR_IREC_PAYMENT_GT_ALL
HZ_REGISTRATIONS
Self Registration
HZ_REG_VERIFICATIONS
Self Registration
New Views
View Name
Feature Area
ARI_CUSTOMER_SEARCH_V
Customer search for internal users
Changed Views
N/A
Obsolete Views
N/A
iExpenses
New Tables
Table Name
Feature Area
Brief Description
OIE_PDM_DAILY_BREAKUPS
Enhanced Global Per Diem and Mileage
This table holds per diem data for a rate period.
OIE_PDM_DESTINATIONS
This table holds per diem destination information.
OIE_ADDON_MILEAGE_RATES
This table stores additional information for a mileage expense type.
OIE_POL_RATES_INTERFACE
Staging table for uploading CONUS and OCONUS rates.
OIE_ALLOCATION_PREFS
Expense Allocations
This table stores a person's allocation preferences.
OIE_DISTRIBUTION_SETS
This table stores distribution sets that make up an allocation preference.
OIE_SET_DISTRIBUTIONS
This table holds the distribution lines that belong to a distribution set.
OIE_AME_NOTIFY_GT
Data in OIE_AME_NOTIF_GT will be used for displaying instructions to the approver in the approval notification. Example, You are responsible for approving expenses that total 250.00 USD for cost center 420.
OIE_AME_APPROVER_AMT_GT
Data in OIE_AME_APPROVER_AMT_GT will be used for displaying Approver Amount in the approval notification.
No comments:
Post a Comment