Search Results oe_items_v




The DeepseekETRM - ONT (Order Management) Tables and Views in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 provide a structured framework for managing order processing, fulfillment, and related transactional data. These tables and views are critical for capturing, processing, and reporting on sales orders, returns, and shipping information. Below is a detailed breakdown of key tables and views in the ONT module.

Core Tables in Oracle Order Management (ONT)

  1. OE_ORDER_HEADERS_ALL: Stores header-level information for sales orders, including order number, customer details, order type, and status. This table acts as the parent record for all order-related data.
  2. OE_ORDER_LINES_ALL: Contains line-level details for each order, such as item information, quantity, pricing, and shipping attributes. This table links to the header via HEADER_ID.
  3. OE_TRANSACTION_TYPES_TL: Defines order transaction types (e.g., standard sales orders, returns) with descriptions in multiple languages.
  4. OE_HOLD_SOURCES_ALL: Manages order holds, including reasons and resolution details.
  5. OE_PRICE_ADJUSTMENTS: Captures discounts, surcharges, and other pricing adjustments applied to order lines.
  6. OE_SALES_CREDITS: Tracks sales credits assigned to sales representatives for commission calculations.
  7. WSH_DELIVERY_DETAILS: Integrates with Oracle Shipping (WSH) to track shipment details linked to order lines.
  8. DOO_HEADERS_ALL & DOO_LINES_ALL: Used in Oracle Order Orchestration (for EBS 12.2+) to manage fulfillment workflows.

Key Views in Oracle Order Management

  1. OE_ORDER_HEADERS_V: A view combining OE_ORDER_HEADERS_ALL with transactional and descriptive data for reporting.
  2. OE_ORDER_LINES_V: Aggregates line-level data with pricing, inventory, and shipping details for enhanced querying.
  3. OE_HOLDS_V: Provides a consolidated view of active holds on orders.
  4. OE_PRICE_ADJUSTMENTS_V: Displays pricing adjustments with contextual metadata.
  5. WSH_DELIVERY_DETAILS_V: Combines shipping data with order information for logistics tracking.

Integration Points

The ONT module integrates with other EBS modules:
  • Inventory (INV): Validates item availability via MTL_SYSTEM_ITEMS_B.
  • Receivables (AR): Invoices are generated in RA_CUSTOMER_TRX_ALL.
  • Shipping (WSH): Shipment data flows to WSH_NEW_DELIVERIES.
  • Advanced Pricing (QP): Pricing rules are referenced from QP_LISTS and QP_PRICE_FORMULAS.

Technical Considerations

  • Multi-Org Structure: Tables use _ALL suffixes with ORG_ID for multi-org access control.
  • Audit Columns: Standard columns like CREATION_DATE, LAST_UPDATE_DATE track changes.
  • Indexing: Key indexes include OE_ORDER_HEADERS_N1 (order number) and OE_ORDER_LINES_N1 (header-line linkage).

Conclusion

The DeepseekETRM - ONT Tables and Views form the backbone of Oracle Order Management, enabling end-to-end order lifecycle management. Understanding these structures is essential for customizations, integrations, and performance tuning in Oracle EBS 12.1.1 or 12.2.2 implementations.