Search Results check_inv_rsv_exists

Overview

APPS.CTO_WORKFLOW is the Oracle Manufacturing workflow support package for Configure-to-Order (CTO) and Assemble-to-Order (ATO) processing in Oracle E-Business Suite 12.1.1 and 12.2.2. Its header places it under Oracle Manufacturing and it is owned by APPS, with an API classification of OTHER. The package body (source file CTOWKFLB.pls, last shipped revision 120.13.12010000.2) backs the Order Management CTO/ATO workflow activities that drive configuration item creation, reservation validation, bill of material and routing creation, cost rollup, flow schedule creation, and work order processing. It is referenced by seven other packages, indicating a shared, low-level utility role within the configured-order fulfillment flow. The header history shows continuous maintenance from an initial version in March 1999 through 2001, addressing defects in configuration item handling, single-row query retrieval, ATO-under-PTO item types, internal order demand source, and reservation-before-booking logic.

Key Procedures and Functions

The documented interface exposes 22 procedures and functions. Among the core workflow entry points, CREATE_CONFIG_ITEM_WF creates the configured item (and, per history notes, also handles link items), while CREATE_RESERVATION and CHECK_RESERVATION_STATUS_WF manage and evaluate inventory reservations for the configured order line. CREATE_BOM_AND_ROUTING_WF builds the bill and routing structures, and CREATE_FLOW_SCHEDULE_WF supports flow manufacturing schedules. Costing utilities include CALCULATE_COST_ROLLUP_WF_ML and PURCHASE_PRICE_CALC_WF. Parameter-setting routines are SET_PARAMETER_LEAD_TIME_WF_ML and SET_PARAMETER_WORK_ORDER_WF, and supply validation is handled by CHECK_SUPPLY_TYPE_WF. Concurrent-program orchestration is provided by SUBMIT_CONC_PROG_WF and SUBMIT_AND_CONTINUE_WF. Validation helpers include VALIDATE_LINE, VALIDATE_CONFIG_LINE, CONFIG_LINE_EXISTS, RESERVATION_EXISTS, FLOW_SCH_EXISTS, CHECK_INV_RSV_EXISTS, CHECK_RSV_EXISTS, RSV_BEFORE_BOOKING_WF, and CHK_RSV_AFTER_AFAS_WF. The user-flagged routine CHECK_INV_RSV_EXISTS tests whether an inventory reservation exists for the order line and is one of several reservation-existence predicates used before booking or accounting activities. RSV_BEFORE_BOOKING_WF is documented in the history as restricted to ATO items, with a corresponding Order Management workflow change.

Tables Accessed

The package reads and writes through APPS synonyms across order, inventory, engineering, and work-in-process schemas. Order data comes from OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL (and OE_ORDER_LINES), OE_TRANSACTION_TYPES_ALL, and OE_TRANSACTION_TYPES_TL, which supply line, line-type, and transaction-type context. Inventory reservation and item validation rely on MTL_RESERVATIONS, MTL_SYSTEM_ITEMS, and MTL_SALES_ORDERS. Configured order line structure is stored in BOM_CTO_ORDER_LINES, while routing information is read from BOM_OPERATIONAL_ROUTINGS. Manufacturing execution data is drawn from WIP_FLOW_SCHEDULES, and interface errors are recorded in WIP_INTERFACE_ERRORS and WIP_JOB_SCHEDULE_INTERFACE. FND_USER and FND_LANGUAGES support user identification and multilingual (ML) cost rollup and parameter messages.

Usage Notes

CTO_WORKFLOW is not an end-user API. It is invoked by Oracle Order Management and Manufacturing workflow processes and by other packages that reference it, particularly during ATO/CTO line processing after booking. CHECK_INV_RSV_EXISTS and its sibling predicates are typically called defensively before operations that depend on a valid reservation, so custom code should treat them as read-only checks. Direct calls are uncommon and should be limited to extensions of the standard CTO workflow; because the package is owned by APPS and shipped as a seeded body, customers should not modify it, but may call its documented procedures from custom workflow activity functions or concurrent programs where the standard flow requires extension.