Search Results report_number_field

Overview

APPS.AP_EXPENSE_REPORT_HISTORY_V is a reporting view in Oracle E-Business Suite (available in both 12.1.1 and 12.2.2) that consolidates the history of employee expense reports by joining expense report header information with their corresponding Oracle Payables invoices. The view blends data from the expense reporting module (Oracle Internet Expenses) and the payables module, giving a unified record of an expense report, its reimbursable amounts, invoice details, payment status, and currency-formatted totals. It is primarily intended for self-service and administrative reporting where users need to trace an expense report through to its payable invoice.

Because it surfaces presentation-oriented fields alongside raw identifiers, the view fits neatly into Oracle EBS's model of exposing declarative flags to the user interface layer. The REPORT_NUMBER_FIELD column, for instance, returns either ReportNumberEnabled or ReportNumberDisabled, and is exactly what a search on "report_number_field" would locate. These decorative columns do not store business data; they instruct the consuming UI or report whether a given feature, such as displaying a report number or an expense-lines link, is applicable for the current record.

Underlying Base Objects

The view is defined over a mix of base tables, synonyms, packages, and other views in the APPS schema. Documented referenced objects include:

• AP_EXPENSE_REPORT_HEADERS (synonym) — the primary expense report header, aliased AERH, supplying amounts, status source, and the report header identifier.
• AP_INVOICES (synonym) — aliased AI, providing invoice number, date, currency, descriptions, and the amount due to the company card and employee.
• AP_PAYMENT_SCHEDULES (synonym) — aliased APS, contributing due date, gross amount, and amount remaining.
• AP_LOOKUP_CODES (view) — aliased ALC, resolving status lookup codes such as CANCELLED, PAID, PARPAID, and INVOICED, and their displayed values.
• PER_PEOPLE_X (view) and PO_VENDORS (view) — supplying person/employee identity and supplier context.
• Packages — FND_CURRENCY_CACHE, ICX_AP_INVOICES_PKG, AP_WEB_DB_HR_INT_PKG, AP_WEB_OA_ACTIVE_PKG, FND_GLOBAL, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY handle currency formatting, withheld-amount computation, HR integration, and security/person name resolution.

Key Columns

• REPORT_PRIMARY_KEY / REPORT_HEADER_ID — identifiers linking back to the invoice and the expense report header.
• REPORT_NUMBER_FIELD — a decoded control flag returning ReportNumberEnabled or ReportNumberDisabled based on the report source (WebExpense, SelfService, CREDIT CARD, NonValidatedWebExpense).
• INVOICE_NUM, INVOICE_DATE, INVOICE_ID, INVOICE_CURRENCY_CODE — payable invoice attributes.
• INVOICE_AMOUNT, GROSS_AMOUNT, AMOUNT_REMAINING, WITHHELD_AMOUNT_CURRENCY_CODE — currency-formatted monetary totals derived through FND_CURRENCY_CACHE and ICX_AP_INVOICES_PKG.
• STATUS — the displayed status lookup value (for example CANCELLED, PAID, INVOICED).
• VIEW_PAYABLES_FIELD, EXPENSE_LINES_FIELD, DOCUMENT_TYPE, SOURCE, FULL_NAME, EMPLOYEE_ID, DUE_DATE — supporting display and navigation flags.

Common Use Cases and Queries

Typical uses include auditing the status of submitted expense reports, reconciling reimbursements against payable invoices, and driving self-service pages that conditionally show the report number or expense-line image link.

SELECT report_header_id,
       invoice_num,
       full_name,
       status,
       invoice_amount,
       report_number_field
FROM   apps.ap_expense_report_history_v
WHERE  employee_id = :p_employee_id;

To locate records where the report number should be displayed:

SELECT invoice_num, report_number_field
FROM   apps.ap_expense_report_history_v
WHERE  report_number_field = 'ReportNumberEnabled';

Because the view applies package logic and currency masks, it should be queried rather than replicated, and performance is best where filters on employee or report identifiers are applied.