Search Results default_reason_code




Overview
Explore in AI Chat

Overview

PSPBV_GENERATE_COST_DIST_LINES is a read-only view in the Oracle EBS Labor Distribution (PSP) module. It presents the cost distribution lines that are produced when Labor Distribution processes effort and payroll data to allocate labor costs to the correct accounts, organizations, and projects. The view acts as a reporting and integration surface for the distribution results generated by Labor Distribution runs, exposing the identifiers, amounts, dates, and status information associated with each generated line.

Because the view is defined with a READ ONLY clause, it is intended strictly for query and reporting, not for data maintenance. Its primary role is to support reconciliation, audit, and downstream interfaces that need a denormalized, business-friendly representation of distribution output. Notably, it directly exposes the DEFAULT_REASON_CODE column, which is the attribute most commonly searched for by users reconciling why a particular distribution line was assigned to a default (fallback) account rather than the originally intended one. The view also derives lookup meanings for status and reversal flags through _LA (List of Values Attribute) constructs, allowing consumers to display descriptive values instead of raw codes.

Underlying Base Objects

Per the ETRM metadata, the view is defined over a single base table: PSP_DISTRIBUTION_LINES, aliased as PDL. The view is essentially a projection of selected columns from that table, with two columns resolved through lookup joins embedded as _LA elements rather than physical joins written in the view text. The documented base-object reference list is not populated in ETRM, but the view text unambiguously identifies PSP_DISTRIBUTION_LINES as the source. The view does not document any additional joined tables, so relationships to organizations, accounting flexfields, or projects are carried only implicitly through the exposed identifier columns such as DEFAULT_ORG_ACCOUNT_ID, ELEMENT_ACCOUNT_ID, SUSPENSE_ORG_ACCOUNT_ID, EFFORT_REPORT_ID, and SET_OF_BOOKS_ID. Because it is read-only, no DML is possible against it, and any corrections must be made through the Labor Distribution processes that populate PSP_DISTRIBUTION_LINES.

Key Columns

Common Use Cases and Queries

A frequent use case is investigating defaulted distribution lines, driven by the DEFAULT_REASON_CODE search term. The following query lists defaulted lines with their amounts and status:

SELECT DISTRIBUTION_LINE_ID, DEFAULT_REASON_CODE, DISTRIBUTION_AMOUNT, DISTRIBUTION_DATE, "_LA:STATUS_CODE" STATUS FROM PSPBV_GENERATE_COST_DIST_LINES WHERE DEFAULT_REASON_CODE IS NOT NULL AND SET_OF_BOOKS_ID = :p_sob ORDER BY DISTRIBUTION_DATE;

Another scenario reconciles GL-related versus project-related distribution by business group:

SELECT BUSINESS_GROUP_ID, GL_OR_PROJECT_RELATED, SUM(DISTRIBUTION_AMOUNT) TOTAL FROM PSPBV_GENERATE_COST_DIST_LINES GROUP BY BUSINESS_GROUP_ID, GL_OR_PROJECT_RELATED;

Analysts also trace suspense postings and reversals, filtering on SUSPENSE_ORG_ACCOUNT_ID or the derived reversal flag, and join EFFORT_REPORT_ID back to effort reporting tables for audit. Because the view is read-only, all such queries are safe for reporting and interface extraction.