Search Results gl_cancel_date




Overview
Explore in AI Chat

Overview

POBV_SCHEDULED_DISTRIBUTIONS is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the Purchasing (PO) product family. It presents a consolidated, denormalized projection of procurement distribution data restricted to a specific business context: planned purchase orders whose shipment type is SCHEDULED. The view joins distribution-level records with their parent shipment, line, header, release, and organization entities so that consumers can query scheduled distributions without reconstructing the multi-level purchasing hierarchy themselves.

The object is documented in EBS 12.1.1 and 12.2.2 as Retrofitted, indicating it was adapted for the later multi-org (MOAC) architecture and the ORG_ID-based security model. Its principal role is to support reporting, reconciliation, and integration scenarios where scheduled purchasing activity must be analyzed at the distribution level — for example, accrual, encumbrance, funds check, and billing status tracking. Notably, the view exposes GL_CANCELLED_DATE, the column users locate when searching for the term "gl_cancel_date," which records the General Ledger date on which the distribution was cancelled.

Underlying Base Objects

The view is defined over six documented base objects, all referenced through APPS synonyms:

The join is keyed on distribution-to-shipment, shipment-to-line, line-to-header, and header-to-release relationships, with the organization unit providing the MOAC operating unit context. Because these are _ALL tables, ORG_ID filtering is required in every query to enforce operating unit security.

Key Columns

Common Use Cases and Queries

Typical uses include cancelled-distribution auditing, encumbrance reconciliation, and scheduled PO reporting.

Locating cancelled scheduled distributions by GL cancellation date:

  • SELECT SEGMENT1, DISTRIBUTION_NUM, GL_CANCELLED_DATE, QUANTITY_CANCELLED FROM POBV_SCHEDULED_DISTRIBUTIONS WHERE ORG_ID = :p_org_id AND GL_CANCELLED_DATE IS NOT NULL ORDER BY GL_CANCELLED_DATE DESC;

Encumbrance reconciliation for a period:

  • SELECT SEGMENT1, GL_ENCUMBERED_PERIOD_NAME, ENCUMBERED_AMOUNT, UNENCUMBERED_AMOUNT FROM POBV_SCHEDULED_DISTRIBUTIONS WHERE ORG_ID = :p_org_id AND GL_ENCUMBERED_PERIOD_NAME = :p_period;

Billing versus ordered quantity analysis:

  • SELECT SEGMENT1, DISTRIBUTION_NUM, QUANTITY_ORDERED, QUANTITY_BILLED, AMOUNT_BILLED FROM POBV_SCHEDULED_DISTRIBUTIONS WHERE ORG_ID = :p_org_id AND QUANTITY_ORDERED > QUANTITY_BILLED;

All queries must constrain ORG_ID to respect MOAC security, and joins to PO_DISTRIBUTIONS_ALL on PO_DISTRIBUTION_ID can be used when additional distribution attributes are required.