Search Results ap_aud_queue_summaries_v




Overview
Explore in AI Chat

Overview

AP_AUD_QUEUE_SUMMARIES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite Payables (AP). It consolidates audit queue assignment data into a per-auditor summary, exposing one row for each distinct auditor recorded in the audit queues. Rather than returning individual queue entries, the view aggregates workload information so that consumers can rapidly assess how many audit reports each auditor holds and the cumulative weight assigned to those holdings.

The view is defined entirely as an aggregation over AP_AUD_QUEUES, applying GROUP BY AUDITOR_ID. It carries no additional filtering, joins, or DML logic; it is a read-only projection designed for query and reporting convenience. Because it is a simple view over a single base object, it inherits the security and access characteristics of the underlying audit queue data while presenting it in a form suited to dashboards, workload-balancing checks, and integration extracts.

Underlying Base Objects

The only documented referenced base object is AP_AUD_QUEUES, accessed through a SYNONYM in the APPS schema. AP_AUD_QUEUES stores the audit queue records, each associated with an auditor and carrying a REPORT_WEIGHT value used to express relative effort or priority. AP_AUD_QUEUE_SUMMARIES_V collapses these rows by AUDITOR_ID:

  • SUM(REPORT_WEIGHT) produces the total workload per auditor.
  • COUNT(REPORT_WEIGHT) counts only rows where REPORT_WEIGHT is non-null.
  • COUNT(*) counts all queue rows for the auditor, including those with a null weight.

Because the view performs no filtering, any auditor_id present in AP_AUD_QUEUES appears in the summary. Auditors with no queue entries do not appear at all.

Key Columns

  • AUDITOR_ID — Identifier of the auditor. This is the grouping key; each value appears once in the result set.
  • CURRENT_TOTAL_WORKLOAD — Sum of REPORT_WEIGHT across all queue rows for the auditor, representing the aggregate weighted workload currently assigned.
  • COUNT_REPORT_WEIGHTS — Number of queue rows for the auditor having a non-null REPORT_WEIGHT. Useful for distinguishing weighted records from unweighted ones.
  • COUNT_REPORTS — Total number of queue rows (reports) assigned to the auditor, matching the search term "count_reports." This is the most direct measure of queue volume per auditor.

Common Use Cases and Queries

The view is typically used to monitor auditor capacity, distribute work, and feed external reporting. A basic workload listing:

  • SELECT auditor_id, count_reports, current_total_workload FROM apps.ap_aud_queue_summaries_v ORDER BY current_total_workload DESC;

To identify auditors exceeding a report-count threshold:

  • SELECT auditor_id, count_reports FROM apps.ap_aud_queue_summaries_v WHERE count_reports > 50;

To compare weighted versus unweighted counts and detect rows lacking weights:

  • SELECT auditor_id, count_reports, count_report_weights, count_reports - count_report_weights AS unweighted FROM apps.ap_aud_queue_summaries_v;

Total organization-wide workload can be obtained by summing the aggregate columns. Because the view already performs grouping, no additional GROUP BY is required when querying per auditor. Consumers should note that results reflect the current state of AP_AUD_QUEUES at query time and are not historical or snapshot-based.