Search Results g_oie_aud_invalid_assignment

Overview

APPS.AP_WEB_AUDIT_QUEUE_UTILS is a PL/SQL package body belonging to the Oracle Payables (AP) module, specifically serving the Internet Expenses audit queue infrastructure. In Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the server-side logic that governs how expense reports are routed, queued, balanced and reassigned among auditors working the Expense Report Audit workbench. The package maintains the relationship between expense reports, auditor records, workload counters and security profiles, supporting both manual auditor action through the audit queue forms and automated balancing routines executed as concurrent requests. Although the header comment identifies a build of 120.7.12010000.2 dated 2008, the object remains present and referenceable in the 12.1.1 and 12.2.2 application schema as APPS.AP_WEB_AUDIT_QUEUE_UTILS, and the presence in the source of a variable named g_oie_aud_invalid_assignment reflects its role in validating auditor assignments before a report is placed in a queue.

Key Procedures and Functions

The package exposes eleven documented procedures and functions that together implement the audit queue lifecycle:

• REPORT_WEIGHT — derives the weighting applied to an expense report so that queue ordering and workload calculations reflect relative effort or value.
• ASSIGN_TO_LAST_AUDITOR — returns or routes a report to the auditor who previously handled it, preserving continuity of review.
• ENQUEUE_FOR_AUDIT — places an expense report into an auditor's active audit queue.
• ASSIGN_REPORT_TO_AUDITOR — performs the explicit assignment of a report to a selected auditor, validating that the auditor is a legitimate destination.
• REBALANCE_QUEUE — redistributes queued reports across auditors to smooth workload, typically run as part of queue maintenance.
• OPEN_AUDITORS_INFO_CURSOR — opens a reference cursor supplying auditor detail to the calling form or report.
• IS_FUNCTION_ON_MENU — checks whether the audit function is exposed on a given menu, supporting responsibility-based access checks against FND_FORM_FUNCTIONS.
• REPORT_SHORTPAID — flags or identifies reports that have been short paid, influencing how they are queued.
• REMOVE_FROM_QUEUE — extracts a report from an auditor's queue, releasing the associated workload.
• AUDITOR_FOR_REPORT — returns the auditor currently responsible for a specified report.
• REASSIGN_ORPHANED_REPORTS — locates reports whose assigned auditor is no longer valid and reassigns them, exercising the same invalid-assignment validation logic referenced by g_oie_aud_invalid_assignment.

Tables Accessed

The package reads and writes through APPS synonyms across several schemas:

• AP_AUD_AUDITORS, AP_AUD_QUEUES and AP_AUD_WORKLOADS — the core audit queue, auditor definition and workload tables that the package maintains and queries.
• AP_EXPENSE_REPORT_HEADERS_ALL and AP_EXPENSE_REPORT_LINES_ALL — source expense report data used for weighting, validation and assignment.
• FND_USER, FND_RESPONSIBILITY and FND_FORM_FUNCTIONS — used to validate that an auditor login and responsibility are entitled to the audit function.
• PER_ORGANIZATION_LIST, HR_ORGANIZATION_INFORMATION and PER_SECURITY_PROFILES — used to enforce organization and security-profile boundaries when determining which auditors may receive a report.

Usage Notes

The package is primarily invoked from the Oracle Internet Expenses audit queue forms and from concurrent programs that rebalance queues and reassign orphaned reports. It is referenced by five other packages, indicating that it is a shared utility layer rather than a standalone entry point. Custom code should call the documented procedures only, since internal cursors such as those opened by open_auditors_cur_w and open_load_cur are private. Because the package performs invalid-auditor and organization-security validation, callers should expect it to raise or suppress assignment when an auditor lacks the required function or security profile, which is where the g_oie_aud_invalid_assignment condition becomes relevant.