Results for “psp_auto_accts_v”

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

Overview

PSP_AUTO_ACCTS_V is a reporting and inquiry view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PSP (Labor Distribution) product family. It presents automatic accounting rules configuration, combining account generation definitions with their associated rule definitions so that consumers can retrieve both structures in a single query. The view is documented as VALID in both EBS 12.1.1 and 12.2.2 and is treated as a read-only presentation layer over the underlying Labor Distribution automatic account setup tables.

Within Labor Distribution, automatic accounting rules drive the derivation of accounting flexfield combinations for labor distribution transactions, including the assignment of amounts to natural accounts and the determination of whether a given line represents a debit, credit, or other accounting treatment. The ACCT_TYPE column is central to this purpose, since it classifies each automatic accounting line by the type of accounting entry it produces. Because PSP_AUTO_ACCTS_V exposes account-level configuration together with the parent rule definition, it serves as a convenient interface for reporting on how automatic accounting is configured across a business group and set of books, without requiring callers to join the two base tables themselves.

Underlying Base Objects

The view is defined over two base objects, both referenced through synonyms in the APPS schema:

• PSP_AUTO_ACCTS — the driving table. It stores the automatic accounting account lines, keyed by ACCT_ID and sequenced by ACCT_SEQ_NUM.
• PSP_AUTO_RULES — the rule definition table, outer-joined to the account table on ACCT_ID (A.ACCT_ID = B.ACCT_ID(+)).

The outer join is significant: it ensures that automatic account rows are returned even when no matching rule definition exists, with RULE_DEFINITION appearing as null in those cases. The view also exposes ROWID from PSP_AUTO_ACCTS as ROW_ID, and carries the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) inherited from that table.

Key Columns

• ACCT_ID — primary identifier of the automatic accounting record; join key to PSP_AUTO_RULES.
• ACCT_SEQ_NUM — sequence number ordering the account lines within a rule.
• ACCT_TYPE — the accounting type classification for the line; the column most frequently used to filter or group automatic accounting configuration.
• PERIOD_TYPE — the period basis to which the automatic accounting applies.
• EXPENDITURE_TYPE — the expenditure type associated with the automatic accounting line.
• SEGMENT_NUM — identifies the accounting flexfield segment being populated.
• NATURAL_ACCOUNT — the natural account value assigned to the generated combination.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective date range for the account line.
• BUSINESS_GROUP_ID / SET_OF_BOOKS_ID — organizational and ledger context.
• RULE_DEFINITION — the definition text of the associated automatic rule, sourced from PSP_AUTO_RULES.
• ROW_ID — ROWID of the underlying PSP_AUTO_ACCTS row.

Common Use Cases and Queries

The view is typically queried to audit or report automatic accounting setup, to investigate how a particular accounting type is configured, or to reconcile rule definitions against their account lines. Because ACCT_TYPE is the searched attribute, it commonly appears in both the SELECT list and the WHERE clause.

• Listing automatic accounting lines for a ledger: SELECT acct_id, acct_seq_num, acct_type, natural_account FROM psp_auto_accts_v WHERE set_of_books_id = :p_sob_id ORDER BY acct_id, acct_seq_num;
• Filtering by accounting type: SELECT acct_id, acct_type, period_type, expenditure_type, natural_account FROM psp_auto_accts_v WHERE acct_type = :p_acct_type;
• Reviewing rules and their generated accounts: SELECT acct_id, rule_definition, acct_type, segment_num, natural_account FROM psp_auto_accts_v WHERE rule_definition IS NOT NULL;
• Checking currently effective configuration: SELECT acct_id, acct_type, start_date_active, end_date_active FROM psp_auto_accts_v WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE));

As a view, it should be used strictly for query and reporting purposes; all maintenance of automatic accounting data must be performed against the base tables through the supported Labor Distribution application flows.