Results for “report_line_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The OIE_ATTENDEES_ALL table in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 resides in the AP (Payables) schema and stores attendee and recipient data associated with expense report lines. This table supports the Oracle Internet Expenses (OIE) functionality by capturing the individuals, employers, and related details tied to a given expense type line. Its records feed downstream expense processing, reimbursement validation, and reporting workflows.

The table is keyed on ATTENDEE_LINE_ID via the OIE_ATTENDEES_PK primary key and includes a unique index OIE_ATTENDEES_ALL_U1 on the same column, making ATTENDEE_LINE_ID both the surrogate identifier and the primary business-key candidate. The documented foreign key to AP_EXPENSE_REPORT_LINES_ALL (via REPORT_LINE_ID) and to PSB_EMPLOYEES (via EMPLOYEE_ID) establishes dependency on the parent expense report line and the employee records. From a Data Vault modeling perspective (heuristic classification: satellite-leaning), this table behaves largely as a satellite attached to the expense report line hub, with some link-like characteristics through the EMPLOYEE_ID reference.

Key Information Stored

The table contains 32 documented columns. The most significant are listed below.

• ATTENDEE_LINE_ID — Primary key (OIE_ATTENDEES_PK) and unique business-key candidate (OIE_ATTENDEES_ALL_U1); uniquely identifies each attendee record.
• REPORT_LINE_ID — Foreign key to AP_EXPENSE_REPORT_LINES_ALL; links the attendee to a specific expense report line.
• EMPLOYEE_ID — Foreign key to PSB_EMPLOYEES; identifies the attendee when the attendee is an employee.
• EMPLOYEE_FLAG — Indicates whether the attendee is an internal employee versus an external or third-party attendee.
• ATTENDEE_TYPE — Classifies the attendee (e.g., employee, recipient), driving validation and reimbursement logic.
• NAME and TITLE — Descriptive fields capturing the attendee's name and job title.
• EMPLOYER and EMPLOYER_ADDRESS — Capture the attendee's organization and its address, relevant for external attendees.
• TAX_ID — Tax identification number for the attendee, used for tax reporting and compliance.
• ORG_ID — Multi-org operating unit identifier, enforcing Organization Access Control (MOAC).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record creation and modification.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns enabling client-specific extensions.

Common Use Cases and Queries

Typical uses include reporting on attendees by expense report line, validating employee versus non-employee reimbursement, and reconciling tax IDs for compliance. Analysts frequently join OIE_ATTENDEES_ALL to AP_EXPENSE_REPORT_LINES_ALL to aggregate attendee counts and amounts per expense line.

• List attendees for a report line: SELECT a.NAME, a.TITLE, a.ATTENDEE_TYPE FROM AP.OIE_ATTENDEES_ALL a WHERE a.REPORT_LINE_ID = :report_line_id;
• Identify employee attendees: SELECT a.ATTENDEE_LINE_ID, a.EMPLOYEE_ID FROM AP.OIE_ATTENDEES_ALL a WHERE a.EMPLOYEE_FLAG = 'Y';
• Join to expense report lines: SELECT l.REPORT_LINE_ID, a.NAME FROM AP.OIE_ATTENDEES_ALL a JOIN AP.AP_EXPENSE_REPORT_LINES_ALL l ON a.REPORT_LINE_ID = l.REPORT_LINE_ID;
• Multi-org filtered reporting using ORG_ID to enforce operating unit security.

Related Objects

• AP_EXPENSE_REPORT_LINES_ALL — Parent expense report line; joined on OIE_ATTENDEES_ALL.REPORT_LINE_ID.
• PSB_EMPLOYEES — Employee master; joined on OIE_ATTENDEES_ALL.EMPLOYEE_ID.
• AP_EXPENSE_REPORTS_ALL — Header-level expense report data, related through the report line.
• AP_EXPENSE_REPORT_HEADERS_ALL — Complements header and line reporting for expense reports.
• AP_EXPENSE_REPORT_DISTS — Distribution accounting entries derived from expense lines.
• AP_INVOICES_ALL — Invoice records generated when expense reports are imported into Payables.
• FND_FLEX_VALUES / FND_DESCR_FLEX_COL_USAGE — DFF configuration backing ATTRIBUTE_CATEGORY and ATTRIBUTE1–15.