Results for “error_description”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSP_DISTRIBUTION_INTERFACE_V is a PL/SQL-based view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the PSP (Labor Distribution) product family and is defined over the PSP_DISTRIBUTION_INTERFACE base table. The view presents labor distribution interface records in a denormalized, human-readable form by resolving internal identifiers — payroll, period, person, assignment, element, project, task, award, organization, and status codes — into descriptive names and numbers through calls to the PSP_GENERAL package.

Its primary role is to support reporting, reconciliation, and integration diagnostics for labor distribution rows staged for costing and transfer into Oracle Projects, Payroll, and the General Ledger. Because the underlying table stores surrogate keys, the view is the preferred reporting layer for users and concurrent programs that require descriptive attributes rather than raw IDs. Status and lookup code columns are also decoded, which makes error review and audit reporting practical.

Users frequently search for time_period_name in connection with this view because the descriptive period label is exposed as PERIOD_NAME rather than as a column literally named TIME_PERIOD_NAME. Report authors and query developers typically need to know that the period label is derived from TIME_PERIOD_ID via PSP_GENERAL.GET_PERIOD_NAME.

Underlying Base Objects

The documented base objects referenced by the view are:

• PSP_DISTRIBUTION_INTERFACE (SYNONYM) — the driving table; all rows in the view originate from this interface table, aliased as A.
• PSP_GENERAL (PACKAGE) — provides the derived descriptive functions, including GET_PAYROLL_NAME, GET_PERIOD_NAME, GET_PERSON_NAME, GET_ASSIGNMENT_NUM, GET_ELEMENT_NAME, GET_PROJECT_NUMBER, GET_SOURCE_TYPE, GET_ORG_NAME, GET_TASK_NUMBER, GET_AWARD_NUMBER, GET_STATUS_DESCRIPTION, and GET_ERROR_DESCRIPTION.
• PSP_ORGANIZATION_ACCOUNTS_PKG (PACKAGE) — referenced in support of organization and account resolution logic associated with labor distribution processing.

The view is tightly coupled to the PSP_GENERAL package. Changes to the signature or behavior of the packaged functions would affect the descriptive output of the view, so upgrades and patches to the PSP product should be validated against dependent reports and interfaces.

Key Columns

• PAYROLL_ID / PAYROLL_NAME — payroll identifier and its descriptive name (GET_PAYROLL_NAME).
• TIME_PERIOD_ID / PERIOD_NAME — the period identifier and the derived period label users search for as time_period_name (GET_PERIOD_NAME).
• PERSON_ID / PERSON, ASSIGNMENT_ID / ASSIGNMENT_NUMBER — employee and assignment identification.
• ELEMENT_TYPE_ID / ELEMENT_NAME — element being distributed.
• DISTRIBUTION_AMOUNT, DISTRIBUTION_DATE, DR_CR_FLAG — monetary amount, effective date, and debit/credit indicator.
• GL_CODE_COMBINATION_ID, SET_OF_BOOKS_ID — General Ledger accounting and ledger context.
• PROJECT_ID / PROJECT_NAME, TASK_ID / TASK_NAME, AWARD_ID / AWARD_NAME, EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_NAME — Projects and Grants context.
• SOURCE_CODE / SOURCE_TYPE, STATUS_CODE / STATUS_DESCRIPTION, ERROR_CODE / ERROR_DESCRIPTION — origin, processing status, and error detail.
• BATCH_NAME, GL_POSTING_OVERRIDE_DATE, GMS_POSTING_OVERRIDE_DATE — batch identification and posting override dates.
• ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY, BUSINESS_GROUP_ID — descriptive flexfield and business group context.

Common Use Cases and Queries

Typical scenarios include reviewing pending labor distribution rows before costing, reconciling interface data to payroll and Projects, and diagnosing rows in error status. The following query lists period-labeled distribution rows for an employee and status:

SELECT period_name, payroll_name, person, assignment_number, element_name, distribution_amount, distribution_date, status_description FROM psp_distribution_interface_v WHERE person_id = :person_id AND status_code = 'E' ORDER BY distribution_date;

To reconcile amounts by period and project:

SELECT period_name, project_name, SUM(distribution_amount) amt FROM psp_distribution_interface_v WHERE set_of_books_id = :sob_id GROUP BY period_name, project_name ORDER BY period_name;

Because PERIOD_NAME is computed through PSP_GENERAL, filtering directly on a literal period string will invoke the function for each row; joining to a period table keyed by TIME_PERIOD_ID is more efficient for large volumes.