Search Results ap_aud_auditors_pk

Overview

The AP_AUD_AUDITORS table is a core reference table within the Oracle E-Business Suite Payables (AP) module, specifically supporting the Invoice Approval Workflow and Audit function. It serves as the master repository for defining and storing information about individuals authorized to perform invoice audits. The table's primary role is to establish a link between the system's user base (FND_USER) and the specific security profiles and audit queues that govern their workflow responsibilities. By centralizing auditor definitions, it enables the systematic assignment, routing, and workload management of invoices requiring audit, ensuring proper segregation of duties and control within the procure-to-pay process.

Key Information Stored

While the provided metadata does not list all column details, the documented foreign key relationships and primary key structure reveal the essential data points. The central column is the AUDITOR_ID, which serves as the primary key (AP_AUD_AUDITORS_PK). This column uniquely identifies each auditor record and is a foreign key to the FND_USER table, linking the auditor to a valid E-Business Suite user. The SECURITY_PROFILE_ID column is a foreign key to the PER_SECURITY_PROFILES table, which determines the data access and operational permissions for the auditor, such as which operating units or sets of books they can review. The table likely contains additional descriptive columns, such as an auditor name or status indicator, to fully define the auditor entity within the Payables application context.

Common Use Cases and Queries

A primary use case is the administration of the audit workflow, where system administrators query and maintain the list of active auditors. Common reporting needs include generating a list of all configured auditors with their associated usernames and security profiles, or identifying auditors assigned to specific audit queues. For troubleshooting, one might query for auditors who are not active users or who lack a valid security profile. Sample SQL to retrieve basic auditor information would typically join to the related reference tables:

• SELECT apa.auditor_id, fu.user_name, psp.security_profile_name FROM ap_aud_auditors apa, fnd_user fu, per_security_profiles psp WHERE apa.auditor_id = fu.user_id AND apa.security_profile_id = psp.security_profile_id;
• SELECT apa.auditor_id, aaq.queue_name FROM ap_aud_auditors apa, ap_aud_queues aaq WHERE apa.auditor_id = aaq.auditor_id;

Related Objects

The AP_AUD_AUDITORS table is integral to the audit workflow data model, with documented relationships to several key objects. It references two foundational tables: FND_USER (via AUDITOR_ID) and PER_SECURITY_PROFILES (via SECURITY_PROFILE_ID). Furthermore, it is referenced as a parent table by two critical workflow tables. The AP_AUD_QUEUES table uses the AUDITOR_ID foreign key to define specific audit queues owned by an auditor. The AP_AUD_WORKLOADS table also references AP_AUD_AUDITORS via AUDITOR_ID, linking individual auditors to their assigned workload of invoices. These relationships position AP_AUD_AUDITORS as the central hub for auditor definition, from which queue assignments and workload distributions are managed.