Results for “so_order_number_sources”

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

Overview

The SO_ORDER_NUMBER_SOURCES table resides in the OE (Order Entry) schema and is a foundational configuration object in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to define the valid order numbering sources that the Order Management module uses when generating order numbers. Each row represents a numbering scheme available to order entry flows, allowing implementers to control how sales order numbers are assigned and sequenced across different business contexts.

Under the heuristic Data Vault classification derived from the foreign-key structure, this table is hub-leaning. This suggests a modeling exercise in which ORDER_NUMBER_SOURCE_ID behaves as the hub business key, with descriptive attributes (name, active dates, sequence starting point) functioning as satellite-style context. The table is validated and active as of the 12.2.2 ETRM documentation set, and its structure is consistent with the 12.1.1 release.

Key Information Stored

The table contains 27 documented columns. The most significant are outlined below:

• ORDER_NUMBER_SOURCE_ID — the surrogate primary key (SO_ORDER_NUMBER_SOURCES_PK) uniquely identifying each numbering source.
• NAME — the business-key candidate enforced by unique index SO_ORDER_NUMBER_SOURCES_U1/U2; the human-readable identifier for the numbering source.
• SEQUENCE_STARTING_POINT — the initial numeric value from which order number sequences begin.
• DESCRIPTION — free-text explanation of the source's purpose.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating that governs whether the source is currently assignable.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the DFF (Descriptive Flexfield) segments supporting extensibility.

The surrogate key ORDER_NUMBER_SOURCE_ID is a system-generated identifier, while NAME is the meaningful candidate that users and integrations reference when selecting a numbering source.

Common Use Cases and Queries

Typical usages include auditing which numbering sources are active, validating data migration, and mapping interface rows back to their source definitions. A representative query identifying currently active sources:

• SELECT ORDER_NUMBER_SOURCE_ID, NAME, SEQUENCE_STARTING_POINT FROM OE.SO_ORDER_NUMBER_SOURCES WHERE SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE+1);

Because the user searched for "Supplier Number," this table should be understood as distinct from supplier data — it stores order numbering source identifiers, not vendor or supplier reference numbers. Reporting scenarios include verifying that each interface order (via SO_HEADERS_INTERFACE_ALL.ORDER_NUMBER_SOURCE_ID) resolves to a valid, active source definition before order import runs.

Related Objects

• SO_HEADERS_INTERFACE_ALL — the sole documented dependent, joining on ORDER_NUMBER_SOURCE_ID, carrying the selected source for imported orders.
• SO_ORDER_NUMBER_SOURCES_PK / _U1 / _U2 — the primary and unique indexes enforcing integrity.
• OE_ORDER_NUMBER_SOURCES and Order Management concurrent programs — consume the definitions when generating numbers.
• SO_HEADERS_ALL and SO_LINES_ALL — the runtime order tables whose numbering ultimately derives from these definitions.