Results for “forecast_horizon”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• ASL_ID — foreign key to PO_APPROVED_SUPPLIER_LIST; identifies the approved supplier list entry to which these attributes belong.
• USING_ORGANIZATION_ID — the inventory organization consuming the souring attributes; forms part of the business key.
• DOCUMENT_SOURCING_METHOD — determines how purchasing documents are created (for example blanket agreement or global agreement sourcing).
• RELEASE_GENERATION_METHOD — controls whether releases are generated automatically or manually from the source agreement.
• PURCHASING_UNIT_OF_MEASURE — the UOM applied when procuring against the ASL.
• PLAN_SCHEDULE_TYPE / SHIP_SCHEDULE_TYPE and PLAN_BUCKET_PATTERN_ID / SHIP_BUCKET_PATTERN_ID — scheduling and bucket pattern configuration for supplier scheduling.
• ENABLE_AUTOSCHEDULE_FLAG and SCHEDULER_ID (FK to AMS_SCHEDULER) — enablement and identification of the scheduler used for automatic schedule generation.
• PRICE_UPDATE_TOLERANCE — acceptable variance for price updates on the agreement.
• PROCESSING_LEAD_TIME, MIN_ORDER_QTY, FIXED_LOT_MULTIPLE, FIXED_ORDER_QUANTITY — ordering constraints and lead-time defaults.
• VMI columns — ENABLE_VMI_FLAG, VMI_MIN_QTY, VMI_MAX_QTY, VMI_MIN_DAYS, VMI_MAX_DAYS, VMI_REPLENISHMENT_APPROVAL, ENABLE_VMI_AUTO_REPLENISH_FLAG.
• Consignment columns — CONSIGNED_FROM_SUPPLIER_FLAG, CONSIGNED_BILLING_CYCLE, LAST_BILLING_DATE, CONSUME_ON_AGING_FLAG, AGING_PERIOD.
• COUNTRY_OF_ORIGIN_CODE, DELIVERY_CALENDAR, FORECAST_HORIZON, REPLENISHMENT_METHOD — additional sourcing and planning parameters.
• Descriptive flexfield columns — ATTRIBUTE_CATEGORY through ATTRIBUTE15, plus the standard WHO/audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE).

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

• PO_APPROVED_SUPPLIER_LIST — parent table; joined on ASL_ID.
• AMS_SCHEDULER — referenced via SCHEDULER_ID for automatic schedule generation.
• PO_ASL_ATTRIBUTES_U1 — unique index (ASL_ID, USING_ORGANIZATION_ID) enforcing the business key.
• PO_VENDORS / PO_VENDOR_SITES_ALL — supplier and supplier site context via VENDOR_ID and VENDOR_SITE_ID.
• MTL_SYSTEM_ITEMS_B — item context via ITEM_ID.
• MTL_CATEGORIES_B — category context via CATEGORY_ID.
• MRP/Planning bucket pattern objects (e.g., MTL_SCHEDULING_BUCKET_PATTERNS) — referenced through PLAN_BUCKET_PATTERN_ID and SHIP_BUCKET_PATTERN_ID.