Search Results receipt_verified_flag




Overview
Explore in AI Chat

Overview

APPS.ICX_AP_EXPENSE_LINES_V is a PL/SQL view owned by the APPS schema and registered under FND Design Data as ICX.ICX_AP_EXPENSE_LINES_V. Its status is VALID. Oracle classifies this object as Internal Use Only, meaning Oracle Corporation does not support direct access to application data through it except from standard Oracle Applications programs. The view presents Oracle Payables expense report distribution lines in a flattened, self-service reporting form suitable for the Internet Computing Architecture (ICX) framework used by Oracle iExpenses and related employee-facing expense functionality.

The view consolidates header, line, and distribution information from the Payables expense report model, enriches it with project and award attributes, applies HR security predicates, and exposes a number of concatenated or formatted descriptive columns. It is not a base transaction table; it is a read-only projection intended for inquiry and reporting. Because it carries a package dependency on FND_GLOBAL, HR_SECURITY, and HR_GENERAL, results are typically scoped to the current session's user and responsibility, which is critical to understand when reproducing or tuning queries.

Underlying Base Objects

The documented referenced objects are: AP_EXPENSE_REPORT_HEADERS (synonym), AP_EXPENSE_REPORT_LINES (synonym), AP_EXPENSE_REPORT_PARAMS (synonym), AP_INVOICES (synonym), AP_INVOICE_DISTRIBUTIONS (synonym), FND_CURRENCY (package), FND_GLOBAL (package), FND_LOOKUPS (view), GMS_SSA_AWARDS_V (view), HR_GENERAL (package), HR_SECURITY (package), PA_PROJECTS_ALL (synonym), and PA_TASKS (synonym).

The expense report headers and lines supply the employee, expense type, justification, and distribution structure. The invoice and invoice distribution objects provide the accounting and distribution line context once the expense report is interfaced or matched. Lookups translate coded values into meaningful descriptions, and the project and task objects supply the project accounting segments (SEGMENT1, TASK_NUMBER). The grants management view GMS_SSA_AWARDS_V supplies the AWARD_NUMBER column. HR security and global packages enforce operating unit and person-level access restrictions, which is why query results vary by session context.

Key Columns

The view exposes approximately forty columns. Notable groups include:

RECEIPT_VERIFIED_FLAG (VARCHAR2(80)) indicates whether the receipt supporting the expense line has been verified. It typically carries lookup values such as Y/N or a descriptive equivalent resolved through FND_LOOKUPS. It complements RECEIPT_REQUIRED_FLAG (receipt required by policy) and RECEIPT_MISSING_FLAG (receipt not yet provided). Together these three flags drive audit and policy exceptions.

Common Use Cases and Queries

Typical scenarios include receipt compliance reporting, employee expense audit review, project cost analysis, and grants tracking. Because HR security is embedded, notes and diagnostics often require running under the same responsibility as the original user.

List unverified receipt lines:

  • SELECT REPORT_FOREIGN_KEY, DISTRIBUTION_LINE_NUMBER, EXPENSE_TYPE, RECEIPT_REQUIRED_FLAG, RECEIPT_MISSING_FLAG, RECEIPT_VERIFIED_FLAG FROM APPS.ICX_AP_EXPENSE_LINES_V WHERE RECEIPT_VERIFIED_FLAG = 'N';

Project-level expense summary:

  • SELECT SEGMENT1, TASK_NUMBER, SUM(TO_NUMBER(AMOUNT)) FROM APPS.ICX_AP_EXPENSE_LINES_V GROUP BY SEGMENT1, TASK_NUMBER;

Grants-related expenses:

  • SELECT AWARD_NUMBER, EXPENSE_TYPE, AMOUNT FROM APPS.ICX_AP_EXPENSE_LINES_V WHERE AWARD_NUMBER IS NOT NULL;

Given the Internal Use Only designation, supported integration should occur through the Oracle application modules that own this view rather than through direct custom queries.