Results for “inst_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OE_LINE_SETS table is owned by the ONT (Order Management) schema and is a valid table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores information about Sets, specifically the association between individual order lines and the sets to which those lines belong. Within the Oracle Order Management data model, this table functions as an intersection or cross-reference entity, resolving a many-to-many relationship between order lines and sets at the line level.
Based on the foreign key structure detected in the ETRM metadata, the heuristic Data Vault classification for this object is a link. This modeling suggestion reflects that OE_LINE_SETS primarily captures relationships between other business entities rather than serving as a standalone hub of descriptive attributes. It links a line record to a set record, enabling grouping or bundling semantics within order processing.
Key Information Stored
The documented physical schema for ONT.OE_LINE_SETS contains four columns. The most significant are:
- LINE_ID — The identifier of the order line. This column participates in a foreign key relationship to
OE_ORDER_LINES_ALL, meaning it references the full order line record. It is a business-key candidate for the line side of the relationship. - SET_ID — The identifier of the set. This column participates in a foreign key relationship to
OE_SETS, referencing the parent set record. It is a business-key candidate for the set side of the relationship. - SYSTEM_REQUIRED_FLAG — A flag indicating whether the set assignment is system-required, controlling behavior during order entry and processing.
- INST_ID — The installation identifier, used to distinguish records across multiple Oracle EBS installations or operating units in a shared environment.
No surrogate primary key column is separately documented beyond these four columns, and the metadata does not identify a distinct unique index. In practice, the combination of LINE_ID and SET_ID typically forms the natural composite key for a given record.
Common Use Cases and Queries
This table is commonly queried when reporting on order line set membership, validating set assignments, or integrating order data with downstream fulfillment and pricing processes. Typical use cases include identifying all lines belonging to a specific set, or determining which sets a particular order line is associated with.
- Retrieving all lines for a given set:
SELECT LINE_ID, SET_ID, SYSTEM_REQUIRED_FLAG FROM OE_LINE_SETS WHERE SET_ID = :set_id;
- Joining to order lines to enrich reporting:
SELECT l.LINE_ID, l.ORDERED_ITEM, s.SET_ID FROM OE_LINE_SETS s, OE_ORDER_LINES_ALL l WHERE s.LINE_ID = l.LINE_ID;
- Checking system-required set assignments: filter on
SYSTEM_REQUIRED_FLAGto isolate lines whose set membership is mandated by the system.
Related Objects
The following objects are the most significant references based on the documented foreign key relationships:
- OE_ORDER_LINES_ALL — Referenced through
OE_LINE_SETS.LINE_ID. This is the primary order line table holding line-level order details. - OE_SETS — Referenced through
OE_LINE_SETS.SET_ID. This table holds the set definitions to which lines are assigned.
Additional dependent or surrounding objects within the Order Management module include order headers (OE_ORDER_HEADERS_ALL), which provide the parent order context for lines in OE_ORDER_LINES_ALL, and the Order Management public APIs and concurrent programs that read and write set associations during order import and processing. Reporting solutions often join OE_LINE_SETS with OE_ORDER_LINES_ALL and OE_SETS to present complete set membership information across the order lifecycle.
-
This table stores information about Sets.
-
Table: FND_OAM_METVAL_INST 12.2.2
OAM Dashboard Metric Value Group by Instance
-
Workflow runtime table
-
Table: MSC_ANALYSIS_QUERY 12.2.2
-
Contains values for item attributes
-
Table: OE_SETS_HISTORY 12.2.2
Stores history of Set information
-
Table: FND_OAM_METVAL_INST 12.1.1
OAM Dashboard Metric Value Group by Instance
-
This table stores relationship between order lines in oe_order_lines_all table and associated oracle purchasing requisitions in PO_REQUISITIONS_ALL and Oracle purchasing purchase orders in PO_LINES_ALL.
-
View: FND_FORM_SESSIONS_V 12.2.2
APPS.FND_FORM_SESSIONS_V·↳ FND_FORM_TL·↳ FND_LOGINS·↳ FND_LOGIN_RESPONSIBILITIES·Explore FND module →
-
This table stores the processing messages which will be generated during Order Entry concurrent program execution or UI process. This is a multi-lingual table.
-
This table stores information on qualifiers and pricing attributes, which to that corresponding price adjustment line qualified for.
-
This is a multi-org table for sales order actions holds, booking etc. open interface.
-
This is a multi-org table for sales order/line credits open interface.
-
This table stores the association between order lines and price adjustments and also between price adjustments
-
View: FND_FORM_SESSIONS_V 12.1.1
APPS.FND_FORM_SESSIONS_V·↳ FND_FORM_TL·↳ FND_LOGINS·↳ FND_LOGIN_RESPONSIBILITIES·Explore FND module →
-
Table: MSC_ANALYSIS_QUERY 12.1.1
-
Stores history of attribute changes of Entity Sales Credits
-
Runtime table for a work item
-
This table is used to store Payments data to be imported into OE_PAYMENTS table. This table will be used by Order Import Program.
-
Stores history of WF_ITEM_ACTIVITY_STATUSES
-
OE_SETS stores information on line sets.
-
Table to capture sales agreement header details, specific to sales agreement functionality
-
Table to capture sales agreement line details specific to sales agreement functionality.
-
This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.
-
This table stores customer reported lot serial numbers for lot and / or serial number controlled return lines.
-
This table stores information about sales credits.
-
This table stores the context information of the processing messages that will be generated during Order Entry concurrent program execution or UI process.
-
Stores history of attribute changes of Entity Price
-
This is a multi-org open interface table for sales order/line price adjustments.
-
This is a multi-org table for inventory reservations open interface.
-
This is a multi-org table for return line lot serials open interface.
-
This table stores information about the acknowledgements for lot and serial numbers for return lines.
-
It holds the commitment payment information.
-
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
-
This table is used to store price adjustments that have been applied to an order or a line. It is also used to store the freight and special charges, Tax on order line, and Shipping Costs captured at ship confirmation. For Tax records the
-
Interface table to add new customer, its address and contact info.
-
This tables stores information about the acknowledgements for Order Headers.
-
This is a multi-org table for sales order lines open interface.
-
Table to capture sales agreement header history. Primary for storing revisions.
-
This table stores pricing attributes and asked for promotions, deals, and coupon number entered by the user.
-
Table to capture sales agreement header details..
-
This is a multi-org Interface table to populate OE_ORDER_PRICE_ATTRIBS.
-
Stores history of attribute change for Order Headers
-
Table to capture sales agreement lines history.
-
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
-
This is a multi-org table for sales order headers open interface.
-
Table to capture sales agreement Line details.(Attributes common between Sales Order and Sales Agreements).
-
Stores history of attribute change for Order Lines.
-
This table stores information about the acknowledgements for Order Lines.