Search Results pa_gl_cost_except_sum_v




Overview
Explore in AI Chat

Overview

PA_GL_COST_EXCEPT_SUM_V is a reporting and diagnostic view in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema and defined as a VALID database object. Its documented purpose is to identify the cost distribution lines that prevent a period from being closed or that block the transfer of costs to the General Ledger. In practice, this view serves as a consolidated exception summary, exposing only those distribution lines that carry conditions requiring user attention before period-end processing and GL transfer can complete successfully.

Because the underlying exception detail is normally spread across expenditure items, cost distribution lines, and implementation setup, this view is a convenience layer that presents joined, decoded exception information in a single queryable structure. It is commonly consumed by Project Costing reporting, period-close diagnostics, and reconciliation of rejected or unprocessed cost distributions.

Underlying Base Objects

Per the documented metadata, the view is defined over the following referenced objects:

The view therefore sits directly on top of the core cost distribution and expenditure tables, enriching them with exception classification logic from the PA_EXCEPTION_REASONS_PUB package.

Key Columns

Common Use Cases and Queries

The view is typically used to list lines blocking period close or GL transfer, and to drive corrective action. A representative query follows:

  • SELECT expenditure_item_id, cost_distribution_line_num, period_name, transfer_status_code, exception_reason, corrective_action FROM pa_gl_cost_except_sum_v WHERE org_id = :org_id AND period_name = :period_name ORDER BY period_name, cost_distribution_line_num;
  • Filter on CDL_EXCEPTION_TYPE to isolate particular exception classes for operational review.

Analysts use this view to reconcile rejected cost distributions against transferred amounts before running the cost transfer process.