Hi Bhanu Priya, Welcome to the Oracle analytics community. Can you please provide some more details on the product that you are using? Are you talking about BI Publisher? If yes, please suggest the template type that you are using. Is it eText, RTF, excel? You also need to select the appropriate category based on the…

Hi Shelly, Welcome to Oracle Analytics Product forum. Unfortunately, there is so subject area currently for Total Compensation statement. Hi @Gail Langendorf-Oracle , Hope you are doing well. As per below post you mentioned, that there will be a subject area for comp statements. Do you have some timeline when this SA would…

Hi Dave, One option is to use LSQL. Please check out the below example: Workers and Managers Position Report — Cloud Customer Connect Thanks.

Hi Jason, Welcome to the Oracle Analytics Community. Can you please elaborate your query and give some information of your data model and what you are trying to achieve? This will give an idea to the community about your exact requirements. Are you designing an xpt report? Thanks.

Hi Arun, Welcome to Oracle Analytics community. I understand your question is more related to workbench configuration than BIP reporting. You should post your query to customer connect for SaaS application related issues for better traction and response. Payables, Payments & Cash Management — Cloud Customer Connect Thanks.

Hi Faizan, Please check the sample query on below url and let me know if you face any issues: https://fusionhcmconsulting.com/2022/11/bip-query-to-extract-supervisor-details/ Thanks.

Hi Gaurav, Welcome to Oracle Analytics community. This feature is currently not supported. Below idea has already been submitted for same. Please check and evaluate the below idea and upvote it if you feel it will be helpful: Automation of OTBI reports for version source control and deployment — Oracle Analytics Thanks.

Upvoted. This is required for auditing.

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.