Search Results cost_exc

Overview

APPS.PA_GL_COST_EXCEPT_SUM_V is a reporting view in Oracle E-Business Suite (validated against 12.1.1 and 12.2.2) that consolidates cost distribution exception data generated during the interface of project expenditures from Oracle Projects to Oracle General Ledger. Its purpose is to present, in a single denormalized result set, every cost distribution line that may require attention before it can be successfully transferred to the GL, together with the descriptive exception reason and corrective action recommended by Oracle Projects.

The view is exposed under the APPS schema and is typically consumed by Oracle Projects inquiry screens, by the cost exception reporting functionality, and by custom extracts built for month-end close monitoring. It is especially relevant to implementers who investigate the burden_sum_rejection_code search term: the view translates a null burden summary rejection code into the sentinel value BURDEN_NEW_UNPROC so that unprocessed burden records surface alongside explicit cost exceptions.

Underlying Base Objects

The documented base objects referenced by this view are:

• PA_COST_DISTRIBUTION_LINES_ALL — the primary driver table supplying cost lines, amounts, transfer status, and rejection reasons.
• PA_EXPENDITURE_ITEMS_ALL — provides task, expenditure type, date, vendor, and document linkage information.
• PA_IMPLEMENTATIONS_ALL — contributes period-comparison and set-of-books context.
• GL_PERIOD_STATUSES — supplies the GL period name and status used to evaluate the same-period condition.
• PA_EXCEPTION_REASONS_PUB — a package invoked through GET_EXCEPTION_TEXT to resolve human-readable exception text and corrective action.
• PA_EXPENDITURES_UTILS — supplies GetOrgTlName for the operating unit name.
• PA_PROJECTS_ALL and PA_PROJECT_TYPES_ALL — project and classification context.
• XLA_EVENTS — subledger accounting event linkage.
• DUAL — used with a UNION ALL construct to generate an exception type driver (COST_EXC and BURD_EXC).

The join between PA_EXPENDITURE_ITEMS_ALL and PA_COST_DISTRIBUTION_LINES_ALL on expenditure item ID forms the spine of the view, with the exception rules applied through a decode across the two exception types.

Key Columns

• EXPENDITURE_ID / EXPENDITURE_ITEM_ID / TASK_ID — identity of the project expenditure being distributed.
• EXPENDITURE_ITEM_DATE / GL_DATE / PERIOD_NAME — date and accounting period context.
• COST_DISTRIBUTION_LINE_NUM — the distribution line within the expenditure item.
• TRANSFER_STATUS_CODE / TRANSFER_REJECTION_REASON — the GL transfer state and the raw rejection reason.
• AMOUNT / PROJECT_AMOUNT / DENOM_AMOUNT / DENOM_CURRENCY_CODE / QUANTITY — raw cost and denominated amounts.
• EXCEPTION_REASON / CORRECTIVE_ACTION — decoded text from PA_EXCEPTION_REASONS_PUB; for burden rows the code passed is BURDEN_SUM_REJECTION_CODE, or BURDEN_NEW_UNPROC when that code is null.
• CDL_EXCEPTION_TYPE — indicates whether the row is a cost exception or a burden exception.
• VENDOR_ID, INVOICE_ID, INVOICE_LINE_NUMBER, document_* columns — supplier invoice linkage for cost rows originating from Payables.
• SAME_PA_GL_PERIOD, SET_OF_BOOKS_ID, ORG_ID — implementation and operating unit context.

Common Use Cases and Queries

The view is commonly used to list all distributions blocked from the GL interface and to isolate burden summary rejections. A typical query is:

• SELECT expenditure_item_id, cost_distribution_line_num, transfer_status_code, exception_reason, corrective_action FROM apps.pa_gl_cost_except_sum_v WHERE transfer_rejection_reason IS NOT NULL;
• Filtering by burden: add WHERE cdl_exception_type = 'B' to review burden summary rejections such as BURDEN_NEW_UNPROC.
• Reconciling to Projects: join back to PA_EXPENDITURE_ITEMS_ALL or PA_PROJECTS_ALL using TASK_ID for reporting against a project or task.

Because the exception text is derived dynamically through the package, results reflect the current setup of exception reasons and corrective actions, making the view suitable for operational close monitoring rather than historical archiving.