Search Results ap_web_db_violations_pkg




Overview
Explore in AI Chat

Overview

AP_WEB_DB_VIOLATIONS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Payables (AP) module, specifically the Internet Expenses / Web Expenses subsystem. Its purpose is to manage the persistence and lifecycle of expense report policy violations detected during the entry and approval of expense reports submitted through the Oracle iExpenses self-service flow.

When an employee enters an expense report, the application evaluates each line and header against configured expense policies. Any breach of those policies is recorded as a policy violation. AP_WEB_DB_VIOLATIONS_PKG provides the data-access layer that inserts, updates, and removes those violation records and maintains the associations between violation rows and the parent expense report headers and lines. It is a supporting database package rather than a user-facing component, and it is classified as an OTHER API in the ETRM repository, signifying that Oracle does not document it as a public, supported integration interface.

Key Procedures and Functions

The documented package exposes six procedures. Their names describe their intended purposes:

  • DELETEVIOLATIONENTRY — Removes a single policy violation entry from the violations tables, typically after the underlying expense line has been corrected, deleted, or the violation has been resolved.
  • DELETEDUPVIOLATIONENTRY — Removes duplicate violation entries, ensuring that repeated evaluation of an expense line does not leave redundant violation records.
  • UPDATEVIOLATIONSHEADERID — Updates the header identifier on violation records, used when violations must be re-associated with a corrected or newly created expense report header.
  • SETVIOPOLICYSHORTPAIDREPORTID — Sets the violation policy identifier associated with the short-paid report handling for policy-related violations.
  • SETVIORECEIPTSHORTPAIDREPORTID — Sets the violation identifier associated with the short-paid report handling for missing-receipt violations.
  • SETVIOLATIONBOTHPAIDREPORTID — Sets the violation identifier used when both the policy and receipt short-paid conditions apply to the same report.

These routines collectively support the insertion, correction, de-duplication, and removal of violation data as an expense report moves through the entry, submission, and approval workflow.

Tables Accessed

The package references the following objects via APPS synonyms:

  • AP_EXPENSE_REPORT_HEADERS — the parent expense report header, used to associate violations with the correct report.
  • AP_EXPENSE_REPORT_LINES — the individual expense lines against which policy checks and violations are evaluated.
  • AP_POL_VIOLATIONS — the base violations table storing the generated violation records.
  • AP_POL_VIOLATIONS_ALL — the partitioned/MLS-enabled variant of the violations table, providing the full set of violation rows across operating units.

The dependent-code listing also shows a dependency on the SYS schema and the STANDARD package, reflecting internal PL/SQL constructs.

Usage Notes

AP_WEB_DB_VIOLATIONS_PKG is invoked indirectly by the Oracle Internet Expenses workflow and self-service runtime rather than being called directly by end users. The ETRM metadata records that it is referenced by two other packages: AP_WEB_EXPENSE_WF (the expense report approval workflow) and AP_WEB_OA_MAINFLOW_PKG (the main OIE processing flow). The package also self-references, confirming internal recursive calls.

Because it is classified as an OTHER API, it should be treated as an internal, unsupported object. Customizations should prefer supported public APIs. When troubleshooting violation behaviour, developers may query the AP_POL_VIOLATIONS tables directly, but any modification of this package or its logic risks breaking the standard expense approval workflow in both 12.1.1 and 12.2.2.