Results for “reason_for_adjustment”

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

Overview

PSP_ADJUSTMENT_CONTROL_TABLE is a Labor Distribution (PSP) transaction control table in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM repository, it stores one record for each batch adjusted, functioning as the batch-level header for the Labor Distribution adjustment process. Every time a set of payroll or labor cost distributions is adjusted — whether to correct an employee's charging instructions, redistribute costs across departments, or reverse an erroneous charge — a corresponding control row is created here to identify, describe, and govern that batch.

The table resides in the PSP schema and is classified as VALID. Its primary key is PSP_ADJUSTMENT_CONTROL_PK, defined on the ADJUSTMENT_BATCH_NAME column. From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning: it carries descriptive context and audit attributes around a business key (the batch name), reference relationships to general ledger and HR organization entities, and is itself referenced by detail and history tables. It is not a pure hub, because the batch name is a process-generated identifier rather than a durable enterprise business key, but it functions as the anchor of the adjustment batch aggregate.

Key Information Stored

The table comprises 38 documented columns. The most operationally significant are enumerated below.

• ADJUSTMENT_BATCH_NAME — the primary key column (PSP_ADJUSTMENT_CONTROL_PK) and the batch identifier used throughout Labor Distribution. It is also the target of foreign keys from the adjustment line tables.
• REASON_FOR_ADJUSTMENT — the user-supplied justification recorded for the batch.
• APPROVER_ID, APPROVAL_DATE, ADJUST_BY — the approval and ownership trail for the adjustment.
• COMMENTS — free-form notes entered by the adjusting user.
• SET_OF_BOOKS_ID — the ledger context; foreign key to GL_SETS_OF_BOOKS.
• BUSINESS_GROUP_ID — the HR business group context; foreign key to HR_ALL_ORGANIZATION_UNITS.
• PERSON_ID, ASSIGNMENT_ID, ELEMENT_TYPE_ID — the employee, assignment, and element scope of the adjustment.
• DISTRIBUTION_START_DATE, DISTRIBUTION_END_DATE — the effective range of the redistributed distributions.
• CURRENCY_CODE — the currency in which the adjustment is expressed.
• GL_POSTING_OVERRIDE_DATE, GMS_POSTING_OVERRIDE_DATE — override dates controlling when the adjustment posts to General Ledger and Grants Management.
• VOID — the void indicator for a batch.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Two unique indexes are documented as business-key candidates: PSP_ADJUSTMENT_CONTROL_U1 on ADJUSTMENT_BATCH_NAME (also the primary key) and PSP_ADJUSTMENT_CONTROL_U2 on the composite of CREATION_DATE, ADJUSTMENT_BATCH_NAME, CREATED_BY, APPROVER_ID, and ASSIGNMENT_ID, which enforces uniqueness across the batch's creation, approval, and assignment context.

Common Use Cases and Queries

The table is principally used to report and reconcile Labor Distribution adjustments, to drive the posting of adjustment batches to General Ledger and Grants, and to audit who approved which batch and why. It joins directly to its detail lines on the batch name, and to the ledger and organization contexts on the referenced identifiers.

• List all adjustments for a ledger and business group: select ADJUSTMENT_BATCH_NAME, REASON_FOR_ADJUSTMENT, APPROVER_ID, APPROVAL_DATE from PSP_ADJUSTMENT_CONTROL_TABLE where SET_OF_BOOKS_ID = :p_sob and BUSINESS_GROUP_ID = :p_bg and VOID = 'N'.
• Trace the detail lines of a batch: join PSP_ADJUSTMENT_LINES on BATCH_NAME = ADJUSTMENT_BATCH_NAME.
• Audit adjustment activity over a date range using CREATION_DATE and LAST_UPDATE_DATE, optionally filtering on ADJUST_BY or APPROVER_ID.
• Report on posting overrides by selecting GL_POSTING_OVERRIDE_DATE and GMS_POSTING_OVERRIDE_DATE for batches pending GL or GMS transfer.
• Identify voided batches for reconciliation or cleanup checks using the VOID flag.

Related Objects

• PSP_ADJUSTMENT_LINES.BATCH_NAME → PSP_ADJUSTMENT_CONTROL_TABLE — the active adjustment detail lines belonging to each control record.
• PSP_ADJUSTMENT_LINES_HISTORY.ADJUSTMENT_BATCH_NAME → PSP_ADJUSTMENT_CONTROL_TABLE — the historical adjustment line records retained for the batch.
• GL_SETS_OF_BOOKS — referenced through SET_OF_BOOKS_ID, supplying the ledger definition for the adjustment.
• HR_ALL_ORGANIZATION_UNITS — referenced through BUSINESS_GROUP_ID, supplying the HR business group context.

These relationships confirm the table's role as the batch-level anchor of the Labor Distribution adjustment model, joined to GL and HR reference data and to both live and historical adjustment lines.