Search Results ap_aud_rule_sets_u1

Overview

AP.AP_AUD_RULE_SETS is the audit rule set definition table within the Oracle E-Business Suite Payables and Internet Expenses audit framework. Each row defines a named, date-effective rule set that governs two distinct audit behaviors: whether a submitted expense report is subject to audit (RULE_SET_TYPE = 'RULE'), and whether an employee is placed on the audit list (RULE_SET_TYPE = 'AUDIT_LIST'). Because the table stores the configuration that drives automated auditing decisions, it is central to compliance enforcement in Oracle Internet Expenses.

Under the ETRM 12.2.2 physical schema, the table is owned by AP and contains 76 columns, stored in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10. The heuristic Data Vault classification derived from the foreign key structure is satellite-leaning. In practice this suggests modeling AP_AUD_RULE_SETS as a satellite attached to a rule set hub; its attributes (audit thresholds, flags, notification settings, and stage codes) are descriptive and change over time, which is consistent with satellite semantics rather than a link table.

Key Information Stored

The surrogate primary key is RULE_SET_ID (NUMBER(15)), and it is also the single column of the unique index AP_AUD_RULE_SETS_U1, making it the authoritative business-key candidate. Two non-unique indexes, AP_AUD_RULE_SETS_N1 and AP_AUD_RULE_SETS_N2, support lookups by RULE_SET_NAME and RULE_SET_TYPE respectively.

• RULE_SET_ID — unique identifier of the rule set (PK, unique index AP_AUD_RULE_SETS_U1).
• RULE_SET_NAME — descriptive name of the rule set (indexed by N1).
• RULE_SET_TYPE — discriminates between RULE (audit decision) and AUDIT_LIST (employee placement) rule sets (indexed by N2).
• START_DATE / END_DATE — date-effective window controlling when the rule set is active.
• PAPERLESS_AUDIT_CC_ONLY_FLAG, PAPERLESS_AUDIT_VIOLATION_FLAG, PAPERLESS_AUDIT_PDM_ONLY_FLAG — determine whether paperless audit applies to corporate-credit-card-only reports, reports with violations, and per diem/mileage-only reports.
• ASSIGN_AUDITOR_STAGE_CODE / RECPT_ASSIGN_STAGE_CODE — define the workflow stage at which an auditor or receipt is assigned.
• AUDIT_ALL_VIOLATIONS_FLAG, AUDIT_ALL_FROM_AUDIT_LIST_FLAG, RANDOM_AUDIT_FLAG, RANDOM_AUDIT_PERCENTAGE — control mandatory and random audit selection.
• MONTHLY_TOTAL_RULE_FLAG, MONTHLY_TOTAL_ALLOWED, MONTHLY_VIOLATIONS_ALLOWED, MONTHLY_REPORTS_ALLOWED — thresholds that trigger employee audit-list placement.
• AUDIT_TERM_DURATION_DAYS — length of time an employee remains on the audit list.

Statutory WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) are also maintained.

Common Use Cases and Queries

Typical scenarios include identifying which rule sets are currently active, locating the rule set applied to an employee, and auditing the configuration that selected reports for audit. The most common access pattern resolves a rule set by its unique identifier, the value typically supplied by application lookup for AP_AUD_RULE_SETS_U1.

• Retrieve an active rule set by primary key: SELECT * FROM ap.ap_aud_rule_sets WHERE rule_set_id = :rule_set_id;
• List active audit-list rule sets: SELECT rule_set_id, rule_set_name FROM ap.ap_aud_rule_sets WHERE rule_set_type = 'AUDIT_LIST' AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE + 1);
• Join to assignments to trace which rule sets are attached to which operating units.
• Review random-audit configuration where RANDOM_AUDIT_FLAG = 'Y' and inspect RANDOM_AUDIT_PERCENTAGE.
• Verify receipt-delay and monthly-threshold parameters (RECEIPT_DELAY_DAYS, MONTHLY_TOTAL_ALLOWED) as part of audit configuration reporting.

Related Objects

The principal dependency is the assignment table that links rule sets to organizational contexts. The foreign key AP_AUD_RULE_ASSIGNMENTS_ALL.RULE_SET_ID references AP_AUD_RULE_SETS.RULE_SET_ID, making AP_AUD_RULE_ASSIGNMENTS_ALL the primary dependent object for determining where a rule set is applied. Additionally, AP_AUD_RULE_SETS.AUDIT_ALL_AMOUNT_CURRENCY_CODE references FND_CURRENCIES, tying the amount-limit audit rule to a valid currency definition. Related functional areas include the Internet Expenses audit process and the audit rules configuration UI, which read and maintain these rows. Because the table is satellite-leaning, its union with AP_AUD_RULE_ASSIGNMENTS_ALL forms the effective audit configuration consumed by expense report auditing logic.