Results for “pre_distribution_run_flag”

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

Overview

PSP_DISTRIBUTION_LINES is a core table in the PSP (Labor Distribution) product within Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. The table stores distributed Oracle and non-Oracle payroll sublines that have not yet been transferred to General Ledger or Grants Accounting. In practical terms, it functions as the staging and holding area between payroll costing/distribution processing and the final accounting transfer, capturing the detailed labor distribution results—including amount, account, project, award, and organization attributes—before those results are pushed downstream to GL or Grants Accounting.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this object is best classified as a link. It sits at the intersection of payroll sub-lines, effort reports, schedule lines, summary lines, element type accounts, default labor schedules, and business group organizations, making it a transaction-level connective object rather than a pure hub or descriptive satellite.

Key Information Stored

The table is documented with 47 columns. The most significant include:

• DISTRIBUTION_LINE_ID — the surrogate primary key (PSP_DISTRIBUTION_LINES_PK, unique index PSP_DISTRIBUTION_LINES_U1).
• DISTRIBUTION_DATE and EFFECTIVE_DATE — the accounting/distribution date and the effective date of the line.
• DISTRIBUTION_AMOUNT — the distributed monetary value for the sub-line.
• STATUS_CODE, DEFAULT_REASON_CODE, and SUSPENSE_REASON_CODE — processing status and the reasons a line was defaulted or placed in suspense.
• PAYROLL_SUB_LINE_ID, EFFORT_REPORT_ID, SCHEDULE_LINE_ID, and SUMMARY_LINE_ID — the primary business-key foreign references linking the distribution to its source payroll, effort, schedule, and summary records.
• ELEMENT_ACCOUNT_ID and ORG_SCHEDULE_ID — the element type account and default labor schedule used to derive the distribution.
• SET_OF_BOOKS_ID and BUSINESS_GROUP_ID — the ledger and HR business group context.
• GL_PROJECT_FLAG, REVERSAL_ENTRY_FLAG, and PRE_DISTRIBUTION_RUN_FLAG — control flags governing GL transfer, reversals, and pre-distribution processing.
• AUTO_GL_CODE_COMBINATION_ID and AUTO_EXPENDITURE_TYPE — automatically derived accounting code combination and expenditure type.
• VERSION_NUM — version tracking, tied to effort reports.

Surrogate key candidates are limited to DISTRIBUTION_LINE_ID; the remaining identifiers (PAYROLL_SUB_LINE_ID, EFFORT_REPORT_ID, SCHEDULE_LINE_ID, SUMMARY_LINE_ID, SET_OF_BOOKS_ID, ELEMENT_ACCOUNT_ID, ORG_SCHEDULE_ID, BUSINESS_GROUP_ID) are foreign-key references.

Common Use Cases and Queries

Typical scenarios include auditing undistributed payroll amounts, validating suspense items, reconciling effort versus payroll distribution, and investigating lines that failed GL or Grants transfer. A representative query retrieves pending distributions by status and ledger:

• SELECT distribution_line_id, distribution_amount, status_code, suspense_reason_code FROM psp_distribution_lines WHERE status_code = :status AND set_of_books_id = :sob;
• Joining to PSP_PAYROLL_SUB_LINES via PAYROLL_SUB_LINE_ID to trace back to the originating payroll sub-line.
• Joining to PSP_EFFORT_REPORTS via EFFORT_REPORT_ID and VERSION_NUM to compare effort-reported versus distributed amounts.
• Grouping DISTRIBUTION_AMOUNT by SET_OF_BOOKS_ID for transfer-to-GL reconciliation.
• Filtering on SUSPENSE_REASON_CODE or DEFAULT_REASON_CODE to isolate exceptions requiring correction.

Related Objects

The most significant related tables, based on the documented foreign keys, are:

• PSP_PAYROLL_SUB_LINES — joined on PAYROLL_SUB_LINE_ID.
• PSP_EFFORT_REPORTS — joined on EFFORT_REPORT_ID and VERSION_NUM.
• PSP_SCHEDULE_LINES — joined on SCHEDULE_LINE_ID.
• PSP_SUMMARY_LINES — joined on SUMMARY_LINE_ID.
• GL_SETS_OF_BOOKS — joined on SET_OF_BOOKS_ID.
• PSP_ELEMENT_TYPE_ACCOUNTS — joined on ELEMENT_ACCOUNT_ID.
• PSP_DEFAULT_LABOR_SCHEDULES — joined on ORG_SCHEDULE_ID.
• HR_ALL_ORGANIZATION_UNITS — joined on BUSINESS_GROUP_ID.

These relationships establish PSP_DISTRIBUTION_LINES as the central link between payroll costing, effort reporting, and downstream General Ledger and Grants Accounting processing.