Results for “rule_definition”

16 results




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

Overview

PSP_AUTO_RULES is a table in the PSP (Labor Distribution) module of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. It stores the rules that govern the automatic population of expenditure types or General Ledger account segments when labor distribution and cost allocation processes execute. In practical terms, the table acts as the rule repository that drives automated account and expenditure type derivation, linking each rule to an accounting context defined in PSP_AUTO_ACCTS.

The table resides in the PSP schema and is documented with nine columns. Its primary key, PSP_AUTO_RULES_PK, is defined on RULE_ID, which is also enforced by the unique index PSP_AUTO_RULES_U2. A second unique index, PSP_AUTO_RULES_U1, is defined on ACCT_ID, indicating that ACCT_ID is a business-key candidate. A foreign key relationship connects PSP_AUTO_RULES.ACCT_ID to PSP_AUTO_ACCTS, anchoring every rule to a parent accounting definition.

Under the heuristic Data Vault classification mined from the foreign key structure, PSP_AUTO_RULES is described as satellite-leaning. This suggests that, in a dimensional or Data Vault model, the table is best modeled as a satellite attached to the PSP_AUTO_ACCTS hub or link, carrying the descriptive rule attributes (CALCULATOR_RULE and RULE_DEFINITION) that change over time. This classification is a modeling suggestion, not a physical constraint in the EBS schema.

Key Information Stored

The columns of PSP_AUTO_RULES support both identity and rule logic. The most significant are:

  • RULE_ID — Surrogate primary key (PSP_AUTO_RULES_PK) and the unique business identifier enforced by PSP_AUTO_RULES_U2; uniquely identifies each rule record.
  • ACCT_ID — Foreign key to PSP_AUTO_ACCTS and the unique business-key candidate enforced by PSP_AUTO_RULES_U1; associates the rule with its accounting definition.
  • CALCULATOR_RULE — Holds the calculator or rule type driving the automated population logic.
  • RULE_DEFINITION — Stores the actual definition or expression of the rule used to derive the expenditure type or GL account segment.
  • LAST_UPDATE_DATE — Audit timestamp of the most recent change to the row.
  • LAST_UPDATED_BY — User or process that performed the last update.
  • LAST_UPDATE_LOGIN — Login session associated with the last update, supporting audit traceability.
  • CREATED_BY — User or process that created the rule record.
  • CREATION_DATE — Timestamp when the rule was originally created.

The audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) follow the standard EBS WHO-column convention and are present on virtually all transactional and setup tables.

Common Use Cases and Queries

Typical scenarios include auditing which rules exist for a given accounting definition, tracing the derivation of an expenditure type or GL segment, and reporting the rule population logic for compliance or configuration review. A standard join retrieves the parent accounting context:

  • SELECT r.RULE_ID, r.ACCT_ID, r.CALCULATOR_RULE, r.RULE_DEFINITION FROM PSP.PSP_AUTO_RULES r, PSP.PSP_AUTO_ACCTS a WHERE r.ACCT_ID = a.ACCT_ID;
  • Configuration review: SELECT * FROM PSP.PSP_AUTO_RULES WHERE ACCT_ID = :acct_id ORDER BY RULE_ID;
  • Audit query: SELECT RULE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM PSP.PSP_AUTO_RULES WHERE TRUNC(LAST_UPDATE_DATE) >= TRUNC(SYSDATE) - 7;
  • Rule type analysis: SELECT CALCULATOR_RULE, COUNT(*) FROM PSP.PSP_AUTO_RULES GROUP BY CALCULATOR_RULE;

These patterns support setup validation, change tracking, and diagnostics when automated population produces unexpected account or expenditure type assignments.

Related Objects

The most significant related objects are:

  • PSP_AUTO_ACCTS — Parent table referenced by the PSP_AUTO_RULES.ACCT_ID foreign key; supplies the accounting definition each rule belongs to.
  • PSP_AUTO_RULES_PK / PSP_AUTO_RULES_U1 / PSP_AUTO_RULES_U2 — Primary key and unique index constraints enforcing RULE_ID and ACCT_ID uniqueness.
  • PSP labor distribution process logic — Application code that consumes CALCULATOR_RULE and RULE_DEFINITION to populate expenditure types and GL account segments.
  • GL account segment and expenditure type setup tables — Reference targets whose values are populated by the rules defined here.
  • EBS WHO/audit infrastructure — Standard columns integrated with the common audit and concurrency framework.

Together these objects position PSP_AUTO_RULES as the central rule-definition satellite within the Labor Distribution automatic accounting configuration.