BI Report, Business Intelligence Report,, indexes, Oracle Fusion, Table Structure

Inv_Org_Parameters: Inventory Table In Fusion

Inv_org_parameters table is one of the most important table if you have implemented inventory module in Oracle Fusion. Anywhere there has to be a linkage with inventory org, this table will come into the game. Example is querying egp_system_items_b table for a particular item_number. In the image below you can see the place of inventory… Continue reading Inv_Org_Parameters: Inventory Table In Fusion

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

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

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

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