Results for “mrp_po_flex_fences_v”

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

Overview

The MRP_PO_FLEX_FENCES_V view is a purchasing flex fence reporting object owned by the APPS schema within the Oracle E-Business Suite Master Scheduling/MRP product family. Flex fences define time-based tolerances around a planned delivery or receipt date, allowing a purchasing organization to express how much schedule variance — measured in days — is acceptable from a given supplier for a given item before the change must be escalated, renegotiated, or replanned. This view presents those supplier/item tolerance definitions together with the item, organization, and supplier context needed to interpret them.

Its role in Oracle EBS is primarily informational and integration-oriented. Rather than maintaining data of its own, the view distills supplier tolerance records into a denormalized, report-friendly shape that joins the supplier master view (MRP_PO_SUPPLIERS_V) to the tolerance table exposed through the PO_SUPPLIER_ITEM_TOLERANCE synonym. Planning personnel, buyers, and custom reports can query it to determine the number of days of early or late tolerance permitted for a specific item/supplier/organization combination. Because it is a view, it always reflects the current state of its underlying tables and requires no concurrent program or refresh to stay current.

Underlying Base Objects

Per the documented ETRM metadata for release 12.2.2, the view is defined over the following referenced base objects:

• MRP_PO_SUPPLIERS_V (VIEW) — supplies the supplier and item context: COMPILE_DESIGNATOR, INVENTORY_ITEM_ID, ORGANIZATION_ID, USING_ORGANIZATION_ID, SUPPLIER_ID, SUPPLIER_SITE_ID, and ASL_ID.
• PO_SUPPLIER_ITEM_TOLERANCE (SYNONYM) — the Approved Supplier List (ASL) tolerance source that contributes NUMBER_OF_DAYS and TOLERANCE, joined on ASL_ID and USING_ORGANIZATION_ID.
• PO_ASL_SV (PACKAGE) — the Approved Supplier List server-side package underlying ASL processing, which maintains the tolerance data referenced by the synonym.

The join logic is explicit in the view text: the tolerance row matches the supplier row where FENCE.ASL_ID = SUP.ASL_ID and FENCE.USING_ORGANIZATION_ID = SUP.USING_ORGANIZATION_ID. The presence of DISTINCT indicates that duplicate ASL/tolerance combinations are collapsed, yielding one row per unique item, organization, and supplier.

Key Columns

• COMPILE_DESIGNATOR — identifies the plan or compile context associated with the supplier record.
• INVENTORY_ITEM_ID — the item for which the tolerance is defined.
• ORGANIZATION_ID — the inventory organization owning the item definition.
• USING_ORGANIZATION_ID — the organization that actually uses the ASL and tolerance entry; this is the critical join key to the tolerance source.
• SUPPLIER_ID / SUPPLIER_SITE_ID — the supplier and specific supplier site to which the tolerance applies.
• NUMBER_OF_DAYS / DAYS_EARLY — the flex fence window expressed in days. The view text selects FENCE.NUMBER_OF_DAYS, while the documented column list also references DAYS_EARLY.
• TOLERANCE — the tolerance value permitted within the fence, i.e., the acceptable deviation from the scheduled date.

Common Use Cases and Queries

Typical usage includes validating supplier tolerance setup prior to releasing planned orders, populating custom planning reports and dashboards, and feeding external supply-chain or supplier-portal integrations. A representative query returning tolerance for a given item and supplier site is:

• SELECT inventory_item_id, organization_id, supplier_id, supplier_site_id, number_of_days, tolerance FROM apps.mrp_po_flex_fences_v WHERE inventory_item_id = :item AND supplier_site_id = :site;
• SELECT supplier_id, supplier_site_id, number_of_days, tolerance FROM apps.mrp_po_flex_fences_v WHERE using_organization_id = :org ORDER BY supplier_id;

Because the view references ASL-based tolerance data, records are only returned where a valid Approved Supplier List entry and matching tolerance exist for the using organization. Absence of a row therefore indicates that no flex fence tolerance has been configured for that item/supplier combination.