Search Results pp_dr_pp




Overview
Explore in AI Chat

Overview

APPS.OE_AK_ACC_RULES_V is a lightweight, read-only Oracle EBS view that exposes a filtered subset of accounting rule definitions stored in the Receivables rules table, RA_RULES. Its purpose is to present only those rules that are currently active (STATUS = 'A') and that belong to one of a small set of rule types relevant to revenue recognition, accounting duration, and the deferred accounting programs used by Order Management and Receivables. In EBS 12.1.1 and 12.2.2 the view retains the same definition and is owned by the APPS schema. The name OE_AK_ACC_RULES_V reflects its membership in the "AK" (accounting/generic rules) family used by Oracle Order Management and related modules to look up eligible accounting rules without scanning the full RA_RULES table.

Underlying Base Objects

The view is defined over a single base object, RA_RULES, accessed through the APPS synonym of the same name. RA_RULES is the Receivables repository for accounting rules, and it stores both the rule identifier and the rule's type. The view performs no joins; it is a filtered projection. The filter restricts rows to those with STATUS = 'A' and a TYPE value belonging to the set ('A', 'ACC_DUR', 'PP_DR_ALL', 'PP_DR_PP'). Because RA_RULES is an Operational Data Store table maintained for lookup and validation, the view inherits any security or grants applied to the base table and relies on the APPS synonym for name resolution.

Key Columns

The view exposes four columns, each mapped directly from RA_RULES:

  • RULE_ID — The primary identifier of the accounting rule. This is the value used by foreign keys elsewhere in the Receivables and Order Management data model to reference a specific rule.
  • NAME — The user-defined, meaningful name of the rule as entered by the setup administrator; typically the label shown in accounting rule lookup forms.
  • DESCRIPTION — The free-form descriptive text attached to the rule, used to document the rule's business intent.
  • TYPE — The rule classification. Within this view the value is one of 'A', 'ACC_DUR', 'PP_DR_ALL', or 'PP_DR_PP'. Note that 'PP_DR_PP' corresponds to the "pp_dr_pp" search term, denoting a deferred accounting rule associated with a percentage-based or program-specific revenue deferral pattern.

Common Use Cases and Queries

The view is commonly used in setup validation, reporting, and integration logic where only active accounting rules of the recognized types should appear. Because it hides inactive rules and irrelevant types, it reduces filter logic in downstream SQL. Typical scenarios include listing available accounting rules for a revenue recognition configuration, confirming whether a specific deferral rule type exists, and joining rule names into reports where RULE_ID is stored. A representative query retrieving all active rules and highlighting the PP_DR_PP type is:

SELECT rule_id, name, description, type
FROM apps.oe_ak_acc_rules_v
ORDER BY type, name;

To isolate the deferred program rules referenced by the "pp_dr_pp" search term:

SELECT rule_id, name, description
FROM apps.oe_ak_acc_rules_v
WHERE type = 'PP_DR_PP';

Because the view is read-only and defined through a synonym, it is safe for use in custom reports and concurrent programs running under the APPS schema in both 12.1.1 and 12.2.2. No changes to the view definition were documented between these releases.