Hi @Trent M, It seems default expense account is not available within OTBI Subject Areas. Here's a not from Oracle. Default Expense Account In OTBI Report (Doc ID 2492612.1): Document 2492612.1 (oracle.com) Alternatively you have to build a BI Publisher Report. Following query might be useful for you. This is stored in…

Hi @Brennan , Glad you are managed to resolve the issue. Appreciate the detailed insight. Thank you very much. Cheers,

Thank you very much @Sahithi Kolasani-Oracle & @Gaurav Bharadwaj-Oracle ! Appreciate your help. Cheers,

Hi @Palak Karma , It seems you're using BY clause outside of Aggregation Function. Your code has been changed a bit and now has no syntax error. Can you please check this one? ( SUM(CASE WHEN CAST("- Purchase Receipt Line Details"."Creation Date Line" AS DATE) < CAST("Purchase Order Schedule Detail"."Need By Date" AS DATE)…

Hi @Tom Buechler , As per my understanding currently no log is available in OTBI Cloud version which is not helpful at all. I've raised the following in the idea lab. Please have a look and feel free to vote if you like the idea. Detailed log for OTBI Agent — Cloud Customer Connect (oracle.com) Hope this help. Cheers,

Hi @ashrestha01 , I'm not sure about your exact requirement but please find below some OOTB Components that are available. Hope this help. Cheers,

Hi, Is that schedule being executed by the Recipient? if Yes, then it might be the security that's restricting the data. When you say the file is having 38K record who is executing that? Ideally ask the recipient to execute the report directly to see how many data they are getting. Hope this help. Cheers,

Hi @Ankit.Mahajan Glad it worked & solved your problem. Would you mind accepting the answer that solve your issue? It'll help the fellow community members in future. Thank You. Cheers,

Hi 55Chevy, Firstly print the column without any formatting and then check if you can see distinct values in the timestamp or not. If all the values are same in timestamp part then probably the column is not holding the correct Timestamp values and there's no point of doing the formatting. If it does hold unique values…

Hi @Ankit.Mahajan Probably you need to enable the download data options for that Report in the Dashboard Page. Please find below steps. Edit the Dashboard Page --> Go to the Section where the Report exists Click on ‘XYZ’ as highlighted below. Click on ‘Report Links’. Click on ‘Customize’ and then select ‘Export’ Save the…

Hi @Brennan , Can you please check the following note? Is there anything similar that can be explored ....? Document 2137038.1 (oracle.com) It might not be solving your issue but thought of double checking. Cheers,

Hi Max (@Max W) Glad you are able to fix it and you liked it. Cheers,

Hi Max, (@Max W) Please find attached document which might be useful. Can you please try the following? Use Double Column to Create Language-Independent Filters: Oracle Cloud applications store data in multiple languages. Hard-coding text string in a filter creates a problem with multi-lingual data. OTBI uses Double Column…

Hi Eva, Measure values can't be Suppressed in tabular view. Try with Pivot View. Hope this help. Cheers,

Hi @Abhishek Bagh, Glad it worked for you. Would you mind selecting the best answer that resolved your issue so that it'll help fellow community members in future? Cheers,

Hi @Abhishek Bagh , The formulas are really interesting, thanks for sharing. Would you mind using formula like below? Values will be on Float: CAST(TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date", CURRENT_DATE) AS FLOAT) / 365 without decimal: TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date",…

Hi Abhishek, Would you give some more details like what Tenure you are looking to calculate here? Perhaps you can attach your report xml / catalog if that's better. Cheers,

Hi Abhishek, I'm glad it worked & you find it useful. Can you please select the Best Answer that solved your issue? It'll help fellow community members in future. Cheers,

Hi Abhishek, There's a 'Manager Flag' inside 'Manger' Folder under 'Worker' Folder in Assignment SA, Person SA etc. BUT this is not a mandatory field in UI, as result it might not have always correct data. If your ORG has made that field as mandatory and making sure while creating data / transactions the values are entered…

Hi Abhishek, Try the following fields inside 'Manger' Folder under 'Worker' Folder in Assignment SA, Person SA etc. Also PFA a sample XML. Hope this help. Cheers, XML - Manager Assignment Status.txt