INL Pending Actual Charges – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Oracle Landed Cost Management · all Oracle Landed Cost Management reports

Overview

Estimated landed cost charges per shipment line, charge type and charging party that no AP invoice has been matched to yet, aged by shipment date at the As of Date. It lists the freight, duty and brokerage invoices still to be received and the accrual exposure they carry.

Estimated Amount is the current estimate in functional currency, including estimate changes made after the shipment was submitted, and Original Estimated Amount the first calculation. A charge type stops being pending on a receipt line once any invoice of that type is matched to it, whatever the amount.

A charge invoice that Payables has matched but that has not reached the shipment yet, because it is still in the LCM matches interface or failed there, shows its amount, interface status and invoice number in the Interface columns. Such a charge stays pending until the Landed Cost Management matches import has processed it.

Shipment lines closed for matching are excluded unless Include Closed for Matching is set.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Operating Unit, Organization Code, As of Date, Minimum Age Days, Shipment Date From, Shipment Date To, Supplier, Item, Charge Type, Charging Party, Include Closed for Matching

Oracle EBS Tables Used

rcv_transactions, inl_ship_headers_all, inl_allocations, inl_ship_lines_all, inl_charge_lines, org_access_view, inl_matches_int, ap_invoice_distributions_all, ap_invoices_all, inl_matches, inl_ship_line_groups, hr_all_organization_units_vl, mtl_parameters, org_organization_definitions, gl_ledgers, mtl_system_items_vl, ap_suppliers, po_line_locations_all, po_lines_all, po_headers_all, rcv_shipment_lines, rcv_shipment_headers, pon_cost_factors_vl, hz_parties

Report Categories

Enginatics, R12 only

INL Landed Cost Estimated vs Actual, INL Duty and Tariff Analysis, CAC Interface Error Summary, INL Tariff Exposure on Open POs, INL Landed Unit Cost Trend, INL Landed Cost Adjustments

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output INL Pending Actual Charges 10-Oct-2026 151355.xlsx
Blitz Report™ XML Import INL_Pending_Actual_Charges.xml
SQL Source INL Pending Actual Charges.sql
Full Report on Enginatics www.enginatics.com/reports/inl-pending-actual-charges/

Case Study & Technical Analysis: INL Pending Actual Charges

Executive Summary

This report lists the landed cost charges on receipts that no Accounts Payable invoice has been matched to yet. Each row is a shipment line, charge type and charging party combination, aged by shipment date at the chosen as-of date. It shows the estimated amount of the freight, duty and brokerage charges still awaiting their invoices, and the accrual exposure they carry. Import and logistics accountants use it at period close to see which landed costs are still estimates and to chase the missing supplier invoices. The report runs in Excel through Blitz Report.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. The estimated amounts come from an inline view that sums allocations of the landed cost flag by shipment line and charge line type, for the original adjustment and the current adjustment.
  2. The inline view is joined to the interface matches view on shipment line and charge line type, as an outer join, so a charge with no interface record still appears.
  3. A charge is excluded when a matching INL_MATCHES row of type CHARGE already exists for the shipment line and charge type.
  4. The shipment line joins to RCV_SHIPMENT_LINES through the LCM shipment line id, and to the purchase order through the line location of a PO source.
  5. The charge type joins to PON_COST_FACTORS_VL on the price element type id, and the charging party to HZ_PARTIES.

Parameters & Filtering

Performance & Optimization

FAQ

Q: Why does a charge still show as pending after I entered its invoice? A: The invoice must be matched to the same shipment line and charge type, and the Landed Cost Management matches import must have processed it. Until then the charge stays pending.

Q: Why are closed shipment lines missing? A: Shipment lines closed for matching are excluded unless the Include Closed for Matching parameter is set to Y.

© Enginatics GmbH