Thursday, April 5, 2012

Oracle APPS Important Tables


ONT
Order Management
OE_ORDER_HEADERS_ALL
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.                 
OE_ORDER_LINES_ALL
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.              
OE_ORDER_SOURCES
Feeder System Names that create orders in Order Management tables.               
OE_ORDER_HOLDS_ALL
This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.  
OE_SALES_CREDITS
This table stores information about sales credits.                  
OE_TRANSACTION_TYPES_ALL
This table stores information about the order and line transaction types              
WSH_DELIVERY_ASSIGNMENTS
Delivery Assignments
WSH_DELIVERY_DETAILS
Delivery Details
WSH_NEW_DELIVERIES
Deliveries
WSH_TRIPS
Trips
WSH_TRIP_STOPS
Trip Stops


PO
Purchasing
PO_ACTION_HISTORY
Document approval and control action history table                  
PO_AGENTS
Buyers table
PO_DISTRIBUTIONS_ALL
Purchase order distributions                      
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_LINE_LOCATIONS_ALL
Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)               
PO_RELEASES_ALL
Purchase order releases                      
PO_LINES_ARCHIVE_ALL
Archived purchase order lines                      
PO_LINE_LOCATIONS_ARCHIVE_ALL
Archived purchase order shipments                     
PO_HEADERS_ARCHIVE_ALL
Archived purchase orders                      
PO_LINE_TYPES_B
Line types
PO_RELEASES_ARCHIVE_ALL
Archived releases
PO_REQUISITION_HEADERS_ALL
Requisition headers
PO_REQUISITION_LINES_ALL
Requisition lines
PO_REQ_DISTRIBUTIONS_ALL
Requisition distributions
RCV_TRANSACTIONS
Receiving transactions
RCV_SHIPMENT_HEADERS
Shipment and receipt header information                    
RCV_SHIPMENT_LINES
Receiving shipment line information                     


INV
Inventory
MTL_CATEGORIES_B
Code combinations table for Item Category                   
MTL_CATEGORY_SETS_B
Category Sets
MTL_CUSTOMER_ITEMS
Customer item Information                      
MTL_CUSTOMER_ITEM_XREFS
Relationships between customer items and inventory items                  
MTL_DEMAND
Sales order demand and reservations                    
MTL_DEMAND_HISTORIES
Sales order demand and reservations                    
MTL_ITEM_LOCATIONS
Definitions for stock locators                     
MTL_ITEM_REVISIONS_B
Item revisions
MTL_ITEM_TEMPLATES_B
Item template definitions                      
MTL_ITEM_TEMPL_ATTRIBUTES
Item attributes and attribute values for a template                 
MTL_LOT_NUMBERS
Lot number definitions                       
MTL_MATERIAL_TRANSACTIONS
Material transaction table                      
MTL_MATERIAL_TRANSACTIONS_TEMP
Temporary table for processing material transactions                   
MTL_ONHAND_QUANTITIES_DETAIL
FIFO quantities by control level and receipt                  
MTL_PARAMETERS
Inventory control options and defaults                    
MTL_RESERVATIONS
Reservations
MTL_SECONDARY_INVENTORIES
Subinventory definitions
MTL_SECONDARY_LOCATORS
Item-subinventory-locator assignments
MTL_SERIAL_NUMBERS
Serial number definitions                      
MTL_SYSTEM_ITEMS_B
Inventory item definitions                      
MTL_TRANSACTION_ACCOUNTS
Material transaction distributions                      
MTL_TRANSACTION_TYPES
Inventory Transaction Types Table                     
MTL_TXN_REQUEST_HEADERS
Move Order headers table                     
MTL_TXN_REQUEST_LINES
Move order lines table                     
MTL_UNIT_TRANSACTIONS
Serial number transactions                      


GL
General Ledger
GL_CODE_COMBINATIONS
Stores valid account combinations                     
GL_SETS_OF_BOOKS
Stores information about the sets of books                  
GL_IMPORT_REFERENCES
Stores individual transactions from subledgers                    
GL_DAILY_RATES
Stores the daily conversion rates for foreign currency Transactions                 
GL_PERIODS
Stores information about the accounting periods                   
GL_JE_HEADERS
Stores journal entries                      
GL_JE_LINES
Stores the journal entry lines that you enter in the Enter Journals form             
GL_JE_BATCHES
Stores journal entry batches                     
GL_BALANCES
Stores actual, budget, and encumbrance balances for detail and summary accounts              
GL_BUDGETS
Stores Budget definitions                      
GL_INTERFACE
Import journal entry batches                     
GL_BUDGET_INTERFACE
Upload budget data from external sources                   
GL_DAILY_RATES_INTERFACE
Import daily conversion rates                     


AR
Accounts Receivables
RA_CUST_TRX_TYPES_ALL
Transaction type for invoices, commitments and credit memos                 
RA_CUSTOMER_TRX_ALL
Header-level information about invoices, debit memos, chargebacks, commitments and credit memos               
RA_CUSTOMER_TRX_LINES_ALL
Invoice, debit memo, chargeback, credit memo and commitment lines                
RA_CUST_TRX_LINE_GL_DIST_ALL
Accounting records for revenue, unearned revenue and unbilled receivables                
RA_CUST_TRX_LINE_SALESREPS_ALL
Sales credit assignments for transactions                    
AR_ADJUSTMENTS_ALL
Pending and approved invoice adjustments                    
RA_BATCHES_ALL

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 receipts                 
AR_RECEIVABLE_APPLICATIONS_ALL
Accounting information for cash and credit memo applications                 
AR_TRANSACTION_HISTORY_ALL
Life cycle of a transaction                    
HZ_CUST_ACCOUNTS
Stores information about customer accounts.                    
HZ_CUSTOMER_PROFILES
Credit information for customer accounts and customer account sites                
HZ_CUST_ACCT_SITES_ALL
Stores all customer account sites across all operating units                
HZ_CUST_ACCT_RELATE_ALL
Relationships between customer accounts                     
HZ_CUST_CONTACT_POINTS
This table is no longer used                   
HZ_CUST_PROF_CLASS_AMTS
Customer profile class amount limits for each currency                 
HZ_CUST_SITE_USES_ALL
Stores business purposes assigned to customer account sites.                 
HZ_LOCATIONS
Physical addresses
HZ_ORG_CONTACTS
People as contacts for parties                    
HZ_ORG_CONTACT_ROLES
Roles played by organization contacts                    
HZ_PARTIES
Information about parties such as organizations, people, and groups                
HZ_PARTY_SITES
Links party to physical locations                    
HZ_PARTY_SITE_USES
The way that a party uses a particular site or address              
HZ_RELATIONSHIPS
Relationships between entities                      
HZ_RELATIONSHIP_TYPES
Relationship types


CE
Cash Management
CE_BANK_ACCOUNTS
This table contains bank account information. Each bank account must be affiliated with one bank branch.         
CE_BANK_ACCT_BALANCES
This table stores the internal bank account balances                 
CE_BANK_ACCT_USES_ALL
This table stores information about your bank account uses.                
CE_STATEMENT_HEADERS
Bank statements
CE_STATEMENT_LINES
Bank statement lines                      
CE_STATEMENT_HEADERS_INT
Open interface for bank statements                    
CE_STATEMENT_LINES_INTERFACE
Open interface for bank statement lines                   
CE_TRANSACTION_CODES
Bank transaction codes                      
AP-
Accounts Payables
Table
Name Description
AP_ACCOUNTING_EVENTS_ALL
Accounting events table                      
AP_AE_HEADERS_ALL
Accounting entry headers table                     
AP_AE_LINES_ALL
Accounting entry lines table                     
AP_BANK_ACCOUNTS_ALL
Bank Account Details                      
AP_BANK_ACCOUNT_USES_ALL
Bank Account Uses Information                     
AP_BANK_BRANCHES
Bank Branches
AP_BATCHES_ALL
Summary invoice batch information                     
AP_CHECKS_ALL
Supplier payment data                      
AP_HOLDS_ALL
Invoice hold information                      
AP_INVOICES_ALL
Detailed invoice records                      
AP_INVOICE_LINES_ALL
AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.         
AP_INVOICE_DISTRIBUTIONS_ALL
Invoice distribution line information                     
AP.AP_INVOICE_PAYMENTS_ALL
Invoice payment records                      
AP_PAYMENT_DISTRIBUTIONS_ALL
Payment distribution information                      
AP_PAYMENT_HISTORY_ALL
Maturity and reconciliation history for Payments                   
AP_PAYMENT_SCHEDULES_ALL
Scheduled payment information on invoices                    
AP_INTERFACE_REJECTIONS
Information about data that could not be loaded by Payables Open Interface Import            
AP_INVOICES_INTERFACE
Information used to create an invoice using Payables Open Interface Import              
AP_INVOICE_LINES_INTERFACE
Information used to create one or more invoice distributions                 
AP_SUPPLIERS
AP_SUPPLIERS stores information about your supplier level attributes.                 
AP_SUPPLIER_SITES_ALL
AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.                
AP_SUPPLIER_CONTACTS
Stores Supplier Contacts                      


FA
Fixed Assets
FA_ADDITIONS_B
Descriptive information about assets                     
FA_ADJUSTMENTS
Information used by the posting program to generate journal entry lines in the general ledger          
FA_ASSET_HISTORY
Historical information about asset reclassifications and unit adjustments                 
FA_ASSET_INVOICES
Accounts payable and purchasing information for each asset                 
FA_BOOKS
Financial information of each asset                    
FA_BOOK_CONTROLS
Control information that affects all assets in a depreciation book               
FA_CALENDAR_PERIODS
Detailed calendar information                      
FA_CALENDAR_TYPES
General calendar information                      
FA_CATEGORIES_B
Default financial information for asset categories                   
FA_CATEGORY_BOOKS
Default financial information for an asset category and depreciation book combination              
FA_DEPRN_DETAIL
Depreciation amounts charged to the depreciation expense account in each distribution line             
FA_DEPRN_PERIODS
Information about each depreciation period                    
FA_DEPRN_EVENTS
Information about depreciation accounting events.                    
FA_DEPRN_SUMMARY
Depreciation information at the asset level                    
FA_DISTRIBUTION_ACCOUNTS
Table to store account ccids for all distributions for a book              
FA_DISTRIBUTION_DEFAULTS
Distribution set information                      
FA_DISTRIBUTION_HISTORY
Employee, location, and Accounting Flexfield values assigned to each asset               
FA_DISTRIBUTION_SETS
Header information for distribution sets                    
FA_FORMULAS
Depreciation rates for formula-based methods                     
FA_LOCATIONS
Location flexfield segment value combinations                    
FA_MASS_ADDITIONS
Information about assets that you want to automatically add to Oracle Assets from another system          
FA_METHODS
Depreciation method information                      
FA_RETIREMENTS
Information about asset retirements and reinstatements                   


HRMS
Human Resource Management System                     
HR_ALL_ORGANIZATION_UNITS
Organization unit definitions.                      
HR_ALL_POSITIONS_F
Position definition information.                      
HR_LOCATIONS_ALL
Work location definitions.                      
PER_ADDRESSES
Address information for people                      
PER_ALL_PEOPLE_F
DateTracked table holding personal information for employees, applicants and other people.              
PER_ALL_ASSIGNMENTS_F
Allocated Tasks
PER_ANALYSIS_CRITERIA
Flexfield combination table for the personal analysis key flexfield.                
PER_ASSIGNMENT_EXTRA_INFO
Extra information for an assignment.                    
PER_ASSIGNMENT_STATUS_TYPES
Predefined and user defined assignment status types.                  
PER_CONTRACTS_F
The details of a persons contract of employment                 
PER_CONTACT_RELATIONSHIPS
Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.              
PER_GRADES
Grade definitions for a business group.                   
PER_JOBS
Jobs defined for a Business Group                   
PER_PAY_BASES
Definitions of specific salary bases                     
PER_PAY_PROPOSALS
Salary proposals and performance review information for employee assignments                
PER_PEOPLE_EXTRA_INFO
Extra information for a person                    
PER_PERIODS_OF_PLACEMENT
Periods of placement details for a non-payrolled worker                 
PER_PERIODS_OF_SERVICE
Period of service details for an employee.                  
PER_PERSON_ANALYSES
Special information types for a person                   
PER_PERSON_TYPES
Person types visible to specific Business Groups.                  
PER_PERSON_TYPE_USAGES_F
Identifies the types a person may be.                  
PER_PHONES
PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.           
PER_SECURITY_PROFILES
Security profile definitions to restrict user access to specific HRMS records              


PAY
Payroll
PAY_ACTION_INFORMATION
Archived data stored by legislation                    
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_ELEMENT_CLASSIFICATIONS
Element classifications for legislation and information needs.                  
PAY_ELEMENT_ENTRIES_F
Element entry list for each assignment.                   
PAY_ELEMENT_ENTRY_VALUES_F
Actual input values for specific element entries.                  
PAY_ELEMENT_LINKS_F
Eligibility rules for an element type.                   
PAY_ELEMENT_TYPES_F
Element definitions.
PAY_ELEMENT_TYPE_USAGES_F
Used to store elements included or excluded from a defined run type.             
PAY_ORG_PAYMENT_METHODS_F
Payment methods used by a Business Group.                  
PAY_PAYMENT_TYPES
Types of payment that can be processed by the system.                
PAY_PAYROLL_ACTIONS
Holds information about a payroll process.                   
PAY_PEOPLE_GROUPS
People group flexfield information.                     
PAY_PERSONAL_PAYMENT_METHODS_F
Personal payment method details for an employee.                  
PAY_RUN_RESULTS
Result of processing a single element entry.                  
PAY_RUN_RESULT_VALUES
Result values from processing a single element entry.                 
PAY_SECURITY_PAYROLLS
List of payrolls and security profile access rules.                 
PAY_INPUT_VALUES_F
Input value definitions for specific elements.                   


BOM
Bills Of Material
BOM_DEPARTMENTS
Departments
BOM_DEPARTMENT_CLASSES
Department classes
BOM_DEPARTMENT_RESOURCES
Resources associated with departments                     
BOM_OPERATIONAL_ROUTINGS
Routings
BOM_OPERATION_NETWORKS
Routing operation networks                      
BOM_OPERATION_RESOURCES
Resources on operations                      
BOM_OPERATION_SEQUENCES
Routing operations
BOM_OPERATION_SKILLS

BOM_RESOURCES
Resources, overheads, material cost codes, and material overheads                 
BOM_STANDARD_OPERATIONS
Standard operations
BOM_ALTERNATE_DESIGNATORS
Alternate designators
BOM_COMPONENTS_B
Bill of material components                     
BOM_STRUCTURES_B
Bills of material                      
BOM_STRUCTURE_TYPES_B
Structure Type master table                     


WIP
Work in Process
WIP_DISCRETE_JOBS
Discrete jobs
WIP_ENTITIES
Information common to jobs and schedules                   
WIP_LINES
Production lines
WIP_MOVE_TRANSACTIONS
Shop floor move transactions                     
WIP_MOVE_TXN_ALLOCATIONS
Move transaction allocations for repetitive schedules                   
WIP_OPERATIONS
Operations necessary for jobs and schedules                    
WIP_OPERATION_NETWORKS
Operation dependency
WIP_OPERATION_OVERHEADS
Overheads for operations in an average costing organization                 
WIP_OPERATION_RESOURCES
Resources necessary for operations                     
WIP_OPERATION_YIELDS
This table keeps all costing information for operation yield costing.               
WIP_TRANSACTIONS
WIP resource transactions                      
WIP_TRANSACTION_ACCOUNTS
Debits and credits due to resource transactions                  


FND
Appication Object Library
FND_APPLICATION
Applications registered with Oracle Application Object Library                  
FND_CONCURRENT_PROGRAMS
Concurrent programs
FND_CONCURRENT_REQUESTS
Concurrent requests information                      
FND_CURRENCIES
Currencies enabled for use at your site                  
FND_DATA_GROUPS
Data groups registered with Oracle Application Object Library                 
FND_FLEX_VALUES
Valid values for flexfield segments                    
FND_FLEX_VALUE_HIERARCHIES
Child value ranges for key flexfield segment values                 
FND_FLEX_VALUE_SETS
Value sets used by both key and descriptive flexfields                
FND_FORM
Application forms registered with Oracle Application Object Library                 
FND_FORM_FUNCTIONS
Functionality groupings
FND_ID_FLEXS
Registration information about key flexfields                    
FND_ID_FLEX_SEGMENTS
Key flexfield segments setup information and correspondences between table columns and key flexfield segments           
FND_ID_FLEX_STRUCTURES
Key flexfield structure information                     
FND_LOOKUP_TYPES
Oracle Application Object Library QuickCodes                    
FND_LOOKUP_VALUES
QuickCode values
FND_MENUS
New menu tabl for Release 10SC                   
FND_PROFILE_OPTIONS
User profile options                      
FND_PROFILE_OPTION_VALUES
Values of user profile options defined at different profile levels               
FND_REQUEST_SETS
Reports sets
FND_REQUEST_SET_PROGRAMS
Reports within report sets                     
FND_REQUEST_SET_STAGES
Stores request set stages                     
FND_RESPONSIBILITY
Responsibilities
FND_RESP_FUNCTIONS
Function Security
FND_USER
Application users


JA
Asia/Pacific Localizations
JAI_CMN_BOE_HDRS
Stores BOE header info when a BOE Invoice is created through IL             
JAI_CMN_BOE_DTLS
Detail table for BOE Invoices                    
JAI_CMN_TAXES_ALL
Master table for Localization Taxes                    
JAI_CMN_TAX_CTGS_ALL
Stores tax categories and their link to excise ITEM classes.               
JAI_CMN_TAX_CTG_LINES
Stores the tax lines for defined tax categories                 
JAI_CMN_VENDOR_SITES
Stores excise account related information about vendors.                   
JAI_RGM_DEFINITIONS
Stores regime information.                      
JAI_RGM_TAXES
This table stores tax details for transactions having TCS tax type.              
JAI_CMN_RG_23AC_I_TRXS
Stores Information of RG23A/C records and known as Quantity Register.               
JAI_CMN_RG_23AC_II_TRXS
Stores Information of RG23A/C Part II Details. Also known as Amount Register             
JAI_CMN_RG_23D_TRXS
Quantity register for Trading Organizations                    
JAI_CMN_RG_BALANCES
Store the current balances of RG23A, RG23C and PLA Registers               
JAI_CMN_RG_PLA_TRXS
Stores the Transaction Information of PLA Register.                   
JAI_CMN_RG_PLA_HDRS
Stores PLA header Infomation when a PLA invoice is created in AP module            
JAI_CMN_RG_PLA_DTLS
Stores PLA Detail Information when a PLA Invoice is created in AP Module            


QP
Advanced Pricing
QP_LIST_HEADERS_B
QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.     
QP_LIST_LINES
QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.                
QP_PRICE_FORMULAS_B
QP_PRICE_FORMULAS_B stores the pricing formula header information.                  
QP_PRICE_FORMULA_LINES
QP_PRICE_FORMULA_LINES stores each component that makes up the formula.                 
QP_PRICING_ATTRIBUTES
QP_PRICING_ATTRIBUTES stores product information and pricing attributes.                  
QP_QUALIFIERS
QP_QUALIFIERS stores qualifier attribute information.                    


XLA
Subledger Accounting
XLA_EVENTS
The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE.      
XLA_TRANSACTION_ENTITIES
The table XLA_ENTITIES contains information about sub-ledger document or transactions.               
XLA_AE_HEADERS
The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry headers.      
XLA_AE_LINES
The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines. 
XLA_DISTRIBUTION_LINKS
The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines.            
XLA_ACCOUNTING_ERRORS
The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program.             
XLA_ACCTG_METHODS_B
The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of accounts specific. Enabled SLAMs are assigned to ledgers.
XLA_EVENT_TYPES_B
The XLA_EVENT_TYPES_B table stores all event types that belong to an event class.            
XLA_GL_LEDGERS
This table contains ledger information used by subledger accounting.                

18 comments:

Khalid Mehmood said...

Excellent work. Really helpful.

Arun Rathna Kumar said...

Great to see this link its very helpful for every one who is technical and functional also

Thanks Friend Keep on doing !!!!! Great

Siva T V said...

Many Thanks

suresh said...

yes really excellent work

saurabh.oracleapps said...

Its a great work...How to copy this table??

christine gathagu said...

thanks for the post. It has really helped!!

Hendra Kusuma W. said...

Thx it helps

Khanh Nguyen said...

Thanks

sadeesh s said...

thanks

gudla lokesh reddy said...

good collection

Anonymous said...

Hi need some help, how can i extract the details same as what placed in a line transaction flexfield in backend?

doxuandu do xuan du said...

Thanks add verry much

Raju Ch said...

Thank You

Bharathn1 said...

Thank you sir

Unknown said...

Master table which stores entries of EBS
as temp table are
AP_INVOICE_INTERFACE
and AP_INVOICE_LINE_INTERFACE

febriyant abidin said...

nice work

ABUALBARAA JEDDAH said...

VERY HELP FULL, THANKS

Unknown said...

very helpful thanks. Appreciate the effort put in and sharing in a consolidated format

Post a Comment

Best Blogger TipsGet Flower Effect