Upvoted !!!

Hi Sean, Can you please choose NULL values passed instead of All values passed? And modify your conditions like below: AND ( "Employee"."Employee Name" in (:P_Name) OR (LEAST(:P_Name) IS NULL)) AND ("Labor Schedules Details"."Status" in (:P_Status) OR (LEAST(:P_Status) IS NULL)) Thanks.

Hi @User_A7VIB , Welcome to the Oracle Analytics community. This community is dedicated to specifically to Oracle analytics. I can see your query is specific to Peoplesoft, so please raise it on customer connect —> people soft category: PeopleSoft — Cloud Customer Connect Thanks.

Hi @User_GEH6D , Welcome to the Oracle Analytics community. This community is specific to Oracle analytics. And your question is more related to Oracle SaaS application. For any application related queries, post it on customer connect: https://community.oracle.com/customerconnect/ Also, I see you have posted this is an…

Hi Faizan, Welcome to the Oracle Analytics community. You have posted this question under an incorrect category. The "Oracle Analytics Videos" category is a gallery to display the Oracle Analytics community videos of demos, keynotes, events, tutorials, trainings and more! You can check all the available categories under…

Hi Faizan, Are you looking for the content of FYI notifications or what notification is tied to what process in HCM? Please elaborate. Thanks.

No issues. Currently, there are 3 main oracle communities: Oracle Analytics: This covers mainly analytics - FDI (FAW), OAC, Fusion BI publisher and OTBI Cloud Customer connect :- Community for all queries related to Oracle products and applications in cloud other than analytics. Oracle University - For any queries related…

It is a type of template only where you can get csv/txt output format as per you need. Check below link: Creating eText Templates Thanks.

Hi Ivony, As CSV is a data format, so it is dependent upon the data model. As there is no template, you can't hide the ID columns. But if you don't need IDs, you can remove them from the select clause in data model or create an Etext template. Thanks.

Thanks for sharing the resolution with community. Appreciated !!

As per my knowledge, there is no direct way to extract that data from a single table. Please check similar thread: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A — Oracle Analytics Thanks.

Can you verify your source query? Are you pulling the correct data? If possible share the piece of code to get this url to verify. Thanks.

This will be a great enhancement. Currently, in our organization, we are replacing one the existing fields with a new one and we have to scan through all the reports one by one. If we can get to extract the SQL statements, it will definitely help a lot. Upvoted. Thanks.

Hi, If you are looking for an exact replica of audit information that you see from UI audit reports, that is difficult to get. Are you facing any challenges with seeded audit reports? You can however build your custom logic. For all objects where audit is available, a corresponding shadow table exists (with same name as…

Can you please confirm the exact details for what modules you need or your are looking for a specific object? Thanks.

Hi Francisco, This forum is specific to Oracle Analytics. For any specific queries to other products, please post it on cloud customer connect: General Ledger & Intercompany — Cloud Customer Connect Thanks.

Hi Vrinda, As per my understanding, you will not be able to get the number of times the approval was done. That history is not maintained. You can only get last appoval if the transaction is approved and current assignees if in progress. Thanks.

Thank you @Benjamin Arnulf-Oracle @Daniel C Mohan-Oracle @Farivar Javanbakhti-Oracle for this opportunity. I am grateful for your support throughout this journey. Your kind words mean a lot to me!!! Thanks to all my other community peers. This learning journey is not possible without the amazing community peers.

Thank you @Benjamin Arnulf-Oracle for putting this together. In addition, people should avoid posting duplicate posts on the forum. Thanks.

Can you check if below help? How To Compare Budget Versus Actual Balances? (Doc ID 2068897.1) How to create actual vs budget and variance report? — Cloud Customer Connect Sample Report: Project Financial Management Cloud: Project Budget vs. Actual — Cloud Customer Connect Thanks.