Search Results get_configuration_lines

Overview

ASO_CFG_PUB is the public configuration API for Oracle E-Business Suite's Oracle Configurator and Advanced Pricing integration within the Quote Management (ASO) module. It exposes the runtime services that transform a configured model — the set of component and option selections captured on a quote line — into priced, persisted configuration detail lines. In EBS 12.1.1 and 12.2.2 the package is owned by APPS and is classified PUB, meaning external callers may invoke its procedures directly. Its central role is to retrieve the configuration detail associated with a configuration header and revision, and to drive pricing callbacks that compute the price of configured items. The header comment (asopcfgs.pls 120.1) confirms the package has been stable since the 11i/12.0 era, and it remains the supported programmatic entry point for configuration line retrieval in Release 12.

Key Procedures and Functions

• GET_CONFIG_DETAILS — the procedure most commonly sought under the search term "get_configuration_lines." It is overloaded across two signatures distinguished by their record inputs. One overload accepts a quote line detail record together with a model line record; the second accepts a full quote header record, a model line record, and a quote line detail record. Both return a configuration's detail for a given configuration header ID and revision, and both report status through the standard FND_API triplet (return status, message count, message data). Callers choose the overload that matches the context in which the configuration was created.
• PRICING_CALLBACK — receives a configuration session key and a price type, and returns the computed total price for the configuration. It is the standard hook invoked when a configurator runtime session requests pricing for the current selection.
• PRICING_CALLBACK_MANUAL — the manual counterpart to the above, allowing pricing to be triggered outside the automated runtime flow, typically for repricing or adjustment scenarios.
• ASO_CONFIG_PRICE_ITEMS_MLS and ASO_CONFIG_PRICE_ITEMS_MLS_MAN — multilanguage views/support routines exposing configured price items in the user's language, with the _MAN variant serving the manually-driven pricing path.

The package also defines G_DEFAULT_NUM_REC_FETCH (default 30), the fetch batch size used when iterating configuration records.

Tables Accessed

The package operates against ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL, accessed through APPS synonyms. Quote headers supply the header-level context and pricing attributes used by the header-record overload of GET_CONFIG_DETAILS; quote lines supply the model line and configuration line detail that identify the configuration header, revision, and its priced components. Writes to these tables occur when configuration details are persisted or repriced as a result of the callback procedures.

Usage Notes

ASO_CFG_PUB is referenced by five other packages and is normally invoked from Oracle Configurator runtime flows, the Quote/Order Management forms, and custom extensions performing configuration repricing or line retrieval. Because the procedure is overloaded, custom code must match parameter lists precisely; passing a control record whose values are not initialized (G_MISS_control_rec) causes the API to fall back to defaults. Always initialize the message list before calling, check x_return_status for FND_API.G_RET_STS_ERROR or UNEXPECTED_ERROR, and loop over x_msg_count and x_msg_data (or FND_MSG_PUB) to surface validation failures. In R12, callers should avoid direct DML on the ASO configuration tables and use this API to remain upgrade-safe.