Tag: Inventory

Oracle Fusion Finance, sales Order, shipment

Item Shipment History Query in Fusion

Mohit Saxena

Query to fetch the shipment history like item number, shipment date, Inventory, ship to site, ship to party, quantity , sales order number etc

BI Report, Business Intelligence Report,, Enterprise structure, Oracle Fusion

Subinventory Query in Oracle Fusion

Mohit Saxena

Query to fetch the subinventory details like inventory, picking Order, material status, depreciable, locator control, locator structure

BI Report, Business Intelligence Report,, Constraints, indexes, Table Structure

EGP_SYSTEM_ITEMS_B : Item Table in Fusion

Mohit Saxena

Oracle Fusion item master table: Structure, indexes and constraints

BI Report, Business Intelligence Report,, Business Unit structure, Enterprise structure, security

LoV Queries: Legal Entity, Business Unit, Inventory, Sub Inv.

Mohit Saxena

Queries to create Dependent/ independent LoV queries in Oracle Fusion Report for : Business Unit, Legal Entity, Inventory, sub inventory

BI Report, Business Intelligence Report,, Entity specific security, Oracle Fusion, Oracle Fusion Finance, security

Report Security: Data Access On Specific Entities

Mohit Saxena

How to restrict the data access of users in Fusion Report to limit the input parameters in order to maintain the data privacy