Search Results po_notification_ctrl_draft_uk1

Overview

The PO_NOTIFICATION_CTRL_DRAFT table is a core transactional table within the Oracle E-Business Suite Purchasing (PO) module, specifically for releases 12.1.1 and 12.2.2. It functions as a draft staging area for notification control records associated with blanket purchase agreements and planned purchase orders. This table is integral to the draft functionality, allowing users to save incomplete work. It temporarily holds notification parameters—such as notification dates and control amounts—before they are finalized and potentially moved to a base transaction table. Its role is to ensure data integrity and user flexibility during the complex setup of long-term purchasing arrangements.

Key Information Stored

The table's structure centers on linking draft notifications to their corresponding purchasing documents and draft sessions. While a full column list is not provided in the metadata, the defined keys reveal critical data relationships. The primary key is a composite of NOTIFICATION_ID and DRAFT_ID, uniquely identifying each draft notification record. The PO_HEADER_ID column foreign key links to the PO_HEADERS_ALL table, associating the notification control with a specific blanket or planned purchase order. The DRAFT_ID column foreign key links to the PO_DRAFTS table, connecting the data to a user's draft session. The table likely stores columns for notification sequence, last notification date, notification amount, and percentage for controlling releases against the agreement.

Common Use Cases and Queries

This table is primarily accessed during the draft creation and amendment processes for blanket and planned orders. Common operational scenarios include querying all pending draft notifications for a specific document or draft session, or validating data before submission. A typical reporting query might join this table to PO_HEADERS_ALL and PO_DRAFTS to list incomplete draft notifications. For example:

• SELECT pncd.notification_id, pha.segment1 po_number, pd.draft_id FROM po_notification_ctrl_draft pncd JOIN po_headers_all pha ON pncd.po_header_id = pha.po_header_id JOIN po_drafts pd ON pncd.draft_id = pd.draft_id WHERE pd.status = 'INCOMPLETE';

Data from this table is typically consumed by the Oracle Purchasing application's draft processing engine and is not intended for direct transactional reporting, as it holds transient data.

Related Objects

PO_NOTIFICATION_CTRL_DRAFT maintains strict relational integrity with several key EBS objects. It has a direct foreign key relationship to PO_DRAFTS (via DRAFT_ID), which manages the overarching draft session. A second foreign key relationship to PO_HEADERS_ALL (via PO_HEADER_ID) ties the notification controls to the purchasing document. The table has two defined constraints: PO_NOTIFICATION_CTRL_DRAFT_PK and PO_NOTIFICATION_CTRL_DRAFT_UK1, enforcing data uniqueness. It is logically related to the base transaction table for notification controls (likely PO_NOTIFICATION_CTRL_ALL), from which draft records may be sourced and to which they may be posted upon completion.