Results for “create_customers_flag”

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

Overview

ONT.OE_ORDER_SOURCES is a foundational reference table in Oracle Order Management (ONT) that stores the names of feeder systems responsible for creating orders in the Order Management application tables. Operating within the ONT schema in Oracle E-Business Suite 12.1.1 and 12.2.2, this table defines the origin or channel through which each order, return, or interface record enters the system, whether from manual order entry, an external e-commerce storefront, a legacy system via open interfaces, or another integrated application.

The table is a small, control-oriented object—documented with only 13 columns—yet it serves as a critical classification point for order data. Because numerous transactional and interface tables store an ORDER_SOURCE_ID, this table provides the shared vocabulary that distinguishes orders by origin. In Data Vault modeling terms, the relationship structure mined from the foreign key graph suggests classifying OE_ORDER_SOURCES as a hub: it holds a stable, uniquely identified set of business concepts (order sources) referenced by many satellite-style detail tables surrounding it. This classification is a modeling suggestion derived from the FK topology rather than a declared property of the Oracle schema.

Key Information Stored

The most significant columns documented in the ETRM schema are as follows:

• ORDER_SOURCE_ID — The surrogate primary key (OE_ORDER_SOURCES_PK) and the column referenced by every dependent foreign key. Uniquely identifies each feeder system.
• NAME — The business name of the order source, such as "Manual" or an external system identifier. This is a business-key candidate, enforced by the unique index OE_ORDER_SOURCES_U2.
• DESCRIPTION — Free-text explanation of the source's purpose or the system it represents.
• ENABLED_FLAG — Indicates whether the source is active and selectable in Order Management.
• CREATE_CUSTOMERS_FLAG — Controls whether customers may be created automatically when orders arrive from this source.
• USE_IDS_FLAG — Governs whether externally supplied identifiers are honored for records from this source.
• AIA_ENABLED_FLAG — Flags integration with the Application Integration Architecture (AIA) framework.
• ZD_EDITION_NAME — The editioning column introduced for Online Patching in Release 12.2, enabling edition-based redefinition.

Standard audit columns—CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN—complete the 13-column structure. The two unique indexes, OE_ORDER_SOURCES_U1 (ORDER_SOURCE_ID, ZD_EDITION_NAME) and OE_ORDER_SOURCES_U2 (NAME, ZD_EDITION_NAME), confirm both the surrogate identifier and NAME as business-key candidates within an edition.

Common Use Cases and Queries

Order sources are used to segment order volumes by origin, validate interface records before import, and drive conditional processing logic. A typical reporting query resolves the source name for each header:

• Joining OE_ORDER_HEADERS_ALL to OE_ORDER_SOURCES on ORDER_SOURCE_ID to report order counts grouped by NAME, revealing channel mix.
• Filtering on ENABLED_FLAG before populating interface tables to ensure only valid sources are used.
• Detecting unprocessed interface rows by joining OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL to this table and checking for missing or disabled sources.
• Confirming AIA_ENABLED_FLAG and USE_IDS_FLAG settings before enabling external integrations.

A representative pattern is: SELECT o.order_number, s.name FROM oe_order_headers_all o, oe_order_sources s WHERE o.order_source_id = s.order_source_id. Equivalent logic applies to the ACK and interface tables for troubleshooting inbound flows.

Related Objects

The documented foreign key graph shows OE_ORDER_SOURCES as a hub referenced by transactional, interface, and acknowledgment tables:

• OE_ORDER_HEADERS_ALL — References ORDER_SOURCE_ID and SOURCE_DOCUMENT_TYPE_ID; the primary consumer for order headers.
• OE_ORDER_LINES_ALL — References SOURCE_DOCUMENT_TYPE_ID for line-level source classification.
• OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL — Open interface tables requiring a valid source before import.
• OE_HEADER_ACKS and OE_LINE_ACKS — Acknowledgment tables that route responses back to the originating source.
• OE_ACTIONS_IFACE_ALL, OE_CREDITS_IFACE_ALL, OE_PRICE_ADJS_IFACE_ALL, OE_PRICE_ATTS_IFACE_ALL, OE_RESERVTNS_IFACE_ALL, OE_LOTSERIALS_IFACE_ALL, and OE_LOTSERIAL_ACKS — Additional interface and acknowledgment tables keyed by ORDER_SOURCE_ID.

Collectively, these relationships make OE_ORDER_SOURCES the authoritative reference for tracing and validating the origin of every order and interface record in Order Management.