Search Results aso_cfg_int




Overview
Explore in AI Chat

Overview

ASO_CFG_INT is a PL/SQL package in the APPS schema that serves as the configuration integration layer for Oracle E-Business Suite's Advanced Supply Chain and Order Capture (ASO) Quote Management module. Its primary business function is to bridge Oracle Quoting with the Oracle Configurator engine (CZ) — the runtime rules engine that validates, prices, and generates configured bills of material for model and option-class items. When a sales representative builds or modifies a configured item on a quote line, ASO_CFG_INT orchestrates the exchange of XML payloads between ASO's quote structures and the Configurator server, retrieves configuration line details, triggers pricing callbacks, and persists the resulting configuration data back to the ASO quote tables. The package is classified as an OTHER integration API rather than a public business API, indicating it is intended primarily for internal consumption by other ASO packages and the Oracle Quoting user interface rather than for direct customer extension.

Key Procedures and Functions

The documented metadata identifies eleven procedures and functions:

  • GET_CONFIGURATION_LINES — Retrieves the configuration line rows associated with a quote line, exposing the hierarchical structure of the configured item for downstream processing.
  • GET_CONFIG_DETAILS — Returns the detailed attribute and option information for a configuration, supporting UI display and validation.
  • VALIDATE_CONFIGURATION — Submits the current configuration to the Configurator engine to confirm that all required options are selected and no rule violations exist.
  • DELETE_CONFIGURATION and DELETE_CONFIGURATION_AUTO — Remove configuration data from a quote line, with the AUTO variant supporting programmatic or cascading deletion scenarios.
  • COPY_CONFIGURATION — Duplicates an existing configuration, enabling quote copy, template application, and re-quote workflows.
  • PRICING_CALLBACK — Invoked by the Configurator engine to return pricing results, recalculating configured item prices within the ASO quote context.
  • QUERY_QTE_LINE_ROWS — Queries the underlying quote line rows that participate in a configuration, typically for rebuilding the runtime configuration model.
  • CREATE_HDR_XML, SEND_INPUT_XML, PARSE_OUTPUT_XML — The XML transport triad: building the header-level request document, transmitting it to the Configurator over HTTP, and parsing the response back into PL/SQL structures.

Tables Accessed

The package reads and writes several core ASO tables through APPS synonyms. ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL, and ASO_QUOTE_LINE_DETAILS hold the quote header, line, and line-detail records that anchor a configured line. ASO_LINE_RELATIONSHIPS stores the parent-child relationships between configurator lines, which GET_CONFIGURATION_LINES relies upon to reconstruct hierarchy. On the Configurator side, CZ_CONFIG_MESSAGES captures validation and error messages returned by the rules engine, while CZ_PRICING_STRUCTURES holds pricing structure definitions used during validation. MTL_SYSTEM_ITEMS_B provides item master attributes for the model and option items being configured. The package also references PLITBLM (used with FND_API for message handling) and UTL_HTTP for the outbound HTTP calls that transmit XML to the Configurator server.

Usage Notes

ASO_CFG_INT is not invoked directly by end users or typical customizations. It is called by higher-level ASO packages — ASO_CFG_PUB, ASO_QUOTE_HEADERS_PVT, ASO_QUOTE_LINES_PVT, ASO_QUOTE_TMPL_PVT, ASO_COPY_QUOTE_PVT, and ASO_NETWORK_UI_PVT — which drive it from the Oracle Quoting forms interface, the quote copy and template flows, and the network/UI layer. The package in turn depends on ASO_QUOTE_PUB, CZ_API_PUB, and FND_API. Because it performs synchronous HTTP communication with the Configurator server via UTL_HTTP, runtime availability of the Configurator middle tier is a prerequisite for configuration validation and pricing during quote entry. Customers extending Oracle Quoting should call the public ASO_CFG_PUB APIs rather than ASO_CFG_INT, since the internal signatures are not guaranteed across releases. The package behaves identically in 12.1.1 and 12.2.2, as the ASO configuration integration architecture was unchanged between these releases.