Search Results allowable_amount




Overview
Explore in AI Chat

Overview

APPS.OIE_MGR_RPT_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, classified under the AP - Payables product family. It exists to support Oracle Internet Expenses (OIE) management reporting, presenting a consolidated, manager-oriented picture of expense report activity that has progressed to the approval, invoicing, or payment stages. The view aggregates distribution-line level expense detail, associates it with the submitting employee and that employee's primary supervisor, and joins in policy violation data captured by the expense policy engine.

Its role is analytical rather than transactional. The view is not a maintenance object and is not updated by application logic; it is a read-only projection used to feed management dashboards and reports, including the seeded Expenses Management Reporting constructs. In the ETRM 12.2.2 metadata the object is listed with status VALID, and the query text confirms the view is intended to reconcile three separate measures per expense line: the amount actually claimed, the amount deemed allowable under policy, and the amount by which policy was exceeded.

Because the view surfaces an ALLOWABLE_AMOUNT column, it is commonly located by users searching on that term when attempting to reconcile corporate card or expense amounts against policy thresholds in OIE.

Underlying Base Objects

The view resolves through APPS synonyms and views. The documented referenced base objects are:

The join path is header-to-line, with AP_POL_VIOLATIONS outer-joined to the line on report header and distribution line number, so lines with no violation still appear. Rows are restricted to reports in MGRPAYAPPR, INVOICED, or PAID status, excluding non-validated web expenses and pay-on-behalf scenarios.

Key Columns

Common Use Cases and Queries

Typical uses include manager-level expense policy compliance reporting, reconciliation of claimed versus allowable amounts, and analysis of violation frequency by employee or category.

  • Allowable versus claimed reconciliation per employee:
SELECT employee_id, full_name, report_header_id,
       SUM(line_amount)      AS claimed,
       SUM(allowable_amount) AS allowable,
       SUM(violation_amount) AS exceeded
FROM   apps.oie_mgr_rpt_v
WHERE  expense_report_date BETWEEN :p_from AND :p_to
GROUP BY employee_id, full_name, report_header_id;
  • Violations by supervisor and type:
SELECT supervisor_id, violation_type, SUM(number_of_violations)
FROM   apps.oie_mgr_rpt_v
WHERE  violation_type IS NOT NULL
GROUP BY supervisor_id, violation_type;

Because the view embeds PL/SQL calls for currency conversion and HR security, queries should be filtered tightly to control execution cost.