Search Results aso_atp_int




Overview
Explore in AI Chat

Overview

ASO_ATP_INT is an Oracle EBS Order Management package in the APPS schema that supports Available-To-Promise (ATP) inquiry and scheduling for quoted configurations. It is part of the Oracle Advanced Supply Chain Planning / Applications Technology integration layer that allows Sales Online and related quoting modules to retrieve ATP, quantity-on-hand, and shipment scheduling information for both standard and configured (ATO/PTO) items. The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema, and maintains a global fetch constant (G_DEFAULT_NUM_REC_FETCH set to 30) that governs how many ATP records are returned per call to the scheduling engine.

The package's most significant public declaration is the ATP_Rec_Typ record type — the "atp_rec_typ" the user searched for. This record is the canonical in-memory representation of an ATP result row, spanning more than sixty attributes that capture the full scheduling context of a quoted line.

Key Procedures and Functions

  • CHECK_ATP — Retrieves and validates ATP availability for the items, organizations, and requested dates supplied by the caller. It populates the ATP_Rec_Typ structure with the resolved available quantity, request-date quantities, promised ship date, arrival date, and error messaging fields.
  • UPDATE_CONFIGURATION — Persists configuration details back to the quoting tables. It is used after a configured item's scheduling information has been refreshed or altered, keeping the quote structure in synchronization with the ATP result.

Both procedures are classified as OTHER in the ETRM 12.2.2 API classification, indicating that they are internal integration routines rather than fully documented public APIs. No formal parameter signatures are published, and callers should treat the argument lists as implementation-specific.

Tables Accessed

  • ASO_QUOTE_HEADERS_ALL / ASO_QUOTE_LINES_ALL / ASO_QUOTE_LINE_DETAILS — The quote hierarchy that provides the context (header, line, and component detail) for which ATP is being requested and updated.
  • ASO_SHIPMENTS — Source of existing shipment and scheduling data associated with the quote.
  • MRP_ATP_SCHEDULE_TEMP_S / MSC_TP_ID_LID / MSC_TP_SITE_ID_LID — Planning and ATP scheduling temporary structures, along with the Trading Partner ID and Site ID lookup tables from the Advanced Planning schema, used to resolve ATP availability.
  • MTL_SYSTEM_ITEMS_KFV — Key flexfield view supplying item number, description, and concatenated segment information for the ATP_Rec_Typ item fields.
  • FND_LOOKUP_VALUES — Resolves meanings for UOM, demand class, ship method, and request date type codes into their display values.
  • DBMS_SQL / DUAL / PLITBLM — Dynamic SQL, single-row operations, and PL/SQL table utilities used internally.

Usage Notes

ASO_ATP_INT is invoked from within Oracle's quoting and order capture flows rather than directly by end users. It is referenced by three other packages in the ETRM repository, confirming its role as a shared integration utility. Typical invocations occur when a user requests ATP or scheduling information from a Sales Online quote or order entry form, and at the time a configuration is updated and the scheduling results must be written back. Custom code calling this package should be aware that it is not a documented public API: the ATP_Rec_Typ record layout is internal, the procedures are classified OTHER, and behavior may change between 12.1.1 and 12.2.2. Developers needing a supported interface should prefer the documented Order Management ATP APIs and treat aso_atp_int strictly as an internal supporting package.