Oracle R12 Project Tables

Sr. No	Table Name	Description/ Uses
1	A_PROJECTS_ALL	It stores the highest units of work defined in Oracle Projects.
2	PA_PROJECT_ASSETS_ALL	It contains assets information defined for capital projects.
3	PA_PROJECT_ASSIGNMENTS	It stores details of all Assignments for a project.
4	PA_PROJECT_CLASSES	It contains the class codes of class categories that are used to classify projects.
5	PA_PROJECT_ROLE_TYPES	Implementation-defined responsibilities or positions assigned to employees on projects are stored here.
6	PA_PROJECT_STATUSES	It stores valid project status codes.
7	PA_PROJECT_TYPES_ALL	It stores implementation-defined project classifications that supply default information and drive some project processing.
8	PA_TASKS	It contains user-defined subdivisions of project work.
9	PA_TASK_TYPES	It stores implementation-defined classifications of task.
10	PA_TRANSACTION_INTERFACE_ALL	It is an interface table to import transactions from external sources into Oracle Projects.
11	PA_TRANSACTION_SOURCES	It stores implementation-defined sources of imported transactions originating in an external system.
12	PA_IMPLEMENTATIONS_ALL	It contains information about the configuration of an Oracle Projects installation.
13	PA_ACTION_SETS	It stores action set templates as well as action sets belonging to an object, such as projects, requirements, etc.
14	PA_ACTION_SET_LINES	It stores action set lines that belong to an action set or an action set template.
15	PA_ACTION_SET_TYPES	It stores attributes of action set types.
16	PA_AGREEMENTS_ALL	It has customer contracts that serve as the basis for work authorization.
17	PA_AGREEMENT_TYPES	Implementation-defined classifications of customer agreements.
18	PA_BILL_RATES_ALL	Information about bill rates and markups of standard bill rate schedules.
19	PA_BUDGETS	It stores budgets information.
20	PA_BUDGET_LINES	It stores detail lines of project and task budgets.
21	PA_BUDGET_TYPES	It contains implementation-defined classifications of types of budgets used for different business purposes.
22	PA_CLASS_CATEGORIES	It stores implementation-defined categories for classifying projects.
23	PA_CLASS_CODES	It stores implementation-defined values within class categories that can be used to classify projects.
24	PA_EVENTS	It stores entries assigned to tasks that generate revenue and/or billing but are not directly related to expenditure items.
25	PA_EVENT_TYPES	It stores implementation-defined classifications of events.
26	PA_EXPENDITURES_ALL	Groups of expenditure items incurred by employees or organizations for an expenditure period.
27	PA_EXPENDITURE_CATEGORIES	Implementation-defined groupings of expenditure types by type of cost.
28	PA_EXPENDITURE_ITEMS_ALL	It contains the smallest units of expenditure charged to projects and tasks.
29	PA_EXPENDITURE_TYPES	Implementation-defined classifications of expenditures charged to projects and tasks.
30	PA_PERIODS_ALL	Implementation-defined periods against which project performance is measured.
31	PA_RBS_DENORM	This table stores normalized resource breakdown structure information.
32	PA_RBS_ELEMENTS	This table stores the RBS element information and the parent-child relationship.
33	PA_RESOURCES	It contains resources used in budgeting and project summary amounts.
34	PA_ROLE_LISTS	It stores lists of roles defined with the system.
35	PA_SCHEDULES	It displays the schedule details for requirements and assignments. It also displays calendar schedules

Oracle R12 Purchasing Tables

Sr. No	Table Name	Description/ Uses
1	PO_ACTION_HISTORY	Document Approval and control action history table
2	PO_AGENTS	Buyers table
3	PO_DISTRIBUTIONS	All Purchase order distributions
4	PO_HEADERS_ALL	Document Headers (For Purchase Orders, Purchase Agreements, quotations, RFQ's)
5	PO_LINES_ALL	Purchase Document Lines (For Purchase Orders, Purchase Agreements, quotations, RFQ's)
6	PO_LINES_LOCATIONS_ALL	Document Shipment Schedules (For Purchase Orders, Purchase Agreements, quotations, RFQ's)
7	PO_RELEASES_ALL	Purchase Order Releases
8	PO_LINES_ARCHIVE_ALL	Archived Purchase Order Lines
9	PO_LINE_LOCATIONS_ARCHIVE_ALL	Archived Purchased Order Shipments
10	PO_HEADERS_ARCHIVE_ALL	Archived Purchase Orders
11	PO_LINE_TYPES_B	Line Types
12	PO_RELEASES_ARCHIVE_ALL	Archived PO Releases
13	PO_REQUISITION_HEADERS_ALL	Requisition Headers
14	PO_REQUISITION_LINES_ALL	Requisition Lines
15	PO_REQ_DISTRIBUTIONS_ALL	Requisition Distributions
16	RCV_TRANSACTIONS	Receiving Transactions
17	RCV_SHIPMENT_HEADERS	Shipment and Receipt Header Information
18	RCV_SHIPMENT_LINES	Receiving Shipment Line Information

Oracle R12 Inventory Tables

Sr. No	Table Name	Description/ Uses
1	MTL_PARAMETERS	It maintains a set of default options like general ledger accounts; locator, lot, and serial controls, inter-organization options, costing method, etc. for each organization defined in Oracle Inventory.
2	MTL_SYSTEM_ITEMS_B	This table holds the definitions for inventory items, engineering items, and purchasing items. The primary key for an item is the INVENTORY_ITEM_ID and ORGANIZATION_ID.
3	MTL_ITEM_STATUS	This is the definition table for material status codes. Status code is a required item attribute. It indicates the status of an item, i.e., Active, Pending, Obsolete.
4	MTL_UNITS_OF_MEASURE_TL	This is the definition table for both the 25-character and the 3-character units of measure. The base_uom_flag indicates if the unit of measure is the primary unit of measure for the uom_class. Oracle Inventory uses this table to keep track of the units of measure used to transact an item.
5	MTL_ITEM_LOCATIONS	This is the definition table for stock locators. The associated attributes describe which subinventory this locator belongs to, what the locator physical capacity is, etc.
6	MTL_ITEM_CATEGORIES	This table stores inventory item assignments to categories within a category set
7	MTL_CATEGORIES_B	This is the code combinations table for item categories.
8	MTL_CATEGORY_SETS_B	It contains the entity definition for category sets.
9	MTL_DEMAND	This table stores demand and reservation information used in Available To Promise, Planning and other Manufacturing functions. There are three major row types stored in the table: Summary Demand rows,Open Demand Rows, and Reservation Rows.
10	MTL_SECONDARY_INVENTORIES	This is the definition table for the subinventory.
11	MTL_ONHAND_QUANTITIES	It stores quantity on hand information by control level and location.
12	MTL_TRANSACTION_TYPES	It contains seeded transaction types and the user defined ones.
13	MTL_MATERIAL_TRANSACTIONS	This table stores a record of every material transaction or cost update performed in Inventory.
14	MTL_ITEM_ATTRIBUTES	This table stores information on item attributes.
15	MTL_ITEM_CATALOG_GROUPS_B	This is the code combinations table for item catalog groups.
16	MTL_ITEM_REVISIONS_B	It stores revision levels for an inventory item.
17	MTL_ITEM_TEMPLATES_B	This is the definition table for item templates. It
18	MTL_DESCRIPTIVE_ELEMENTS	It stores the descriptive element definitions for an item catalog group. Descriptive elements are defining properties used to describe in the catalog group.
19	MTL_DESCR_ELEMENT_VALUES	It stores the descriptive element values for a specific item. When an item is associated with a particular item catalog group, one row per descriptive element (for that catalog group) is inserted into this table.
20	ORG_ACCT_PERIODS	It holds the open and closed financial periods for organizations.
21	MTL_CUSTOMER_ITEMS	It stores customer item information for a specific customer. Each record can be defined at one of the following levels: Customer, Address Category, and Address. The customer item definition is organization independent.
22	MTL_SYSTEM_ITEMS_INTERFACE	It temporarily stores the definitions for inventory items, engineering items and purchasing items before loading this information into Oracle Inventory.
23	MTL_TRANSACTIONS_INTERFACE	It allows calling applications to post material transactions (movements, issues, receipts etc. to Oracle Inventory  transaction module.
24	MTL_ITEM_REVISIONS_INTERFACE	It temporarily stores revision levels for an inventory item before loading this information into Oracle Inventory.
25	MTL_ITEM_CATEGORIES_INTERFACE	This table temporarily stores data about inventory item assignments to category sets and categories before loading this information into Oracle Inventory.
26	MTL_DESC_ELEM_VAL_INTERFACE	This table temporarily stores descriptive element values for an item that is associated with an item catalog group before loading this information into Oracle Inventory.
27	MTL_DEMAND_INTERFACE	It is the interface point between non-Inventory applications and the Inventory demand module. Records inserted into this table are processed by the Demand Manager concurrent program.
28	MTL_INTERFACE_ERRORS	It stores errors that occur during the item interface process reporting where the errors occurred along with the error messages.

Oracle R12 Order Management Tables

Sr. No	Category	Table Name	Description/ Uses
1	OM Tables	OE_ORDER_HEADERS_ALL	Stores Header Information for Orders in Order Management
2		OE_ORDER_LINES_ALL	Stores Information for all Order Lines in Oracle Order Management
3		OE_ORDER_SOURCES	Feeder System Names that create orders in Order Management Tables
4		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
5		OE_SALES_CREDITS	This Table stores information about sales credits
6		OE_TRANSACTION_TYPES_ALL	This table stores information about the order and line transaction types
7		WSH_DELIVERY_ASSIGNMENTS	Delivery Assignments
8		WSH_DELIVERY_DETAILS	Delivery Details
9		WSH_NEW_DELIVERIES	Deliveries
10		WSH_TRIPS	Trips
11		WSH_TRIP_STOPS	Trip Stops

Oracle R12 Fixed Assets Tables

Sr. No	Category	Table Name	Description/ Uses
1	Fixed Asset Tables	FA_ADDITIONS_B	Descriptive Information about assets
2		FA_ADJUSTMENTS	Information used by the posting program to generate journal entry lines in the general ledger
3		FA_ASSET_HISTORY	Historical Information about asset reclassification and unit adjustments
4		FA_ASSET_INVOICES	Accounts Payable and Purchasing Information for each assets
5		FA_BOOKS	Financial Information of each assets
6		FA_BOOK_CONTROLS	Control information that affects all asset in depreciation book
7		FA_CALENDER_PERIODS	Detailed Calender Information
8		FA_CALENDER_TYPES	General Calender Information
9		FA_CATEGORIES_B	Default Financial Information for Asset Categories
10		FA_CATEGORY_BOOKS	Default Financial Information for Asset Categories and depreciation book components
11		FA_DEPRN_DETAIL	Depreciation amounts charged to the depreciation expense account in each distribution line
12		FA_DEPRN_PERIODS	Information about each depreciation period
13		FA_DEPRN_EVENTS	Information about depreciating account events
14		FA_DEPRN_SUMMARY	Depreciation information at the asset levels
15		FA_DISTRIBUTION_ACCOUNTS	Table to store account codes for all distribution for a book
16		FA_DISTRIBUTION_DEFAULTS	Distribution Set Information
17		FA_DISTRIBUTION_HISTORY	Employee, Location, and Accounting Flexfield values assigned to each asset
18		FA_DISTRIBUTION_SETS	Header Information for distributions sets
19		FA_FORMULAS	Depreciation Rate for formula- based methods
20		FA_LOCATIONS	Location flexifield segment value combination
21		FA_MASS_ADDITIONS	Information about assets that we want to automatically add to Oracle Assets from another system
22		FA_METHODS	Depreciation Method Information
23		FA_RETIREMENTS	Information about asset retirements and reinstatements

Oracle R12 GL Tables

Sr. No	Category	Table Name	Description/ Uses
1	Cash Management Tables	CE_BANK_ACCOUNTS	This table contains bank account information. Each bank account must be affiliated with one bank branch
2		CE_BANK_ACCNT_BALANCES	This table stores the internal bank account balances
3		CE_BANK_ACCT_USES_ALL	This table stores information about bank account uses
4		CE_STATEMENT_HEADERS	Bank Statements
5		CE_STATEMENT_LINES	Bank Statements Lines
6		CE_STATEMENT_HEADERS_INT	Open Interface for Bank Statements
7		CE_STATEMENT_LINES_INTERFACE	Open Interface for Bank Statements Lines
8		CE_TRANSACTION_CODES	Bank Transaction Codes

Oracle R12 GL Tables

Sr. No	Category	Table Name	Description/ Uses
1	General Ledger	GL_CODE_COMBINATION	Stores Valid account combinations
2		GL_SETS_OF_BOOKS	Stores Information about the sets of books
3		GL_IMPORT_REFERENCES	Stores Individual transactions from subledgers
4		GL_DAILY_RATES	Stores the daily conversion rates for foreign currency
5	Transactions	GL_PERIODS	Stores Information about the Accounting Periods
6		GL_JE_HEADERS	Stores Journal Entries
7		GL_JE_LINES	Stores Journal Entries lines that we enter in the Enter Journals Form
8		GL_JE_BATCHES	Stores Journal Entry Batches
9		GL_BALANCES	Stores Actual, Budget and encumbrance balances for details and summary accounts
10		GL_BUDGETS	Stores Budget defintions
11		GL_INTERFACE	Import journal entry batches
12		GL_BUDGET_INTERFACE	Upload budget data from external sources
13		GL_DAILY_RATES_INTERFACE	Import daily conversion rates