BOM — Bills of Material
316 documented tables · 480 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
BOM_RESOURCES |
Resources, overheads, material cost codes, and material overheads | hub |
CST_COST_GROUPS |
Stores cost group definitions | hub |
BOM_CALENDARS |
Workday calendars | hub-leaning |
BOM_EXCEPTION_SETS |
Exception sets | hub |
CST_COST_ELEMENTS |
Cost elements definition | hub |
BOM_STRUCTURES_B |
Bills of material | hub |
CST_ACTIVITIES |
Activity definition associated with activity costing | hub |
BOM_DEPARTMENTS |
Departments | hub |
BOM_COMPONENTS_B |
Bill of material components | hub-leaning |
CST_COST_TYPES |
Stores cost type definitions | hub |
BOM_OPERATIONAL_ROUTINGS |
Routings | hub |
BOM_ALTERNATE_DESIGNATORS |
Alternate designators | hub |
BOM_OPERATION_SEQUENCES |
Routing operations | hub |
BOM_BILL_OF_MATERIALS |
Bills of material | hub-leaning |
CST_PAC_PERIODS |
Holds information about periodic costing open and closed periods for each legal entity. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
BOM_BO_PUB |
PUB | 12 | 72 packages |
BOM_RTG_PUB |
PUB | 9 | 51 packages |
BOM_EXPLODER_PUB |
PUB | 28 | 8 packages |
BOM_RTG_NETWORK_API |
API | 7 | 4 packages |
BOM_SECURITY_PUB |
PUB | 4 | 4 packages |
BOM_IMPORT_PUB |
PUB | 32 | 4 packages |
BOM_ROLLUP_PUB |
PUB | 20 | 3 packages |
BOM_OPEN_INTERFACE_API |
API | 2 | 2 packages |
BOM_IMPLODER_PUB |
PUB | 8 | 2 packages |
BOM_DELETE_GROUPS_API |
API | 2 | 1 packages |