Hello @Walter Gess, Looks like there was an issue in pasting the doc on to this thread. Pls review: Fusion OTBI - How to retrieve data from the General Ledger Journals Real Time subject area and the Subledger Journals Real Time subject area in one report? (Doc ID 2062729.1)…

Hello @Walter Gess, Can you please try creating the report as mentioned in the below document which has step by step instructions. Thanks, Praveen

Hello @Parag Hiremath, The error message still says that the report output size has exceeded the maximum limit, So you still need to apply more filters to restrict the amount of the data generated in the report. Thanks, Praveen

Hello @Aarthi Natarajan-Oracle, If you have assigned the roles mentioned above and also from the Doc ID 2856237.1 , Then please check the custom data role access. To get the data, You should assign the appropriate data access through the custom data roles. Thanks, Praveen

Hello @Zunett and @Liwen Chiu, Looks like the document is under edit now. The solution from the document is : "Log an SR with Support to provide the output." So please create an SR with BI support. Thanks, Praveen

Hello @GoSaaS, To better serve you, please post this question in the Reporting and Analytics for HCM forum since its specific to HCM DB Tables/use cases. Thanks, Praveen

Hello @sakthi.paramasivam, I see Josue has answered. And also i found the below document with some SQLs from various tables. FUSION CST:What Are Table Names Having ITEM_COST Field? (Doc ID 2225598.1) Thanks, Praveen

Hello @Amit Amit, Can you please review the below documents to see if they can assist you. Fusion Applications : How to call parametrized OTBI report from webservice (Doc ID 2705306.1) How to include date filter on OTBI report using webservice (Doc ID 2815071.1) Thanks, Praveen

Hello @Barry Stamp-73691 and @Yudhinta, Please review the below KM Documents on how to control the permissions on BI Objects in BI Catalog. Oracle Fusion BI: How to create a custom Role to control permissions on the BI Catalog objects (Doc ID 2308588.1) Fusion Applications OBIEE : How to determine and set permissions for…

Hello @Faisal.Iqbl, Can you please review the below to see if you can find any subject areas in OTBI for your requirement. Thanks, Praveen

Hello @sakthi.paramasivam, What is teh exact question here ? I see the title as "item cost" but no description of the issue. So please update your question for us to review and assist you further. Thanks, Praveen

Hello @JR Bendo-Oracle , FRS Report issues needs to be posted on FA-FIN Customer Connect Forum - Thanks, Praveen

Hello @ravinat , Can you please post the Enhancement/Idea in the Idea Labs for Oracle BI Development to review further. Thanks, Praveen

Hello @ravinat and @Regie Mercado , As it is 'Measure Column' OTBI will not allow to suppress the values. Only alternative will be putting it as a pivot view. Please review the below CCC discussion on a similar issue. Thanks, Praveen

Hello @Ali Mostafa_connect, As of now, there is no mechanism to get the encrypted output to Emails or directly downloading from BI Report Job History as the PGP key needs to be setup for the delivery channel in BI Administration page. Thanks, Praveen

Hello @GDunlap, In Fusion SaaS Environments, Yellow are Fusion BIP Reports Blue are Fusion OTBI Reports called OTBI Analysis. Thanks, Praveen

Hello @PushkarKumar , This is not a BI related question, So the question needs to be raised in HCM - Payroll community. I did search on MOS Knowledge base and found the below documents. Fusion Global Payroll: BANK_ACCOUNT_ID Column Does Not Hold Any Value in PAY_PERSON_PAY_METHODS_F_ Table After Setup of Audit Policy for…

Hello @User_N1V7T , Can you please try the below navigation for the audit report on both OTBI and BIP. Log in to Fusion Application — Navigator - Tools — Audit Reports — Select Product as "Oracle Business Intelligence Enterprise Edition" and fill other parameters as required — Search. Also you can try the below documents…

Hello @Shanti Kumar , Can you please review the below document and see if it's helpful. Thanks, Praveen

Hello @SusanSandifer , Can you please try teh below document for all the available audit reports. Security Reports in Fusion Application (Doc ID 2210883.1) Thanks, Praveen