Query to find out the charts of account structure in Oracle Fusion Finance and corresponding value sets.
Category: BI Report, Business Intelligence Report,
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
Report Job Parameters Query in Oracle Fusion
Once you have gone live in fusion, you are bound to have many reports scheduled and there will be a day when the most often run report will do something funky and you would like to run a query to fetch you all the report job parameters. this query will serve the purpose: Query to… Continue reading Report Job Parameters Query in Oracle Fusion
Job details Query in Oracle Fusion
Query to find the details of Fusion Job Reports such as start date, end date, status, report path ( where report resides).