Search Results oe_ak_acc_rules_v




Overview
Explore in AI Chat

Overview

OE_AK_ACC_RULES_V is a view owned by the APPS schema in Oracle E-Business Suite, catalogued under the Order Management (ONT) product family. It exposes a filtered, denormalized projection of accounting rules that are valid for use within Order Management processing. The object is classified as a VIEW with VALID status, meaning it is a supported, runtime-resolvable database object that reporting tools, concurrent programs, and integration interfaces may query directly rather than accessing the underlying base table.

Its functional purpose is to present only those accounting rule definitions that are currently active and that belong to the set of rule types relevant to Order Management revenue and receivable processing. Because it hides inactive and out-of-scope rules, it serves as a stable, self-documenting reference for downstream consumers that need a clean list of eligible accounting rules without replicating the filtering logic themselves. In this respect the view acts as a semantic layer over receivables rule configuration, narrowing a broader configuration table to the subset meaningful to order capture and order fulfillment flows.

Underlying Base Objects

The view is defined over a single referenced base object, RA_RULES, accessed through a synonym in the APPS schema. RA_RULES is the Receivables rules table that stores accounting rule definitions, including their name, descriptive text, rule type, and lifecycle status. OE_AK_ACC_RULES_V does not join additional tables; instead it derives its content entirely by applying a restricted predicate filter to RA_RULES.

The filter is expressed as STATUS = 'A' together with a TYPE IN restriction limited to the values 'A', 'ACC_DUR', 'PP_DR_ALL', and 'PP_DR_PP'. The STATUS predicate restricts output to active rules, excluding rows that have been end-dated, disabled, or otherwise marked inactive. The TYPE predicate isolates the rule categories that Order Management recognizes for accounting generation, spanning standard accounting rules and the deferred or proportional revenue recognition variants captured by the enumerated type codes. Because the view is read-only and inherits its columns from RA_RULES, it imposes no additional storage and reflects base-table changes immediately.

Key Columns

  • ACCOUNTING_RULE_ID — The unique identifier of the accounting rule, corresponding to the underlying RULE_ID column in RA_RULES. This is the primary key used for joins to order, line, or agreement data.
  • ACCOUNTING_RULE — The user-visible rule name, mapped from the NAME column, used for display in order entry and reporting.
  • DESCRIPTION — Free-text narrative describing the accounting rule and its intended revenue or receivables treatment.
  • RULE_TYPE — The categorization code derived from TYPE, distinguishing standard accounting rules from duration-based, all-period proportional, and proportional-period variants.

Common Use Cases and Queries

Typical scenarios include validating that a rule selected on an order line is active and permitted, populating list-of-values or lookup queries, feeding integration extracts that mirror order accounting configuration, and reconciling order-level revenue schedules against configured rules. The following query lists all eligible accounting rules sorted by name:

  • SELECT accounting_rule_id, accounting_rule, description, rule_type FROM oe_ak_acc_rules_v ORDER BY accounting_rule;
  • SELECT accounting_rule_id, accounting_rule FROM oe_ak_acc_rules_v WHERE rule_type = 'ACC_DUR';
  • SELECT r.rule_type, COUNT(*) FROM oe_ak_acc_rules_v r GROUP BY r.rule_type;

Because the view already enforces active status and the permitted type set, these queries require no additional filtering to remain consistent with Order Management's own rule validation logic.