Search Results cto_workflow




Overview
Explore in AI Chat

Overview

APPS.CTO_WORKFLOW is the Oracle Manufacturing PL/SQL package that implements the workflow-facing interface for Configure-to-Order (CTO) and Assemble-to-Order (ATO) processing in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its header identifies the source file as CTOWKFLS.pls and states that the package creates procedures invoked for each ATO Workflow activity. In other words, the package acts as the bridge between the Oracle Workflow engine and the underlying BOM configuration, reservation, and scheduling APIs.

During an ATO sales order lifecycle, workflow activities must match a customer-selected configuration to a valid model, reserve the configured items, create routing and flow schedule records, calculate lead times and costs, and validate that prerequisites such as reservations exist. CTO_WORKFLOW exposes discrete entry points for each of these activities, delegating the substantive business logic to packages such as BOM_CTO_WF_API and BOM_MATCH_CONFIG while controlling flow direction, error handling, and workflow state updates. The package is classified as OTHER in the ETRM metadata and is referenced by seven other packages, confirming its role as a shared integration layer rather than a standalone application component.

Key Procedures and Functions

The ETRM metadata documents twenty-two procedures and functions. Their principal groupings are as follows.

Procedure set_parameter_lead_time_wf was removed at version 120.1 per bug 3202825, and a NOCOPY hint was applied to all OUT parameters in June 2005.

Tables Accessed

The package reads and writes through APPS synonyms. Order and configuration data reside in OE_ORDER_HEADERS_ALL, OE_ORDER_LINES, OE_ORDER_LINES_ALL, OE_TRANSACTION_TYPES_ALL, and OE_TRANSACTION_TYPES_TL, together with BOM_CTO_ORDER_LINES for CTO-specific line attributes. Reservation and inventory information is held in MTL_RESERVATIONS, MTL_SYSTEM_ITEMS, and MTL_SALES_ORDERS. Manufacturing scheduling touches WIP_FLOW_SCHEDULES, WIP_JOB_SCHEDULE_INTERFACE, WIP_INTERFACE_ERRORS, and BOM_OPERATIONAL_ROUTINGS. FND_USER and FND_LANGUAGES supply the session user and language context.

Usage Notes

CTO_WORKFLOW is not intended for direct invocation by end users. It is called by the Oracle Workflow engine as the ATO order process executes each function and notification activity, with the order line identifier normally supplied as the workflow item key. Because the package is public and referenced by seven other PL/SQL units, it may also be called from custom workflow definitions or extensions that add or reorder ATO activities. In all cases, callers must supply a valid workflow item type and activity context, and should treat the underlying table writes as part of the standard order-to-manufacturing transaction, subject to the same validation and error-handling rules as Oracle's seeded ATO process.