Search Results process_macd_order

Overview

The APPS.OE_CONFIG_TSO_GRP package is a component of the Oracle Order Management configuration infrastructure within Oracle E-Business Suite. Its name reflects its role as a group (GRP) package supporting the Configure-to-Order (CTO) and Assemble-to-Order flows of the Order Entry (OE) module, specifically handling the interaction between configured models and the "TSO" (To Stock Order) or pick-and-ship style processing logic for Make/Assemble-to-Order configurations. The package encapsulates the business logic required to interpret configuration actions applied against order lines and to create or manipulate the resulting structure of container and component lines.

The package is declared with AUTHID CURRENT_USER, indicating that its runtime privileges are derived from the invoking caller rather than from the package owner. This is consistent with Oracle's standard for public API packages that are intended to be invoked from other APPS-owned code or from customer extensions where the calling session carries the appropriate APPS schema privileges. The header revision (120.1) dates to the 11i-era source lineage and is carried forward into Oracle EBS 12.1.1 and 12.2.2 as part of the Order Management configuration API surface.

Key Procedures and Functions

The package exposes two documented procedures:

• GET_MACD_ACTION_MODE — Resolves the appropriate configuration/MACD action mode for a given order line context. It accepts an optional order line identifier and an optional top-level model line identifier, and returns a configuration mode value together with a standard return status. This procedure is used to determine how a configuration line should be processed based on its position in the configuration hierarchy and the applicable action mode.
• PROCESS_MACD_ORDER — The core processing routine. It accepts an API version number, sold-to organization identifier, header identifier (as an IN OUT parameter, permitting creation or update of the order header), a MACD action string, and two collection tables of instance and extended attribute values sourced from the CSI data structures public package. It returns a container line identifier, the number of containers generated, and the standard Oracle API return status, message count, and message data. The user search term "process_macd_order" corresponds directly to this procedure, indicating it is the primary entry point of interest.

Tables Accessed

The documented table reference for this package is OE_ORDER_LINES_ALL, accessed via APPS synonyms. This is the base table storing order line detail for all Order Management transactions. PROCESS_MACD_ORDER reads line records to interpret the configuration action and writes or updates line records to reflect the container and component structure generated by the MACD processing. The package additionally consumes instance and extended attribute collections whose signatures originate in CSI_DATASTRUCTURES_PUB, reflecting the integration between Order Management configuration and the Install Base (CSI) data model. No other base tables are documented in the provided metadata.

Usage Notes

OE_CONFIG_TSO_GRP is a group-type API intended for internal invocation rather than direct end-user calls. It is typically invoked from Order Management forms logic, from the configuration-related concurrent or workflow processing that drives model explosion and container creation, or from custom extensions that need to drive MACD order processing programmatically. The ETRM metadata records one package as referencing this package, confirming its role as a downstream utility within the configuration stack. When extending or debugging order configuration behavior, developers should treat PROCESS_MACD_ORDER as a transactional entry point that must be called within the standard API error-handling pattern, checking x_return_status against FND_API.G_RET_STS_SUCCESS and iterating messages via x_msg_count and x_msg_data.