Oracle EBS Detail,Table

—  _ALL: Table holds all the information about different operating units. Multi-org environment. you can also set the MO_GLOBAL to specific operating unit to see the data specific to that operating unit only.

—  _TL:  Tables corresponding to another table with the same name use underscore _TL. These table provides multiple language support. For each item in the table without _TL there can be many rows in the _TL table, But all with different values in the language column.

—  _B:  These are the BASE tables. They are very important and all the data is stored in the table with all validations. it is supposed that these table will always contains the perfect format data. if anything happens to the BASE table data , then it is a data corruption issues.

—  _F: These are the Date tracked Tables, which occur in HR AND Payroll. For these are two date column EFFECTIVE_START_DATE

—  AND EFFECTIVE_END_DATE which together with PK identifies a row uniquely. The data intervals cannot overlap. 

—  many think they are secured data. Guess someone from oracle confirms. 

—  _V:  Tables are the views created on base tables.

—  _VL:  Are views for multi language tables which combines the row of the base tables with the corresponding

—          rows of the _TL table where LANGUAGE=USERENV('LANG');

—  -S:  are sequences ,used for finding the new values for the  primary key of a table.

—  _A: are audit shadow tables .

—  _AVN:  and ACN are audit shadow views(when data was changed, and with what values )

GL General Ledger Tables

—  GL_CODE_COMBINATIONS        àStores valid account combinations.

—  GL_LEDGERS                                 àStores Information about the ledgers.

—  GL_DAILY_RATES:                        àStores the daily conversion rates for foreign  currency.

—  GL_IMPORT_REFERENCES          à Stores  Individual  transactions from sub   ledgers.

—  GL_PERIODS                                  à Stores the information of accounting periods.

—  GL_JE_HEADERS                           à  Stores Journal Entries.

—  GL_JE_LINES                                  à Stores the Journal entry lines .

—  GL_JE_BATCHES                            à Stores Journal entry batches.

—  GL_JE_CATEGORIES_TL               à Journal entry categories.

—  GL_JE_SOURCES_TL                   àJournal entry sources

—  GL_PERIODS                                 àCalendar period definitions

AP Accounts Payables Tables

—  AP_ACCOUNTING_EVENTS_ALL      à  Accounting events Table

—  AP_AE_HEADERS_ALL                      à  Accounting entry headers tables

—  AP_AE_LINES_ALL                             à  Accounting entry lines tables

—  AP_INCOME_TAX_TYPES                      à  supplier types 

—  AP_TAX_CODES_ALL                            à Tax code information

—  AP_BATCHES_ALL                             à   Summary invoice batch information

—  AP_CHECKS_ALL                              à Supplier payment data

—  AP_HOLDS_ALL                                à Invoice hold Information

—  AP_INVOICE_ALL                             à Detailed invoice records

—  AP_INVOICE_LINES_ALL             à   Contains record for invoice lines entered manually

                                                 generated automatically o imported from open interface.

—  AP_INVOICE_DISTRIBUTION_ALL  à  Invoice distribution line information

—  AP_INVOICE_PAYMENTS_ALL         à Invoice payment records

—  AP_PAYMENT_DISTRIBUTIONS_ALL  à   Payment distribution information

—  AP_PAYMENT_HISTORY_ALL             à Maturity and reconciliation history

AP_PAYMENT_SCHEDULES_ALL      à scheduled payment information on invoices

—  AP_SUPPLIER                      à  Stores information about your supplier level attributes.    

—   AP_SUPPLIER_SITES_ALL  à Stores information about your supplier site levelattributes

—  AP_SUPPLIER_CONTRACTS    à Stores Supplier Contracts.

AR Accounts Receivables Tables

—  RA_CUST_TRX_TYPES_ALLàTransaction type for invoices, commitments and credit memos

—  RA_CUSTOMER_TRX_ALL             à Header -Level information about invoices, debits memos, charge backs commitments and credit  memos.

—  RA_CUSTOMER_TRX_LINES_ALL   à Invoice, Debit memo, chargeback, credit                                                                                         memo  and  commitment lines.

—  RA_CUST_TRX_LINES_GL_DIST_ALL à  Accounting records for revenue,                                                                                  unearned revenue and unbilled receivables.

—  RA_CUST_TRX_LINES_SALESRESP_ALL à Sales credit assignments for               transactions.

—  AR_ADJUSTMENTS_ALL                                 à     Pending and approved invoice    adjustments.

—  AR_CASH_RECEIPTS_ALL               à    Detailed receipt information

—  AR_CASH_RECEIPT_HISTORY_ALL  à  History of actions and status changes in                the life cycle  of a receipt.

—  AR_PAYMENT_SCHEDULES_ALL   à ALL Transactions except adjustments and               miscellaneous cash receipt.

—  AR_RECEIVABLE_APPLICATIONS_ALL à Accounting information for cash and                 credit memo applications.

PO   Purchase Order TABLES

—  PO_REQUISITION_HEADERS_ALL    à Requisition headers       

—  PO_REQUISITION_LINES_ALL           à Requisition lines

—  PO_REQ_DISTRIBUTIONS_ALL         à Requisition distributions .

—  PO_REQ_DIST_INTERFACE_ALL      à Interface table for requisition distributions.

—  PO_REQUISITIONS_INTERFACE_ALL à Requisition Import interface table

—  PO_INTERFACE_ERRORS                  à  Requisition import interface errors

—  PO_HEADERS_ALL àDocument headers (for purchase orders,purchase agreements, quotations,  RFQs).

—  PO_LINES_ALL   àPurchase document lines (for purchase orders,purchase  agreements, quotations,  RFQs) .

—  PO_HEADERS_INTERFACE                 à Interface table for purchase order headers

—  PO_LINES_INTERFACE                        à Interface table for purchase order lines .

—   PO_LINE_LOCATIONS_ALL       à Document shipment schedules

PO TABLES

—  PO_VENDORS                                      à  Suppliers (AP_SUPPLIER)

—  PO_VENDOR_SITES_ALL                    à  Supplier sites   (AP_SUPPLIER_SITES_ALL)                                                

(RECEIPT)

—  RCV_SHIPMENT_HEADERS            à Shipment and receipt header information

—  RCV_SHIPMENT_LINES                                    à Receiving shipment line information

—  RCV_TRANSACTIONS                       à Receiving transactions

— RCV_TRANSACTIONS_INTERFACE    à Receiving transactions interface table

(PO_TYPES)

—  PO_DOCUMENT_TYPES                       à Document types .

—  PO_VENDOR_CONTACTS                    à   Supplier contacts

RECEIPT                                                             PO TYPES                            

—  RCV_SHIPMENT_HEADERS            àPO_DOCUMENT_TYPES

—  RCV_SHIPMENT_LINES                  àPO_VENDORS--  (AP_SUPPLIER   IN R12)

—  RCV_TRANSACTIONS    à  PO_VENDORS_SITES_ALL   
                                               (AP_SUPPLIER_SITES_ALL IN  R12) 

                                                          àPO_VENDOR_CONTRACTS

                                                              à(AP_SUPPLIER_CONTRACTS IN R12)

—  PO_DISTRIBUTIONS_INTERFACE à Interface table for purchase order distributions

—  PO_DISTRIBUTIONS_ALL               à  Purchase order distributions

PER - Oracle Human Resources

—  HR_OPERATING_UNITS                     à Information about operating units.

—  PER_ALL_ORGANIZATION_UNITS    àUnsecured version of PER_ORGANIZATION_UNITS.            

—  PER_ALL_PEOPLE_F àDateTracked table holding personal information for employees, applicants and other people.

—  PER_ALL_ASSIGNMENTS_F             àEmployee and applicant assignment details.

—  PER_PERIODS_OF_SERVICE           à Period of service details for an employee.

—  PER_ALL_POSITIONS       àDual–maintained position definition  information.

—  PER_GRADES                    àGrade definitions for a business group.

—  PER_JOBS                          àJobs defined for a Business Group.

—  PER_CAREER_PATHS         àList of career paths for jobs

—  PER_COMPETENCES         à competence is a definition of knowledge,skills, abilities.

—  PER_CONTRACTS_F          àThe details of a persons contract of employment.

—  PER_QUALIFICATIONS   àA record of educational qualification,

—  PER_APPRAISALS           à An appraisal is a record of an evaluation of a  person by others

—  PER_ABSENCE_ATTENDANCES        à Records of absence, or attendance for an employee.

—  PER_ABS_ATTENDANCE_REASONS à Valid absence reasons for an bsence type.

—  PER_PAY_PROPOSALS   à Salary proposals and performance review information for employee assignments.

—  PER_ASSESSMENTS     àThe grouping of a set of assessment elements.

—  PER_CALENDAR_ENTRIES      àCalendar Entries.

—  PER_COMPETENCES         à  A competence is a definition of knowledge, skills.

—  PAY_PEOPLE_GROUPS      à People group flexfield information.

—  PER_PEOPLE_EXTRA_INFO  à Extra information for a                 person.

—  PER_POSITION_STRUCTURES         à Position Hierarchy names.

—  PER_DISABILITIES_F         àHold Disability information for one                 person.

(payroll)

—  PAY_ALL_PAYROLLS_F                 à Payroll group definitions.

—  PAY_ASSIGNMENT_ACTIONS     àAction or process results, showing which assignments have been processed by a specific payroll action, or process.

—  PAY_BACKPAY_RULES          àBalances to be recalculated by a RetroPay   process.

—  PAY_BALANCE_BATCH_HEADERS  àBatch header information for balance upload  batch.

—  PAY_BALANCE_BATCH_LINES   àIndividual batch lines for the balance upload               process.

—  PAY_BALANCE_TYPES                  àBalance information.

—  PAY_CONSOLIDATION_SETS                     àConsolidation set of results of payroll processing.

—  PAY_ELEMENT_CLASSIFICATIONS àElement classifications for legislation  and information

—  PAY_ELEMENT_ENTRIES_F             àElement entry list for each assignment.

—  PAY_GL_INTERFACE                        àCosted details to be passed to the General Ledger.

—  PAY_PAYROLL_ACTIONS                àHolds information about a payroll process.

—  PAY_RUN_RESULTS                       à Result of processing a single element entry.

—  PER_BUDGETS                               à Definitions of HR budgets.

—  HR_API_HOOKS                   à Lists the hook points which are available in each API module.

—  HR_PUMP_BATCH_HEADERSàStores information on a batch to be loaded by the data pump.

INV - Oracle Inventory

—  MTL_SYSTEM_ITEMS_B                      à   Inventory item definitions

—  MTL_CATEGORIES_B            à   Code combinations table for item     categories

—  MTL_ITEM_CATEGORIES                à    Define item assignments to categories

—  MTL_ITEM_LOCATIONS                       à    Definitions for stock locators

—  MTL_ITEM_SUB_INVENTORIES          à     Item–sub inventory assignments

—  MTL_ITEM_REVISIONS                        à     Item revisions.

—  MTL_MANUFACTURERS                      à     Define manufacturers

—  MTL_MATERIAL_TRANSACTIONS      à      Material transaction table

—  MTL_SECONDARY_INVENTORIES     à       Sub inventory definitions .

—  MTL_TRANSA.CTION_TYPES              à      Inventory Transaction Types Table

ORDER MANAGEMENT

—  SO_HEADERS_ALL                            à  Order header information.

—  SO_LINES_ALL                                   à  Order lines

—  SO_HEADERS_INTERFACE_ALL      à   Imported order header information

—  SO_LINES_INTERFACE_ALL             à  Imported order line information

—  SO_LINE_DETAILS_INTERFACE      à   Imported order line schedule details

—  SO_ORDER_TYPES                          à   Order types.

—  SO_PICKING_LINES_ALL                  à   Picking lines

—  SO_PRICE_LISTS                              à    Price lists

FND Application object Library Tables

—  FND_APPLICATION                              à       Application registered with AOL.

—  FND_CONCURRENT_PROGRAM        à      Concurrent Programs.
 FND_CONCURRENT_REQUESTS       à      Concurrent request information.

—  FND_CURRENCIES                              à      Currencies enabled  for use at your site

—  FND_FLEX_VALUE_SETS                    à      Value sets information.

—  FND_FLEX_VALUES                             à      Valid values for value sets.

—  FND_FORM                                           à      Forms

—  FND_FORM_FUNCTIONS                    à      Form Functions information.

—  FND_ID_FLEXS                                    à       Key  flex fields.

—  FND_ID_FLEX_SEGMENTS                à        Key flex fields segment values

—  FND_LOOKUP_TYPES                        à        AOL Quick codes

—  FND_LOOKUP_VALUES                      à        Quick code values.

—  FND_MENUS                                        à        Menu details

—  FND_PROFILE_OPTIONS                    à        User profile options .

—  FND_REQUEST_SETS                         à        Request sets

—  FND_USER                                           à        User Details