Oracle EBS Oracle Landed Cost Management Reports

6 ready-to-run SQL reports for Oracle E-Business Suite Oracle Landed Cost Management, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Oracle Landed Cost Management tables in these reports are inl_ship_headers_all, inl_ship_lines_all, org_access_view, hr_all_organization_units_vl, mtl_parameters, org_organization_definitions.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Oracle Landed Cost Management SQL Reports

Report Description
INL Duty and Tariff Analysis Duty, other charges and taxes per landed cost shipment line, with tariff code, country of origin and supplier, to analyse duty rates and the landed cost uplift…
INL Landed Cost Adjustments Landed cost adjustments processed by Cost Management, with the receiving accounting they generated. One row per accounting line of each adjustment: the…
INL Landed Cost Estimated vs Actual Landed cost per Landed Cost Management shipment line and cost component (item price, each charge type and each tax), comparing the estimate with the current…
INL Landed Unit Cost Trend Unit landed cost per item over its landed cost shipments, broken down into item cost, charges and taxes, with the change against the item’s previous shipment…
INL Pending Actual Charges 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…
INL Tariff Exposure on Open POs Open quantity of approved PO shipments enabled for Landed Cost Management, with simulated and historical duty, to project the tariff cost of goods not received…

← All Oracle EBS modules

© Enginatics GmbH