Search Results pspbv_generate_cost_dist_lines

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

• DISTRIBUTION_LINE_ID — Primary identifier for the distribution line.
• DEFAULT_REASON_CODE — Indicates why a line was defaulted; central to diagnosing fallback account assignment.
• GL_OR_PROJECT_RELATED (listed as GL_PROJECT_FLAG in the view text) — Distinguishes general-ledger versus project-related distribution.
• PRE_DISTRIBUTION_RUN_FLAG — Marks whether the line was generated before the distribution run.
• DISTRIBUTION_DATE and EFFECTIVE_DATE — Dates governing when the distribution applies.
• DISTRIBUTION_AMOUNT — The amount allocated on the line.
• _LA:STATUS_CODE — Derived status meaning from PSP_LOOKUPS (PSP_STATUS_CODE).
• _LA:REVERSAL_ENTRY_FLAG — Derived Yes/No meaning from GL_LOOKUPS for reversal entries.
• SUSPENSE_ORG_ACCOUNT_ID, DEFAULT_ORG_ACCOUNT_ID, ELEMENT_ACCOUNT_ID — Account and organization references used in posting.
• EFFORT_REPORT_ID, VERSION_NUMBER, SUMMARY_LINE_ID, SCHEDULE_LINE_ID, PAYROLL_SUB_LINE_ID — Links back to effort reporting, versions, summaries, schedules, and payroll sub-lines.
• BUSINESS_GROUP_ID, SET_OF_BOOKS_ID — Multi-organization and ledger context.

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.