ONT — Order Management
158 documented tables · 296 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
OE_ORDER_LINES_ALL |
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management. | hub-leaning |
OE_AK_OBJECTS_EXT |
Extension tables to AK_OBJECTS which is used to store additional data | hub |
OE_ORDER_HEADERS_ALL |
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management. | hub |
OE_ORDER_SOURCES |
Feeder System Names that create orders in Order Management tables. | hub |
OE_TRANSACTION_TYPES_ALL |
This table stores information about the order and line transaction types | satellite-leaning |
OE_PC_RSETS |
This table store the constraint record sets and the constraint conditions can be built to validate against any | hub-leaning |
OE_PC_VTMPLTS |
This table stores the constraint validation templates that are used in constraint conditions. | hub-leaning |
OE_PC_CONSTRAINTS |
This table stores the constraints that prevent create/update/delete of order entities. | hub-leaning |
OE_SETS |
OE_SETS stores information on line sets. | hub-leaning |
OE_PRICE_ADJUSTMENTS |
This table is used to store price adjustments that have been applied to an order or a line. It is also used to | satellite-leaning |
OE_HOLD_SOURCES_ALL |
This table stores information of the hold source criteria. | satellite-leaning |
OE_PC_CONDITIONS |
This table stores the conditions associated with the constraints identified by constraint_id. | satellite-leaning |
OE_DEF_ATTR_CONDNS |
Associates the defaulting condtion, defined at the entity level , to a specific attribute. | hub-leaning |
OE_PC_ASSIGNMENTS |
This table stores the responsibilities that are constrained by the constraint identified by constraint_id. | satellite-leaning |
OE_HOLD_DEFINITIONS |
This table stores information about hold name and its validity period. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.