Queries to create Dependent/ independent LoV queries in Oracle Fusion Report for : Business Unit, Legal Entity, Inventory, sub inventory
Category: security
Business Unit – Legal Entity – COA (Charts Of Accts) SQL
Brief Idea about Oracle Fusion Business Unit, Ledger and Legal entity relationship and the query to fetch the values
Legal Entity Query in Oracle Fusion Finance
Legal Entity Query and the relationship with Business Unit along with high level enterprise structure in Oracle Fusion
Query to find users having a particular Module Access
As it happened to us, we went live on Oracle Fusion Finance and eventually storm passed. Till one day we got a love letter from Oracle telling us that we have granted module access to more users than we have license for. So wasted many man hours in trying to identify the user and their… Continue reading Query to find users having a particular Module Access
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