Search Results pa_gl_cost_except_sum_mrc_v

Overview

PA_GL_COST_EXCEPT_SUM_MRC_V is a Multi-Reporting-Currency (MRC) view in the Oracle Projects (PA) module that identifies cost distribution lines which prevent an accounting period from being closed. In the Oracle E-Business Suite 12.1.1 / 12.2.2 architecture, cost distribution lines that have not successfully transferred to Oracle General Ledger block period close activity. This view surfaces those lines in a summarized, multi-currency reporting context so that project accountants and subledger administrators can quickly diagnose why a Projects period cannot be closed.

The view is frequently consulted in the context of the cdl_exception_type search term, because the view text hard-codes a literal value of 'I' for the column aliased CDL_EXCEPTION_TYPE. This literal identifies the row as an interface (cost distribution line) exception, distinguishing it from other exception classes that may appear in complementary views. The view also derives human-readable exception text and corrective action messages through the PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT API, making the output directly usable in diagnostics reports and period-close dashboards.

Functionally, the view bridges transaction data (expenditure items and their cost distribution lines) with GL period status information, ensuring that only distributions whose GL date falls within an open or relevant GL period are returned.

Underlying Base Objects

The view is defined over the following documented base objects:

• PA_COST_DISTRIBUTION_LINES_ALL (CDL) — the interface cost distribution lines that must be transferred to GL.
• PA_MC_COST_DIST_LINES_ALL (MCDL) — the corresponding multi-currency cost distribution lines that carry transfer status and rejection reasons.
• PA_EXPENDITURE_ITEMS_ALL (EI) — expenditure item details such as task, expenditure type, date, and system linkage function.
• PA_IMPLEMENTATIONS_ALL (IMP) — implementation flags that determine whether labor and usage expenditures are interfaced to GL.
• GL_PERIOD_STATUSES (PRD) — GL period definitions used to constrain the GL date range.

The join logic links CDL to MCDL on both EXPENDITURE_ITEM_ID and LINE_NUM, then links EI on EXPENDITURE_ITEM_ID. The predicate MCDL.TRANSFER_STATUS_CODE IN ('P','R','X') restricts results to lines in a pending, rejected, or exception state — the conditions that block period close. The view further filters EI on SYSTEM_LINKAGE_FUNCTION and the corresponding INTERFACE_*_TO_GL_FLAG values in PA_IMPLEMENTATIONS_ALL, and constrains CDL.GL_DATE between PRD.START_DATE and PRD.END_DATE, with PRD.APPLICATION_ID = 8721 (the Projects application) aligned to the implementation's set of books.

Key Columns

• CDL_EXCEPTION_TYPE — literal 'I', indicating an interface cost distribution line exception.
• SET_OF_BOOKS_ID, ORG_ID — ledger and operating unit context for MRC reporting.
• TASK_ID, EXPENDITURE_ID, EXPENDITURE_ITEM_ID — project/task and expenditure identifiers.
• EXPENDITURE_ITEM_DATE, EXPENDITURE_TYPE — the expenditure item's date and classification.
• COST_DISTRIBUTION_LINE_NUM — the CDL line number linked to the MC distribution line.
• GL_DATE, PERIOD_NAME — the accounting date and GL period the distribution belongs to.
• TRANSFER_STATUS_CODE, TRANSFER_REJECTION_REASON — the status (P/R/X) and reason code driving the block.
• EXCEPTION_REASON, CORRECTIVE_ACTION — readable text derived from PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT for message type 'COST_EXCP' (reason and action respectively).
• QUANTITY, AMOUNT, DENOM_AMOUNT, PROJECT_AMOUNT, DENOM_CURRENCY_CODE — quantity and multi-currency amounts for reconciliation.
• SAME_PA_GL_PERIOD — indicator of whether the PA and GL periods align.

Common Use Cases and Queries

Typical usage centers on diagnosing and resolving period-close blocks. Examples include:

• Listing all blocking cost distribution lines for a ledger and period before running the PRC: Interface Cost to GL process.
• Identifying rejected lines by TRANSFER_REJECTION_REASON and presenting the corrective action to users.
• Reconciling multi-currency amounts between PA and GL for affected lines.

Sample query:

SELECT cdl_exception_type,
       expenditure_item_id,
       cost_distribution_line_num,
       period_name,
       gl_date,
       transfer_status_code,
       transfer_rejection_reason,
       exception_reason,
       corrective_action,
       amount,
       denom_amount,
       denom_currency_code
  FROM pa_gl_cost_except_sum_mrc_v
 WHERE set_of_books_id = :p_sob_id
   AND period_name   = :p_period;

Because the view summarizes and restricts to status codes P, R, and X, its result set directly corresponds to the population that must be corrected or re-interfaced before the affected GL period can be closed.