Search Results cdl_line_num




Overview
Explore in AI Chat

Overview

PA_COST_EXCEPTIONS_DET_MRC_V is a Projects (PA) module reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2 that isolates the Cost Distribution Lines (CDL) responsible for preventing a project accounting period from closing. It is the detail-level companion to PA_COST_EXCEPTIONS_SUM_MRC_V and belongs to the same retrofitted family of Oracle Projects cost exception views. The "_MRC_V" suffix indicates that the view is designed for multi-reporting-currency (MRC) environments, so the set of books context is carried explicitly through SET_OF_BOOKS_ID, allowing a single query to surface exceptions per reporting ledger. The view exposes both the summary-level exception markers and the descriptive attributes drawn from the expenditure record, which makes it a convenient single source for diagnosing why an expenditure item has not transferred through cost distribution. In the ETRM metadata this object is marked "Not implemented in this database," meaning it exists as a documented definition seeded by Oracle Projects but is not necessarily instantiated in every environment; the view text is nevertheless the authoritative definition.

Underlying Base Objects

The view is defined with a USE_NL hint (summary first, then expenditure) over four objects. Three are base tables: PA_PROJECTS_ALL (aliased PRJ), PA_TASKS (aliased TSK), and PA_EXPENDITURES_ALL (aliased EXP). The fourth is the summary exception view PA_COST_EXCEPTIONS_SUM_MRC_V (aliased SMRY), which supplies SMRY.SET_OF_BOOKS_ID, SMRY.TASK_ID, SMRY.EXPENDITURE_ID, SMRY.EXPENDITURE_ITEM_ID, SMRY.CDL_LINE_NUM, and the exception descriptive columns. Joins are: PRJ.PROJECT_ID = TSK.PROJECT_ID, TSK.TASK_ID = SMRY.TASK_ID, and EXP.EXPENDITURE_ID = SMRY.EXPENDITURE_ID. The inline scalar subquery against PER_ALL_PEOPLE_F resolves the person name effective on EXP.EXPENDITURE_ENDING_DATE.

Key Columns

Common Use Cases and Queries

The primary use case is period-close troubleshooting: locating the exact cost distribution lines keeping a PA period open. A typical query filters by ledger, project, and period and returns the CDL line number and corrective guidance.

  • Identify blocking CDL lines for a given period:
    SELECT project_number, task_number, expenditure_item_id, cdl_line_num, period_name, exception_reason, corrective_action FROM pa_cost_exceptions_det_mrc_v WHERE set_of_books_id = :p_sob_id AND period_name = :p_period;
  • Reconcile exception amounts to the general ledger by currency, using DENOM_CURRENCY_CODE and DENOM_AMOUNT.
  • Group exceptions by CORRECTIVE_ACTION to prioritize remediation during close.
  • Join EXPENDITURE_ITEM_ID and CDL_LINE_NUM back to distribution and interface tables to correct the underlying transaction.

Because of the MRC suffix, results should always be qualified by SET_OF_BOOKS_ID to avoid mixing reporting-currency rows.