Search Results oie_attendees_all




Overview
Explore in AI Chat

Overview

The OIE_ATTENDEES_ALL table is a core data object within the Oracle E-Business Suite Payables (AP) module, specifically supporting the Oracle Internet Expenses (OIE) functionality. Its primary role is to store detailed information about individuals who are designated as attendees or recipients for a specific expense line item on an employee expense report. This table is essential for capturing the business context of expenses, such as who was entertained during a business meal or who received a gift, which is critical for policy compliance, auditing, and accurate accounting allocation. As an "ALL" table, it is partitioned by the multi-organization structure (Operating Unit), allowing the secure segregation of data across different business units within a single installation.

Key Information Stored

The table's structure is designed to link attendees to expense lines and capture their identifying details. The primary key, ATTENDEE_LINE_ID, uniquely identifies each attendee record. The most critical foreign key column is REPORT_LINE_ID, which ties each attendee entry directly to its parent expense line in the AP_EXPENSE_REPORT_LINES_ALL table. While the provided ETRM metadata does not list all columns, typical columns in such a table would include fields to store the attendee's name, title, company affiliation, and the relationship to the employee submitting the expense. Additional columns likely manage the data's lifecycle, such as CREATION_DATE, LAST_UPDATE_DATE, and CREATED_BY.

Common Use Cases and Queries

A primary use case is auditing expense reports for policy adherence, such as verifying that a listed business purpose includes valid attendees. Reporting on entertainment expenses by attendee type or company is another common requirement. For technical support, queries often join this table to the expense report headers and lines to troubleshoot data issues or extract comprehensive audit trails. A typical SQL pattern to retrieve all attendees for a specific expense report would be:

  • SELECT a.attendee_name, a.company, el.item_description
  • FROM ap.oie_attendees_all a,
  • ap.ap_expense_report_lines_all el
  • WHERE a.report_line_id = el.report_line_id
  • AND el.report_header_id = :p_report_header_id;

Related Objects

The OIE_ATTENDEES_ALL table has a direct and documented foreign key relationship with the AP_EXPENSE_REPORT_LINES_ALL table. This relationship is defined on the column OIE_ATTENDEES_ALL.REPORT_LINE_ID, which references the corresponding line in the expense report lines table. This design ensures that every attendee is explicitly associated with a single, valid expense line item. Consequently, this table is a child of the AP_EXPENSE_REPORT_LINES_ALL table, which itself is a child of the AP_EXPENSE_REPORT_HEADERS_ALL table. Any process or report querying expense details may traverse this relationship to include attendee data.