Search Results remove_from_queue

Overview

APPS.AP_WEB_AUDIT_QUEUE_UTILS is a PL/SQL utility package that supports the Expense Report auditing workflow within Oracle Payables (Oracle Internet Expenses). Its primary responsibility is to manage the audit queue by which submitted expense reports are routed to auditors, rebalanced across auditor workloads, reassigned when auditors are unavailable, and re-queued after a report is returned for correction. The package encapsulates the business rules that determine which auditor receives a report, how returned reports are handled, and how orphaned reports are recovered. The header comment indicates the file (apwaudqs.pls) was last revised in 2008, making it a stable, long-standing component of the Payables audit infrastructure used in both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes eleven documented procedures and functions:

• REPORT_WEIGHT — A function that returns the high threshold weight for a given low report value, used to score or rank reports for queue prioritization.
• ASSIGN_TO_LAST_AUDITOR — Assigns a returned report back to the same auditor who last audited it, without regard to the auditor's current load.
• ENQUEUE_FOR_AUDIT — Places a report into the audit queue for routing to an auditor.
• ASSIGN_REPORT_TO_AUDITOR — Performs the core assignment of a report to a specific auditor.
• REBALANCE_QUEUE — Redistributes queued reports to level auditor workloads.
• OPEN_AUDITORS_INFO_CURSOR — Opens a reference cursor (GenRefCursor) supplying auditor information for downstream processing.
• IS_FUNCTION_ON_MENU — Determines whether a given function is present on a menu, typically to validate eligibility or responsibility-based access during audit routing.
• REPORT_SHORTPAID — Identifies or handles reports processed via the short-pay audit outcome.
• REMOVE_FROM_QUEUE — Removes a report from the audit queue, for example when it is approved or withdrawn.
• AUDITOR_FOR_REPORT — Returns the auditor associated with a particular report.
• REASSIGN_ORPHANED_REPORTS — Recovers reports that have lost their assigned auditor and re-routes them.

Two constants are defined: G_OIE_AUD_INVALID_ASSIGNMENT and G_OIE_AUD_SUCCESS, used to signal assignment outcomes.

Tables Accessed

The package reads and writes the core Payables audit and expense structures through APPS synonyms:

• AP_AUD_QUEUES, AP_AUD_AUDITORS, AP_AUD_WORKLOADS — the audit queue, auditor registry, and workload tracking tables driving assignment and rebalancing.
• AP_EXPENSE_REPORT_HEADERS_ALL and AP_EXPENSE_REPORT_LINES_ALL — the expense report header and line data being audited.
• FND_FORM_FUNCTIONS, FND_RESPONSIBILITY, FND_USER — Oracle Application Object Library tables used by IS_FUNCTION_ON_MENU and auditor eligibility checks.
• HR_ORGANIZATION_INFORMATION, PER_ORGANIZATION_LIST, PER_SECURITY_PROFILES — HR organization and security profile data used to scope auditor access and routing.

Usage Notes

This package is invoked primarily by the Oracle Internet Expenses audit workflow and related concurrent processes rather than directly by end users. It is referenced by five other packages and is called from workflow activities that fire when reports are submitted, returned, approved, or when an auditor leaves. Because it depends on FND and PER security structures, its behavior is responsibility- and organization-sensitive. Customizations should avoid modifying the package body directly; instead, extensions should call its public procedures. Administrators troubleshooting "stuck" or unassigned reports in the audit queue typically rely on REASSIGN_ORPHANED_REPORTS and REBALANCE_QUEUE to restore consistent routing.