Category 81
Discussion List
-
sum of 2 columns to be shown in 3rd column in OTBISummary: Hello, We are trying to sum 2 columns data and show it in 3rd column, however, it is not working. candidate-Job Applied + Candidate-Prospect = Total Referred Ca…Shiva Prasad M 122 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
BI Publisher - Filter Action NameSummary: I have a SQL query that was created by our vendor. I am still a beginner in using SQL so I am seeking assistance in how to filter the report to pull certain act…
-
Report Job Offer Employment Category in AnalysisSummary: I want to Report the Employment Category of a Job Offer in an Analysis Content (required): I use the Subject Area "Recruiting - Recruiting Real Time" and can't …Felix2 15 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Learning Count Using Disability StatusSummary: Using the Workforce Learning - Learning Records Real Time Subject Area to pick up disability (which is using Workforce Management - Person Real Time to count th… -
Query About Column Names for Source Tracking.Summary: I am creating one BI report in which I need to pull application source and application source details. In which table i can find it? I have checked in IRC_SOURC…Rajib_Samanta 79 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Facing issue unable to override Willing to relocate filed by using HDLSummary: We cannot override existing field that is "Willing to relocate " while updating existing field through HDL it is creating one more record. Navigation: Directory…User_2025-07-18-06-45-42-477 35 views 2 comments 0 points Most recent by MandeepGupta HCM Data Loader (HDL)
-
Hi, I hope everyone is doing well. I need help to pull every column from Oracle HCM (BI Query) .Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Karthi 36 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Export to excel for an OTBI analysis in Guided JourneysSummary: We have deployed an OTBI analysis in Guided Journeys that would be most useful if the user could export it to excel. Is there a way to incorporate this feature …Amy Wilson 60 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I fix some columns in the Analysis report?Hi I created a report from analysis and set it to Fixed headers with scrolling content. But I have too many columns in my report, so I need to freeze 3-4 columns. How is…Cansel Karasoy 48 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
SQL for compa ratioSummary: Need correct SQL to find Compa Ratio Content (required): Hello, I am writing a report for the business that includes the compa ratio as one of the columns. And …SeanWesche 61 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manage IBAN with REST APISummary: Content (required): Hello everyone, We are having issues using the REST API to add an IBAN for a waiting employee/worker. In particular, we have developed a cal…
-
Fetch users who have NOT logged in since past 30/60/90 days and send reminder emailSummary: Fetch users who have NOT logged in since past 30/60/90 days and send reminder email Content (required): I need to fetch list of users who have NOT logged in sin…Neelesh Varma 337 views 4 comments 0 points Most recent by Neelesh Varma Reporting and Analytics for HCM
-
How many WorkEmails can we add to a filter while creating a Filter in Alert ComposerSummary: Trying to add work Email Id's to an expression using 'OR' operator. Has anyone used it before and know how many emails can we use in one batch. Content (require…
-
Ability to track the number of times learner retook/reviewed an already completed learning itemSummary: Looking to create a report that gives the number of times a learner has reviewed or retaken an already completed learning item. Is this information recorded, an…KatHugh 46 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Looking for table for salary change action and reasonSummary: Looking for table for salary change action and reason Content (required): Which table holds the salary change reason and action? This is not the same table whic…Parag Hiremath 1.4K views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Filter based on custom values in promptSummary: How to filter analysis based on custom values in prompt? Content (required): I have a variable prompt which has custom values like ALL, Female, Ethnicity etc. i…Raghavendra M 47 views 4 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Error While opening OTBI ReportSummary: Error While opening OTBI Report Content (required): Hi Everyone, While opening the OTBI report, it throws me following error. As per the document Doc ID 2083725…
-
GETTING ERROR WHEN USING TWO SUBJECT AREASummary: I HAVE ONE SUBJECT AREA "Procurement - Procure To Pay Real Time'' I SELE CT PO NUMBER , CREATION DATE , CLOSED DATE, AND FROM ANTHOR SUBJECT AREA ''Procurement …
-
How do I create a learning category headcount report?Summary: I am having to create new reports for the new Learning Subject Area (Workforce Learning - Learning Records Real Time) due to the Learning Management Subject Are…
-
Unable to hide prior incumbent details in position FTE reportSummary: Unable to hide prior incumbent details in position FTE report Content (required): Unable to hide prior incumbent details in position FTE report. Following scree…Manoj.Gupta 95 views 6 comments 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Different Learning Metrics - Existing dashboard resource?Summary: Content (required): Hi there at the end of the year we need a number of learning reports. I have a few organised but I was wondering if there is any resource re…Bobby Jourdan 37 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to display MTD, QTD in payroll register report for latest processSummary: How to display MTD, QTD in payroll register report for latest process Content (required): As of now payroll register report displaying only Run and YTD values. …Munazeer Shaik 37 views 1 comment 0 points Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM
-
What is the best way to mass assign a Dashboard to a large groupSummary: Only a small handful of employees use the reporting system. I am building several Dashboards for various teams, and was wondering the best way to get those folk…Wesley Morgan 16 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
How to Capture a Work at Home Flag Change in a report?Summary: Content (required): Hello Experts, We need to report on instances when employee's Work at Home flag changes from 'no' to 'yes' and from 'yes' to 'no'. Does anyo… -
Calculation Cards TRUSummary: I would need to get the value of TRU in Calculation Card. I am unable to find the table name. If anyone could help on this, would be really great. Screenshot At…
-
Exception: The job attached to employee must have an EEO job category.Summary: Hi All, I am getting this in the EEO1 exception report . Any idea why its throwing this error? I have made sure that all the jobs that are used have the EEO cat…Gaurav Rath- PGC 56 views 3 comments 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM -
Can a column name be modified but also translated?Some standard colom names are not suitable for our organization but if I change them the name will be fixed. For example if I change the language settings the name of th…
-
Attrition and Turnover ReportsSummary: Need to develop an analysis for Attrition and Turnover Content (required): We have a below requirement for Attrition and Turnover Reports, can anyone share the …Raghavendra M 672 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli…Izliana 34 views 1 comment 0 points Most recent by Maria Croitoru-Oracle Reporting and Analytics for HCM -
Adding a Page / Tab to Front End AnalyticsHello, Apologies if this is the wrong place to ask but I'm building several infolets to be used and was wondering if anyone knew if it was possible at all to add an extr…