Search Results oe_order_headers_all
The OE_ORDER_HEADERS_ALL table is a fundamental entity within Oracle E-Business Suite (EBS) Release 12.1.1 or 12.2.2, specifically in the Order Management (OM) module. It serves as the primary repository for storing header-level information for sales orders, quotations, and returns. This table is part of the Oracle Trading Community Architecture (TCA) and integrates with other key modules such as Inventory, Receivables, and Shipping Execution. Below is a detailed technical and functional analysis of this critical table.
Table Structure and Key Columns
The OE_ORDER_HEADERS_ALL table contains metadata and transactional data for order headers. Key columns include:
- HEADER_ID: Primary key, uniquely identifying each order header.
- ORDER_NUMBER: User-friendly identifier for the order.
- ORDER_TYPE_ID: References OE_TRANSACTION_TYPES to classify orders (e.g., Standard, Return).
- ORDERED_DATE: Timestamp of order creation.
- ORG_ID: Multi-org identifier, linking to HR_OPERATING_UNITS.
- SOLD_TO_ORG_ID, SHIP_TO_ORG_ID, BILL_TO_ORG_ID: TCA party/site references.
- PRICE_LIST_ID: Links to QP_PRICE_LISTS for pricing.
- FLOW_STATUS_CODE: Tracks order lifecycle (e.g., ENTERED, BOOKED, CANCELLED).
- CANCELLED_FLAG, OPEN_FLAG: Boolean indicators for order status.
Functional Role in Order Management
The table acts as the anchor for order processing:
- Order Creation: Header data is inserted during order entry, with defaults from profile options and transaction types.
- Pricing: The PRICE_LIST_ID triggers price calculations via Oracle Pricing.
- Workflow Integration: Status changes (FLOW_STATUS_CODE) invoke OM workflows for approvals or exceptions.
- Multi-Org Support: The ORG_ID enables data partitioning per operating unit.
Integration Points
OE_ORDER_HEADERS_ALL integrates with:
- OE_ORDER_LINES_ALL: Child table storing line details (1:N relationship via HEADER_ID).
- WSH_DELIVERY_DETAILS: Shipping Execution links deliveries to orders.
- RA_CUSTOMER_TRX: Order-to-cash flow in Receivables.
- INV_MATERIAL_TRANSACTIONS: Inventory updates post-order fulfillment.
Technical Considerations
Key technical aspects include:
- Indexing: Indexes on HEADER_ID, ORDER_NUMBER, and ORG_ID optimize queries.
- Partitioning: Large implementations may partition by ORG_ID or date ranges.
- Concurrent Programs: Standard OM reports (e.g., Order Summary) query this table.
- APIs: OE_ORDER_PUB and OE_HEADER_UTIL enforce business logic during CRUD operations.
Customization and Extensions
Common extensions include:
- Descriptive Flexfields (DFFs): Custom attributes stored in OE_ORDER_HEADERS_ALL.
- Triggers/Validations: Enhancements to enforce industry-specific rules.
- Views: Custom joins with TCA tables for reporting.
Conclusion
The OE_ORDER_HEADERS_ALL table is a cornerstone of Oracle Order Management, encapsulating critical order metadata and enabling end-to-end order processing. Its design supports scalability, integration, and customization, making it indispensable in Oracle EBS 12.1.1 and 12.2.2 implementations. Understanding its structure and relationships is essential for functional configurations, technical extensions, and performance tuning.
-
Table: OE_ORDER_HEADERS_ALL
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_HEADERS_ALL, object_name:OE_ORDER_HEADERS_ALL, status:VALID, product: ONT - Order Management , description: OE_ORDER_HEADERS_ALL stores header information for orders in Order Management. , implementation_dba_data: ONT.OE_ORDER_HEADERS_ALL ,
-
Table: OE_ORDER_HEADERS_ALL
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_HEADERS_ALL, object_name:OE_ORDER_HEADERS_ALL, status:VALID, product: ONT - Order Management , description: OE_ORDER_HEADERS_ALL stores header information for orders in Order Management. , implementation_dba_data: ONT.OE_ORDER_HEADERS_ALL ,
-
APPS.JA_JAINVATR_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_FTE_INTEGRATION_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.GMF_GMFLCHST_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_HEADER_SCREDIT_SECURITY dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OZF_FUND_UTILIZED_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.INV_MGD_MVT_UTILS_PKG dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_CONTRACTS_UTIL dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_DEFAULT_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.INV_DIAG_RCV_RMA dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_DROP_SHIP_GRP dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.CSD_ESTIMATE_UTILS_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.INV_MGD_MVT_PO_MDTR dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_ORDER_PRICE_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_TRANSACTION_TYPES_PKG dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_BULK_LINE_UTIL dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.RCV_INSPECTION_GRP dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.ASO_BI_LINE_FACT_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.GMD_COA_DATA_OM dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.MSD_SR_UTIL dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.CSD_MIGRATE_FROM_115X_PKG dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_CUST_MERGE dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.INV_MGD_MVT_DATA_STR dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.CSTPAVCP dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_APPROVALS_WF dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OKC_REP_UTIL_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OKS_OC_INT_KTO_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.ISC_EDW_BACKLOGS_F_C dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.MTL_QP_PRICE dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.INV_RCV_TXN_MATCH dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_LINE_FULLFILL dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.CSI_INV_ISO_PKG dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.POR_RCV_TRANSACTION_SV dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OKS_OCINT_PUB dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.MRP_CREATE_SCHEDULE_ISO dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.CSI_RMA_FULFILL_PUB dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_UPG_SO dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.CST_REVENUECOGSMATCH_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.CS_CHARGE_CORE_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.WSH_PR_PICK_SLIP_NUMBER dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.OPI_DBI_COGS_PKG dependencies on OE_ORDER_HEADERS_ALL
12.1.1
-
APPS.INV_MGD_MVT_STATS_PROC dependencies on OE_ORDER_HEADERS_ALL
12.1.1