Search Results aso_apr_rules




Overview
Explore in AI Chat

Overview

ASO_APR_RULES is a table in the ASO (Order Capture) module of Oracle E-Business Suite, owned by the ASO schema. It stores the definition of approval rules used by Oracle Order Capture and Order Management to determine how order and quote objects are routed and evaluated during the approval process. Each row represents a configured approval rule, capturing the linkage between an approval rule, its underlying rule definition, the action to execute when the rule fires, and the object type to which the rule applies.

In Oracle EBS 12.1.1 and 12.2.2, this table is a core configuration and runtime construct for the order approval workflow. Approval rules are typically maintained through the Oracle Order Management setup and are consumed by the approval engine to decide whether a given order, quote, or negotiation requires approval and who must approve it.

Regarding modeling classification, the metadata's heuristic Data Vault classification places this table as standalone, with a single foreign key to FND_SECURITY_GROUPS. As a modeling suggestion, this object behaves like a reference or configuration hub (keyed on RULE_ID) with satellite attributes (timestamps, audit columns), rather than a transactional link table.

Key Information Stored

The table contains 32 documented columns in 12.2.2. The most significant are:

  • RULE_ID — the surrogate primary key, enforced by unique index ASO_APR_RULES_U1. This is the business-key candidate for the table.
  • OAM_RULE_ID — reference to the underlying approval rule definition (Oracle Approvals Management). This links the ASO approval rule to its OAM rule source.
  • RULE_ACTION_ID — identifies the action to be taken when the approval rule is evaluated and matched.
  • OBJECT_APPROVAL_ID — associates the rule with the object approval configuration (the entity being approved, such as order or quote).
  • SECURITY_GROUP_ID — the foreign key referencing FND_SECURITY_GROUPS, used for multi-organization / security group scoping.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/BC4J framework to detect concurrent updates.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns recording who created and most recently modified the rule and when.
  • CONTEXT — the DFF context column that governs which descriptive flexfield segments are active.
  • ATTRIBUTE1 through ATTRIBUTE20 — descriptive flexfield segments spanning the context, providing extensibility without schema changes.

The surrogate primary key (RULE_ID) should not be confused with the business-key candidate; the unique index ASO_APR_RULES_U1 enforces that RULE_ID is unique.

Common Use Cases and Queries

Typical scenarios include auditing configured approval rules, diagnosing why an order was routed to a particular approver, and migrating rule definitions between environments.

To list all active approval rules for a given security group:

  • SELECT rule_id, oam_rule_id, rule_action_id, object_approval_id FROM aso.aso_apr_rules WHERE security_group_id = :sg_id;

To trace a rule to its OAM source and action:

  • SELECT r.rule_id, r.oam_rule_id, r.rule_action_id, r.object_approval_id FROM aso.aso_apr_rules r WHERE r.rule_id = :rule_id;

For a change-audit report, select the WHO columns and order by LAST_UPDATE_DATE descending. When joining to FND_SECURITY_GROUPS, use SECURITY_GROUP_ID. DFF attributes (ATTRIBUTE1–20 plus CONTEXT) can be resolved through the standard ASO descriptive flexfield views.

Related Objects

The following objects are most significant when working with ASO_APR_RULES:

  • FND_SECURITY_GROUPS — referenced via ASO_APR_RULES.SECURITY_GROUP_ID, the only documented foreign key.
  • OAM (Oracle Approvals Management) rule tables — referenced conceptually via OAM_RULE_ID.
  • Object approval configuration tables — referenced via OBJECT_APPROVAL_ID, defining the entity under approval.
  • ASO_APR_RULE_ACTIONS (or equivalent action tables) — referenced via RULE_ACTION_ID to resolve the action executed.
  • Order/quote header tables (e.g., ASO_HEADERS / OE_ORDER_HEADERS_ALL) — the runtime transactional objects the approval engine evaluates against these rules.
  • ASO descriptive flexfield views — resolve CONTEXT and ATTRIBUTE1–20.

In summary, ASO_APR_RULES is the configuration backbone for order approval routing in Oracle EBS 12.1.1 and 12.2.2, keyed on RULE_ID and scoped by security group, with OAM integration for the actual approval evaluation.