Oracle Module wise Tables

1.      What are the key tables in Fixed Assets, Cash Management, Accounts Payables, Accounts Receivable and General Ledger modules?

Ans.  General Ledger

Base Tables	Interface Tables
GL_JE_HEADERS GL_JE_LINES GL_JE_BATCHES GL_JE_SOURCES GL_JE_CATEGORIES GL_SET_OF_BOOKS GL_DAILY_RATES GL_BALANCES GL_PERIODS GL_LOOKUPS GL_CODE_COMBINATIONS GL_IMPORT_REFRENCES	GL_INTERFACE GL_BUDGET_INTERFACE GL_INTERFACE_HISTORY GL_DAILY_RATES_INTERFACE GL_IEA_INTERFACE

SLA (Sub Ledger Accounting)

Base Tables	Interface Tables
XLA_AE_HEADERS XLA_AE_LINES XLA_TRANSACTION_ENTITIES XLA_DISTRIBUTION_LINKS XLA_EVENTS XLA_JE_CATEGORIES XLA_EVENT_SOURCES XLA_JE_LINE_TYPES

 
Fixed Assets

Base Tables	Interface Tables
FA_ADDITION_B FA_ADDITION_TL FA_BOOKS FA_DEPRN_SUMMARY FA_DEPRN_DETAILS FA_DEPRN_HISTORY RA_RETIREMENTS FA_ADJUSTMENTS FA_ASSET_KEYWORDS	FA_PRODUCTION_INTERFACE FA_INV_INTERFACE FA_MASS_ADDITIONS

      Accounts Payables

Base Tables

Interface Tables

AP_INVOICES_ALL AP_INVOICE_LINES_ALL AP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_PAYMENTS_ALL AP_SUPPLIERS AP_CHECKS_ALL AP_PAYMENT_DISTRIBUTIONS_ALL AP_AE_HEADERS_ALL AP_AE_LINES_ALL AP_BATCHES_ALL AP_LOOKUP_CODES AP_BANK_ACCOUNTS_ALL AP_ACCOUNTING_EVENTS_ALL AP_SUPPLIER_SITES_ALL AP_SUPPLIER_CONTACTS AP_PAYMENT_HISTORY_ALL AP_EXPENSE_REPORTS_ALL AP_EXPENSE_REPORT_HEADERS_ALL AP_EXPENSE_REPORT_LINES_ALL AP_HOLDS_ALL

AP_INVOICE_INTERFACE AP_INVOICE_LINE_INTERFACE AP_SUPPLIERS_INT AP_SUPPLIER_SITES_INT AP_SUP_SITE_CONTACT_INT

Cash Management

Base Tables	Interface Tables
CE_BANK_ACCOUNTS CE_BANK_ACCT_BALANCES CE_BANK_ACCT_USES_ALL CE_PAYMENT_DOCUMENTS CE_BANK_STMT_MAP_HDR CE_BANK_STMT_MAP_LINE CE_CASHFLOWS CE_CHECKBOOKS CE_PAYMENT_DOCUMENTS CE_PAYMENT_TRANSACTIONS CE_RECONCILIATION_ERRORS CE_STATEMENT_HEADERS CE_STATEMENT_HEADERS_ALL CE_FORECAST_PERIODS	CE_STATEMENTS_HEADERS_INT_ALL CS_STATEMENT_LINES_INTERFACE

      Accounts Receivable

Base Tables	Interface Tables
AR_CUSTOMERS AR_PAYMENT_SCHEDULES_ALL AR_ADJUSTMENTS_ALL AR_DISTRIBUTIONS_ALL AR_TRANSACTION_HISTORY_ALL AR_CASH_RECEIPTS_ALL AR_DISTRIBUTION_SETS_ALL AR_RECEIVABLES_TRX_ALL AR_PERIODS AR_PERIOD_TYPES AR_VAT_TAX_ALL RA_TERMS	AR_PAYMENTS_INTERFACE_ALL AR_TAX_INTERFACE RA_INTERFACE_LINES_ALL RA_INTERFACE_DISTRIBUTIONS_ALL RA_INTERFACE_SALESCREDITS_ALL RA_CUSTOMERS_INTERFACE_ALL RA_CONTACT_PHONES_INT_ALL RA_CUSTOMER_BANKS_INT_ALL RA_CUST_PAY_METHOD_INT_ALL RA_CUSTOMER_PROFILES_INT_ALL RCV_HEADERS_INTERFACE RCV_TRANSACTIONS_INTERFACE

     TCA (Trading Community Architecture)

Base Tables	Interface Tables
HZ_PARTIES HZ_RELATIONSHIPS HZ_RELATIONSHIP_TYPES HZ_CONTACT_POINTS HZ_PARTY_SITES HZ_LOCATIONS HZ_ORGANIZATION_PROFILES HZ_ORG_CONTACTS HZ_ORG_CONTACT_ROLES HZ_LOCATIONS HZ_CUSTOMER_PROFILES HZ_CUST_SITE_USES_ALL HZ_CUST_ACCT_SITES_ALL	HZ_PARTY_INTERFACE HZ_PARTY_INTERFACE_ERRORS

2.      What are the Key responsibilities in each of the modules?

Ans. Key Responsibilities associated with each module.

Module	Responsibility
AP	AP INVOICE USER
	AP PAYMENTS USER
	PAYABLES MANAGER
	FINANCE SUPER USER AP
GL	FINANCE SUPER USER GL
FA	FINANCE SUPER USER FA
	FIXED ASSETS MANAGER
Cash Management	SUPER USER CE
	CASH MANAGEMENT SUPERUSER

3.      What is Oracle Ebis release 12.1.1, what are the key points in this release?

Ans. Oracle Ebis release 12.1.1 is the new release by oracle which has been introduced in May 2009 for download. R12.1.1 focuses on both Rapid Install (RI) and Maintenance Pack options (MP).

Rapid Install (RI): It is used to create a new environment for Oracle Ebis release 12.1.1. It allows upgrading from EBS 11.5.9, 11.5.10, 11.5.10.CU1, and 11.5.10.CU2 to 12.1.1, i.e. from R11i, we can use R12.1 RI from the software delivery cloud simply by following instructions from the “Upgrade Guide: 11i to 12.1” and “12.1.1Release notes”.
Maintenance Pack (MP): It is used to upgrade an existing Oracle E-Business Suite Release 12.0.x environment to 12.1.1.For e.g. If we are on R12.0.X, we can use R12.1 MP (7303030) from My Oracle Support (MOS) to upgrade it, simply by following instructions from “R12.1 Maintenance Pack Install Instructions (752619.1)”.

Key Points of Oracle Ebis release 12.1.1

1). Oracle E-Business Suite Release 12.1.1 includes new product functionality, enhancements to existing functionality, and fixes for improved stability, security, and performance, supply chain management, procurement, projects, master data management, customer relationship management and financials.  It introduces 21 new products.
2). R 12.1.1 includes all the updates and fixes that were previously released in 12.0.1, 12.0.2, 12.0.3, 12.0.4, 12.0.5, and 12.0.6 versions.
3). R 12.1.1 Rapid Install (RI) includes the following Critical Patch Update (CPU) security patch sets for these technology stack components:

• Database 11.1.0.7 - January 2009 Critical Patch Update
• Fusion Middleware 10g Release 2 (10.1.2.3) - October 2008 Critical Patch Update
• Fusion Middleware 10g Release 3 (10.1.3.4) - October 2008 Critical Patch Update
• E-Business Suite - April 2009 Critical Patch Update

4).We can download R 12.1.1 for both new and upgrading customers through Oracle Electronic Product Delivery (EPD) and the Oracle Store.

5). R12.1 is available as stand-alone solutions available for some of major products like

• Supply Chain Management
• Oracle Sourcing On Demand
• Oracle Incentive Compensation
• Oracle Warehouse Management.

6). R 12.1 will be delivers integrated analytics from Oracle BI Applications.

7). Enhancement in the some of the key features of the R12.1 which include an integrated talent management solution with enhancements to Recruiting, Succession Planning, and Performance and Learning Management.

8). The Oracle E-Business Suite Release 12.1 helps companies achieve rapid value by offering stand-alone solutions that complement existing Oracle E-Business Suite 11i or Release 12 environments. Customers can take advantage of rapid value solutions without having to upgrade to this latest release.