add

About Me

My photo
Oracle Apps - Techno Functional consultant

Wednesday, November 28

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.

No comments: