Results for “op_ordr_typ_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OP_ORDR_TYP_B is a foundational setup table within the Oracle E-Business Suite Process Manufacturing Logistics (GML) module. It stores user-defined order type definitions and their associated descriptions, providing the classification framework that governs how process manufacturing orders are created, processed, and posted throughout the logistics and order management lifecycle. Every operational order header in process manufacturing ultimately references a row in this table, making it a master reference object rather than a transactional one.

Under a heuristic Data Vault classification, OP_ORDR_TYP_B is hub-leaning. It carries a durable business key (ORDER_TYPE_CODE) and serves as the anchor against which dependent order transactions are linked, with the header table OP_ORDR_HDR acting as the primary dependent link. This positions the table as a natural hub candidate in a dimensional or vault-style model, though in the EBS 12.1.1 / 12.2.2 ETRM schema it functions as a standard seeded and user-extensible setup table.

Key Information Stored

The table is owned by the GML schema and contains 26 documented columns. The most significant columns for reporting and integration purposes are:

• ORDER_TYPE — The surrogate primary key (OP_ORDR_TYP_B_PK) and the internal identifier referenced by order headers.
• ORDER_TYPE_CODE — The business-key candidate, protected by the unique index OP_ORDR_TYP_B_U1. This is the user-facing code displayed and selected throughout the application.
• LANG_CODE — Language code enabling multilingual descriptions of the order type.
• INVEN_TRANS_TYPE — The inventory transaction type associated with the order type, driving material movement behavior.
• SHIPMENT_IND, INVOICE_IND, PICKINGLST_IND, EXPORTDOC_IND — Indicator flags controlling whether shipment, invoicing, picking list, and export documentation processes are enabled for the order type.
• CREDITCHK_TYPE — Determines the credit check behavior applied during order processing.
• CALC_COMM_IND, CALC_TAX_IND — Flags governing commission and tax calculation.
• PRODORDR_IND — Indicates whether a production order is generated.
• ORDER_LEADTIME — Default lead time applied to orders of this type.
• TEXT_CODE — Reference to supplementary text or instructions attached to the order type.
• DELETE_MARK — The soft-delete flag used consistently across GML tables to logically retire records without physical deletion.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns.

The surrogate key (ORDER_TYPE) is distinct from the business-key candidate (ORDER_TYPE_CODE), a separation that supports stable internal referencing even if the business code is re-described.

Common Use Cases and Queries

Typical reporting and validation scenarios include retrieving the description for a given order type, identifying which order types enable shipment or invoicing, and reconciling order headers against their type definitions.

• Lookup by business key:
  SELECT order_type, order_type_code, shipment_ind, invoice_ind FROM gml.op_ordr_typ_b WHERE order_type_code = :code AND delete_mark = 0;
• Enumerating active order types for a value set or LOV population, filtering on DELETE_MARK = 0.
• Joining headers to type definitions to report volumes and processing behavior by order type:
  SELECT h.order_type, t.order_type_code, COUNT(*) FROM gml.op_ordr_hdr h, gml.op_ordr_typ_b t WHERE h.order_type = t.order_type GROUP BY h.order_type, t.order_type_code;
• Auditing configuration changes by examining LAST_UPDATED_BY and LAST_UPDATE_DATE across order types.

Related Objects

The principal dependent object is OP_ORDR_HDR, whose ORDER_TYPE column is a foreign key referencing this table. This relationship defines the header-to-type association central to order management reporting. Beyond the documented FK, the flags in this table (SHIPMENT_IND, INVOICE_IND, PICKINGLST_IND, EXPORTDOC_IND) influence downstream processing in shipping, receivables, and picking modules, while INVEN_TRANS_TYPE ties indirectly to inventory transaction validation. Because ORDER_TYPE feeds OP_ORDR_HDR, any query that returns order header detail—order status reports, production reporting, and shipment reconciliation—depends transitively on OP_ORDR_TYP_B for classification and descriptive context.