Results for “psp_enc_lines_u1”

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

Overview

PSP.PSP_ENC_LINES is the transactional base table that stores individual encumbrance lines generated by the Oracle E-Business Suite Create Encumbrance and Update Encumbrance processes within the Oracle Labor Distribution (PSP) module. Each row represents a single debit or credit position against a payroll element, organization account, project, award, or general ledger combination, derived from payroll costing results and labor schedule data. The table is owned by the PSP schema, resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and is mapped in FND Design Data as PSP.PSP_ENC_LINES. The documented physical schema at the ETRM 12.2.2 level (also applicable to 12.1.1) contains 61 columns.

From a Data Vault modeling perspective, the ETRM metadata classifies this object heuristically as a link table. This is consistent with its structure: it sits at the intersection of payroll, element, organization, project, award, and general ledger reference chains, resolving many-to-many relationships between encumbrance controls, summary lines, and cost distribution entities rather than holding a single immutable business entity.

Key Information Stored

The surrogate primary key is ENC_LINE_ID, enforced by the unique index PSP_ENC_LINES_U1 (the business-key candidate identified in the metadata) and backed by primary key constraint PSP_ENC_LINES_PK. The most significant columns include:

• ENC_LINE_ID — system-generated primary key for each encumbrance line.
• ENC_CONTROL_ID — foreign key to PSP_ENC_CONTROLS, grouping lines under a single encumbrance control run.
• ENC_SUMMARY_LINE_ID — foreign key to the encumbrance summary lines, tying detail to summary.
• ENCUMBRANCE_DATE, ENC_START_DATE, ENC_END_DATE — the effective and accrual window for the encumbrance.
• ENCUMBRANCE_AMOUNT — the monetary amount carried by the line.
• DR_CR_FLAG — D for Debit, C for Credit.
• ENC_LINE_TYPE — N for New, U for Update, reflecting the originating process.
• PERSON_ID / ASSIGNMENT_ID — references into PER_PEOPLE_F and PER_ASSIGNMENTS_F.
• PAYROLL_ID / PAYROLL_ACTION_ID — links to payroll and payroll action context.
• GL_CODE_COMBINATION_ID — the GL accounting flexfield target (with ORIG_GL_CODE_COMBINATION_ID preserving the original).
• PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID — project/costing attributes.
• BUSINESS_GROUP_ID — HR business group foreign key.
• SET_OF_BOOKS_ID — the ledger under which the encumbrance is posted.
• STATUS_CODE, CHANGE_FLAG — processing-state indicators.

Common Use Cases and Queries

Labor Distribution administrators and financial analysts query PSP_ENC_LINES to reconcile encumbrances against payroll, validate GL postings, and investigate suspense account activity. Typical patterns include:

• Retrieving all lines for a control run: SELECT * FROM psp_enc_lines WHERE enc_control_id = :p_control_id;
• Summarizing debit/credit activity by ledger: SELECT set_of_books_id, gl_code_combination_id, SUM(DECODE(dr_cr_flag,'D',encumbrance_amount,-encumbrance_amount)) FROM psp_enc_lines GROUP BY set_of_books_id, gl_code_combination_id;
• Isolating only updated lines: SELECT * FROM psp_enc_lines WHERE enc_line_type = 'U';
• Identifying suspense postings via SUSPENSE_REASON_CODE and SUSPENSE_ORG_ACCOUNT_ID.
• Joining to PER_PEOPLE_F and PER_ASSIGNMENTS_F for labor-cost reporting.

Reporting typically joins to encumbrance controls, payroll actions, and GL code combinations to produce audit trails for period-end close.

Related Objects

The following tables are directly referenced through documented foreign keys and are the most significant dependencies:

• PSP_ENC_CONTROLS via ENC_CONTROL_ID — header for the encumbrance run.
• PSP_ENC_SUMMARY_LINES via ENC_SUMMARY_LINE_ID — summarized roll-up of detail lines.
• PSP_ENC_PAYROLLS via PAYROLL_ID — source payroll for the encumbrance.
• PAY_PAYROLL_ACTIONS via PAYROLL_ACTION_ID — payroll action context.
• PSP_DEFAULT_LABOR_SCHEDULES via ORG_SCHEDULE_ID — labor distribution schedules.
• PSP_ELEMENT_TYPE_ACCOUNTS via ELEMENT_ACCOUNT_ID — element-to-account mapping.
• IGF_AW_AWARD_ALL via AWARD_ID — grant award linkage.
• PER_TIME_PERIODS via TIME_PERIOD_ID — payroll period context.
• PER_PEOPLE_F, PER_ASSIGNMENTS_F — person and assignment references.
• HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID — HR business group.

Supporting indexes PSP_ENC_LINES_N1 (ENC_CONTROL_ID, PERSON_ID, ASSIGNMENT_ID), PSP_ENC_LINES_N2 (ENC_SUMMARY_LINE_ID), and PSP_ENC_LINES_N3 (PAYROLL_ACTION_ID) optimize the principal access paths used by concurrent processes and reports.