OracleFree referencePDF, Excel, Word exportOracle E-Business Suite

Oracle EBS Cost Management Tables List

Oracle EBS spreads costing data across Inventory, Cost Management, WIP, BOM and Purchasing. This list collects the main tables so a developer or cost accountant can find where a number lives.

Download:

Table	Description	Module	Typical use
MTL_SYSTEM_ITEMS_B	Item master by organization	Inventory	Item attributes such as costing enabled and inventory asset flag.
MTL_PARAMETERS	Inventory organization parameters	Inventory	Primary cost method and cost organization.
MTL_MATERIAL_TRANSACTIONS	Material transactions	Inventory	Issues, receipts and completions with quantities.
MTL_TRANSACTION_ACCOUNTS	Accounting for material transactions	Inventory	Debit and credit accounts per transaction.
MTL_ONHAND_QUANTITIES_DETAIL	On-hand quantities	Inventory	Current stock by subinventory and locator.
CST_COST_TYPES	Cost types	Cost Management	Frozen, Pending and user-defined cost types.
CST_ITEM_COSTS	Item costs by organization and cost type	Cost Management	Rolled-up cost per item.
CST_ITEM_COST_DETAILS	Item cost detail by cost element	Cost Management	Material, resource, overhead breakdown.
CST_COST_GROUPS	Cost groups	Cost Management	Grouping for average costing.
CST_COST_UPDATES	Cost update history	Cost Management	Header for each standard cost update.
CST_QUANTITY_LAYERS	Quantity layers	Cost Management	Layered inventory quantities by cost group.
CST_LAYER_COST_DETAILS	Layer cost details	Cost Management	Cost by element within a layer.
CST_RESOURCE_COSTS	Resource costs by cost type	Cost Management	Rates used in costing.
CST_DEPARTMENT_OVERHEADS	Department overhead assignments	Cost Management	Overhead applied to departments.
CST_PAC_PERIODS	Periodic average costing periods	Cost Management	Period set up for PAC.
WIP_ENTITIES	WIP entities	WIP	Job and schedule identifiers.
WIP_DISCRETE_JOBS	Discrete jobs	WIP	Job status, start quantity, completion quantity.
WIP_OPERATIONS	Job operations	WIP	Operation sequence for the job.
WIP_OPERATION_RESOURCES	Operation resources	WIP	Resource usage rates and charge type.
WIP_REQUIREMENT_OPERATIONS	Material requirements for jobs	WIP	Required and issued component quantities.
WIP_PERIOD_BALANCES	WIP period balances	WIP	Cost incurred, relieved and variances per period.
WIP_TRANSACTION_ACCOUNTS	Accounting for WIP transactions	WIP	Debit and credit entries by job.
BOM_BILL_OF_MATERIALS	Bill header	Bills of Material	Assembly and alternate designator.
BOM_COMPONENTS_B	Bill components	Bills of Material	Component, quantity, effectivity dates.
BOM_OPERATIONAL_ROUTINGS	Routing header	Bills of Material	Routing for an assembly.
BOM_OPERATION_SEQUENCES	Routing operations	Bills of Material	Operation sequence and department.
BOM_OPERATION_RESOURCES	Operation resources	Bills of Material	Resource usage per operation.
BOM_RESOURCES	Resource definitions	Bills of Material	Labor and machine resources.
BOM_DEPARTMENTS	Departments	Bills of Material	Where overhead and resources are grouped.
RCV_TRANSACTIONS	Receiving transactions	Purchasing	Receipts, returns and corrections.
PO_LINES_ALL	Purchase order lines	Purchasing	Price and quantity for purchase price variance work.
GL_CODE_COMBINATIONS	Accounting flexfield combinations	General Ledger	Decode accounts used in costing entries.

Table availability, suffixes (_B, _ALL) and multi-org views differ by EBS release. Check your data dictionary and prefer supported views and APIs for custom reports.

Read-only reporting over Oracle EBS

An optional discussion of governed, on-prem question answering over your EBS costing data.

Optional. The tool and every export work without this. No spam.

How to use the list

Search a table name or a concept such as job, resource or layer. The module column groups rows so you can look at all WIP tables together. The typical-use column states what the table is queried for. Export to Excel and attach it to a reporting design document.

Search for a table or concept
Filter by module to see the costing flow
Export for developers writing reports

How costing data flows

Item costs are held in CST_ITEM_COSTS and broken out by element in CST_ITEM_COST_DETAILS for each cost type. Inventory transactions in MTL_MATERIAL_TRANSACTIONS are valued with those costs, and their accounting lands in MTL_TRANSACTION_ACCOUNTS. Discrete jobs live in WIP_DISCRETE_JOBS with requirements and operations, charged material and resources accumulate, and period balances in WIP_PERIOD_BALANCES show cost relieved and variances at close.

Reading across modules

To trace a job variance, start at WIP_DISCRETE_JOBS for the job, check WIP_REQUIREMENT_OPERATIONS for material issued against required, and WIP_OPERATION_RESOURCES for resources charged. Then compare the item cost from CST_ITEM_COSTS to see whether the standard was current. The same pattern applies to purchase price variance, which starts at PO_LINES_ALL and RCV_TRANSACTIONS.

Common mistakes

Querying base tables without the organization filter returns mixed data from several inventory organizations. Another mistake is using a cost type other than the one your organization costs against. Finally, do not write to these tables directly. Use the open interfaces and supported APIs, which carry the validation Oracle expects.

Frequently Asked Questions

Which table stores item cost in Oracle EBS?

CST_ITEM_COSTS stores the rolled-up item cost by inventory organization and cost type, and CST_ITEM_COST_DETAILS holds the breakdown by cost element and level. Filter by organization and cost type to avoid mixing values.

Where do I find discrete job status?

WIP_DISCRETE_JOBS holds the job status along with start quantity, completed quantity and scrapped quantity. Join to WIP_ENTITIES for the job name and organization.

Can I update these tables directly?

No. Direct updates bypass validation and can corrupt costing and accounting. Use the supported open interfaces, APIs and standard forms. Use this list for read-only investigation and reporting.

Do the tables differ between 12.1 and 12.2?

Core costing tables are broadly stable, but 12.2 introduced editioning, so base tables and editioning views differ. Confirm names in your own data dictionary before building reports.

Netray can help build read-only reporting over Oracle EBS data on your own infrastructure, with the query shown for review.

Talk to an Expert Explore More Free Tools

Related Tools

SAP

More Oracle tools

See all

Back to All Tools