Hi @User_9ZFXH, Can you please try the following to see if it is working for you? SELECT DISTINCT G.CERTIFICATION_NAMEFROM GRC_ACN_CERTIFICATION_VIEW G WHERE 1=1 AND G.CERTIFICATION_NAME IN ( (:cert_name_p) OR LEAST(:cert_name_p) IS NULL ) Hope this help. Cheers,

Great idea, It'll be a very helpful feature to have and will save so much time. Upvoted.

Great idea. It'll be a great feature to have. Upvoted.

Very useful & helpful information. Thank you very much @User_E4X3H!

Thank you very much @Avinash Krishnaram-Oracle! It'll be very useful.

Wow that's awesome and seems like a grand successful session! Thanks for sharing @Benjamin Arnulf-Oracle!

Hi @User_E4X3H, Glad to hear that. Can you please accept the answers that helped you to resolve your issue? It'll be helpful for fellow community members in future. Thank you! Cheers,

Hi @User_E4X3H, Sure. Please find attached latest files. Give me a shout if you need for previous versions. Hope this help. Cheers,

Hi @User_E4X3H, Thanks for the details. Yes, your understanding is correct. If you are looking for all the available objects, lineage etc. please take a look into the following posts.…

Hi @User_E4X3H, Can you please provide some more details regarding your requirement & query so that fellow community members can help you. Cheers,

Hi Giorgia, Glad you are able to solve the issue, that's great news. Thank You! Cheers,

Hi @Vishnu.R, Please take a look into the following Oracle notes which might be useful. https://support.oracle.com/knowledge/Oracle%20Cloud/2435208_1.html https://support.oracle.com/knowledge/Oracle%20Cloud/2061331_1.html Hope this help. Cheers,

Hi @Sumanth V -Oracle, Very informative & very helpful information. Thank you very much! Cheers,

Hi Giorgia, It seems from the error message that the user who is trying to execute the report has no access to the report or the report folder ('/Custom/XX_xxxxxxxxxx/xxx_xxx_xx_xx.xdo'). Please check the existing security / permissions currently present at the above folder and either add the user on existing groups that…

Hi @Stefano_Mazzocca, No problem at all. Thanks for the details. Yes, you can certainly do it. Just define few Exception (Data Quality) reports based on your requirement. These reports will only return data if that particular condition occurs. Here's an example for you using OTBI SA: Workforce Management - Worker…

Hi @Stefano_Mazzocca, Thank you! In this case you have to have a look into the Oracle HCM Person Record and correct the data accordingly there. Here's an example: Say, there was no Date of Birth for Bhaskar Konar which is returned by the FDI Report. Now if you check into the HCM Application the same person has no Data of…

Hi @Stefano_Mazzocca, Quick Question: What is your source application (Transactional System) here?

Hi @Stefano_Mazzocca, Thanks for the details. You can create some exception / data quality reports in your FDI instance based on the area that you want to check. i.e. You can create a report which will give you all persons details for whom Birth Date is NULL or Salary not present. Now based on those data you can correct /…

It'll be very helpful. Thank you very much @Daniel C Mohan-Oracle!

Hi @User_PGUES, Please take a look into the following article which might be useful. https://blogs.oracle.com/fusionhcmcoe/post/auditing-for-oracle-cloud-hcm Hope this help. Cheers,