Search Results org




The BOM_CTO_OSS_ORGS_LIST table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure used within the Configure-to-Order (CTO) and Order-to-Ship (OSS) modules. This table serves as a mapping repository that associates organizations (inventory, manufacturing, or operating units) with their respective CTO and OSS functionalities. It plays a pivotal role in enabling multi-org configurations, order orchestration, and inventory visibility across distributed supply chain operations.

Purpose and Functional Context

The primary purpose of BOM_CTO_OSS_ORGS_LIST is to define which organizations participate in CTO and OSS processes. In CTO implementations, where products are assembled based on customer specifications, this table ensures that the correct organizations are flagged for configuration item validation, component sourcing, and order fulfillment. For OSS, it designates organizations involved in order promising, allocation, and shipping workflows. The table acts as a control mechanism to restrict or enable specific functionalities per organization, ensuring process compliance and data integrity.

Table Structure and Key Columns

The table typically includes the following key columns:
  • ORGANIZATION_ID: Foreign key referencing HR_ORGANIZATION_UNITS or MTL_PARAMETERS, identifying the org.
  • CTO_ENABLED_FLAG: Boolean (Y/N) indicating if CTO processing is active for the org.
  • OSS_ENABLED_FLAG: Boolean (Y/N) indicating OSS participation.
  • DEFAULT_SHIPPING_ORG_FLAG: Marks the org as a default shipping entity in OSS flows.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.

Integration Points

BOM_CTO_OSS_ORGS_LIST integrates with several EBS modules:
  1. Order Management (OM): Determines eligible orgs for CTO order lines and OSS ATP checks.
  2. Inventory (INV): Validates orgs for component reservations and transfers.
  3. Work in Process (WIP): Controls orgs where configured assemblies can be built.
  4. Advanced Supply Chain Planning (ASCP): Informs planning engines about CTO/OSS-enabled orgs for sourcing recommendations.

Implementation Considerations

When deploying CTO/OSS solutions in EBS 12.1.1 or 12.2.2, administrators must:
  • Populate this table via BOM_CTO_OSS_ORG_PKG APIs to maintain referential integrity.
  • Ensure org IDs align with HR_ALL_ORGANIZATION_UNITS to avoid orphaned records.
  • Audit flag settings post-multi-org changes (e.g., acquisitions, divestitures).

Performance and Customization

The table is frequently accessed during order entry and fulfillment. Indexes on ORGANIZATION_ID and flag columns are recommended. Customizations (e.g., adding org attributes) should extend the table via descriptive flexfields rather than direct DDL modifications to preserve upgrade compatibility.

Version-Specific Notes

In EBS 12.2.2, the table may incorporate additional columns for cloud integration or enhanced OSS features like drop-ship org tagging. However, its core functionality remains consistent with 12.1.1. Both versions rely on this table to enforce CTO/OSS business rules during order lifecycle operations. In summary, BOM_CTO_OSS_ORGS_LIST is a foundational control table that orchestrates Configure-to-Order and Order-to-Ship processes across organizations in Oracle EBS. Proper configuration of this table is essential for accurate order promising, inventory allocation, and multi-org supply chain execution.