Search Results aging_period




Overview
Explore in AI Chat

Overview

PO_ASL_ATTRIBUTES is a Purchasing (PO) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, owned by the PO schema. It stores the sourcing, scheduling, and supplier-managed inventory (VMI/consignment) attributes attached to an entry in the Approved Supplier List (ASL). Where PO_APPROVED_SUPPLIER_LIST records the approval of a supplier, supplier site, or item, PO_ASL_ATTRIBUTES carries the operational procurement policy applied to that approval — document sourcing method, release generation method, planning and shipping schedules, pricing tolerances, ordering constraints, and VMI or consignment parameters. Approximately 64 columns are documented in the ETRM 12.2.2 physical schema. Heuristic Data Vault classification mined from its foreign key structure is standalone, suggesting the table functions as a self-contained extension or attribute-bearing satellite of the ASL record rather than as a link between independent business hubs; modelers may treat it as a detail satellite keyed by ASL, though the absence of an isolated surrogate of its own favors this reading only as a suggestion.

Key Information Stored

The most significant columns include:

The unique index PO_ASL_ATTRIBUTES_U1 on (ASL_ID, USING_ORGANIZATION_ID) is the documented business-key candidate, enforcing one attribute row per ASL entry per consuming organization. The surrogate identity is effectively the composite ASL_ID plus USING_ORGANIZATION_ID rather than a dedicated single-column key.

Common Use Cases and Queries

Typical uses center on sourcing and supplier-scheduling reporting. A common pattern joins the attribute row to its parent ASL entry to return the sourcing method and VMI status for a given item/supplier combination:

SELECT a.asl_id, a.using_organization_id, a.document_sourcing_method, a.enable_vmi_flag, a.vmi_min_qty, a.vmi_max_qty FROM po.po_asl_attributes a WHERE a.asl_id = :asl_id;

Reporting VMI-enabled suppliers by organization:

SELECT using_organization_id, asl_id, vmi_min_qty, vmi_max_qty FROM po.po_asl_attributes WHERE enable_vmi_flag = 'Y';

Other scenarios include auditing price update tolerance and processing lead time for approved suppliers, extracting consignment billing cycles for reconciliation, and diagnosing automatic scheduling configuration via SCHEDULER_ID. Because the table carries descriptive flexfield columns, queries often filter on ATTRIBUTE_CATEGORY and the ATTRIBUTE1–15 segments for client-specific sourcing rules.

Related Objects