Results for “psp_auto_accts”

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

Overview

PSP_AUTO_ACCTS is a Labor Distribution (PSP) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores one record for every auto-population expenditure type and General Ledger account segment that has defined rules. In practice, the table acts as the master definition of automatic accounting combinations used by Oracle Labor Distribution when it derives charge accounts for labor costs without manual entry. Each row ties a specific expenditure type together with a General Ledger account segment and the rule metadata that governs its automatic population.

Within the PSP schema, the table is owned by PSP and is documented with 16 columns. The relationship metadata mined from its foreign key structure classifies PSP_AUTO_ACCTS as satellite-leaning. Under a Data Vault modeling suggestion, this indicates the table behaves primarily as a descriptive satellite attached to a parent accounting entity, rather than as a pure hub of business keys or a link resolving many-to-many relationships. Its descriptive attributes—expenditure type, segment number, natural account, and active date ranges—reinforce that characterization.

Key Information Stored

PSP_AUTO_ACCTS carries a surrogate primary key, ACCT_ID, defined through the ACCT_ID_PK constraint and also enforced by the PSP_AUTO_ACCTS_PK constraint. The unique index PSP_AUTO_ACCTS_U1 on ACCT_ID represents the documented business-key candidate, meaning ACCT_ID functions both as the technical identifier and the unique business reference for an auto-account definition.

The most significant descriptive columns include:

• ACCT_ID — the surrogate and unique business key for the auto-account record.
• ACCT_SEQ_NUM — sequencing value used to order records within a rule or account set.
• ACCT_TYPE — classifies the accounting record type for auto-population purposes.
• PERIOD_TYPE — the period basis against which the account rule applies.
• EXPENDITURE_TYPE — the expenditure type that triggers automatic account population.
• SEGMENT_NUM — identifies the General Ledger account segment being populated.
• NATURAL_ACCOUNT — the natural account segment value assigned by the rule.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range during which the rule is active.
• SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS, scoping the rule to a ledger.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the record to a business group.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard Oracle EBS audit columns.

Common Use Cases and Queries

Administrators and technical consultants query PSP_AUTO_ACCTS to verify which accounts are automatically populated for a given expenditure type, to audit effective-dated rules, and to reconcile Labor Distribution account derivation against General Ledger setups. A common pattern retrieves active rules for a ledger and expenditure type:

• SELECT acct_id, expenditure_type, segment_num, natural_account, start_date_active, end_date_active FROM psp_auto_accts WHERE set_of_books_id = :ledger_id AND expenditure_type = :exp_type AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
• Join to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID to report ledger name alongside each auto-account definition.
• Join to HR_ALL_ORGANIZATION_UNITS on BUSINESS_GROUP_ID to resolve the business group context.
• Aggregate by NATURAL_ACCOUNT to confirm the distribution of automatic account assignments across expenditure types.

Because PSP_AUTO_PARAMS and PSP_AUTO_RULES reference this table through ACCT_ID, reporting queries frequently traverse from rule or parameter records back to PSP_AUTO_ACCTS to obtain the underlying account segment details.

Related Objects

The following objects are the most significant to PSP_AUTO_ACCTS, based on documented foreign key relationships:

• GL_SETS_OF_BOOKS — referenced by PSP_AUTO_ACCTS.SET_OF_BOOKS_ID; the ledger owning the account definition.
• HR_ALL_ORGANIZATION_UNITS — referenced by PSP_AUTO_ACCTS.BUSINESS_GROUP_ID; the business group context.
• PSP_AUTO_PARAMS — references PSP_AUTO_ACCTS.ACCT_ID; parameter records tied to an auto-account.
• PSP_AUTO_RULES — references PSP_AUTO_ACCTS.ACCT_ID; rule records that depend on the account definition.

Together these relationships position PSP_AUTO_ACCTS as the central definition point linking Labor Distribution automatic accounting rules to the General Ledger and HR organizational structures.