Search Results aso_order_int




Overview
Explore in AI Chat

Overview

ASO_ORDER_INT is a PL/SQL package body owned by the APPS schema that serves as the order integration layer for Oracle E-Business Suite's Quote-to-Order (QTO) flows. Its primary business function is to bridge Oracle Advanced Supply Chain Planning (ASO) quoting data with Oracle Order Management (OM) order data, allowing sales orders to be created, updated, booked, cancelled, and queried directly from the Quote Management and order capture processes. The package is classified as API type OTHER and is documented as VALID in both EBS 12.1.1 and 12.2.2. In the dependency chain it consumes numerous supporting packages, including ASO_QUOTE_PUB, ASO_MAP_QUOTE_ORDER_INT, ASO_FFM_INT, ASO_PARTY_INT, ASO_DEBUG_PUB, and ASO_UTILITY_PVT, and it leverages key OM packages such as OE_ORDER_PUB, OE_ORDER_GRP, OE_HEADER_STATUS_PUB, OE_LINE_STATUS_PUB, OE_GLOBALS, OE_LOOKUPS, and OE_MSG_PUB. It is a widely used object: the documented metadata shows it is referenced by 33 other database objects, and it is not itself referenced as a database object (confirming its role as a calling/consumer layer rather than a callback target).

Key Procedures and Functions

The package exposes 17 documented procedures and functions that fall into three functional groups: order lifecycle management, lookups/attribute retrieval, and pricing/calculation utilities.

Tables Accessed

The documented table dependencies span the Trading Community Architecture (TCA) and order management schemas. Customer and party data is sourced from HZ_PARTIES, HZ_PARTY_SITES, HZ_ORG_CONTACTS, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_RELATIONSHIPS, and HZ_ROLE_RESPONSIBILITY — these provide the party, account, contact, and site-use context required to place an order on behalf of a customer. Quote-side data comes from ASO_QUOTE_HEADERS_ALL. Deliverable references are drawn from AMS_DELIVERABLES_ALL_B, and PLITBLM is used for PL/SQL table buffering. The package also references RA_SALESREPS for sales representative resolution, OE_LOOKUPS for order lookup values, and OE_OE_TOTALS_SUMMARY and OE_TOTALS_GRP for order total summations.

Usage Notes

ASO_ORDER_INT is typically invoked from Quote-to-Order flows originating in Oracle Quoting and order capture forms, as well as from concurrent programs and custom PL/SQL that need to push quote data into OM. Because it depends on FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, and FND_PROFILE, it follows the standard EBS API error-handling and messaging conventions. The presence of OE_STANDARD_WF, MO_GLOBAL, and OE_ORDER_PUB indicates integration with workflow and multi-org handling. Its heavy reuse (33 dependent objects) makes it a foundational integration utility; customizations should call the documented procedures rather than manipulate underlying tables directly, and any upgrade from 12.1.1 to 12.2.2 should verify signature compatibility, as both releases document the package as VALID.