Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce… -
Address Validation report for USSummary: Hi, Do you have sample address validation report for US? Thanks, Content (required): Version (include the version you are using, if applicable): Code Snippet (a… -
Worker dropping off report if null value in one columnWe're using the Workerforce Management - Worker Assignment Realtime and Workforce Management - Areas of Responsibility subject areas for the report I've attached below. … -
How to create .txt files using burstingSummary: Requirement is to generate a .txt file with Job Posting description for Job Requisitions meeting certain criteria Content (required): We are having issue in gen… -
How can I use parameters that work independently from each other on a single dashboard screen?Hi, I have multiple reports that I use on the dashboard screen and my 2 reports have promts. And from these separate promts there are common ones. I want to use the sepa… -
How to report on reports in the catalogSummary: We would like to report on the reports currently in our instance, is there a report i can run or how is that done Content (required):We would like to report on …
-
Need to customize a workflow notification but cannot see 'Customize' in the More dropdownSummary: Need to customize a workflow notification but cannot see 'Customize' in the More dropdown. I have a custom BI Admin role. Am I missing a permission to be able t…
-
Query to extract the last update author for document record fieldsSummary: Hello experts, please, could you share the query to execute in order to find the author of the last update on document record fields? Thanks in advance for your… -
Need to fetching displayvalue of payroll time type from time entry layout component.Summary: Hi, We want to fetch the display value of the payroll time type from the time entry layout component. I am not able to find it in any OTL subject area. Has anyo…
-
Skills OTBI reportSummary: Dear Experts, Please could anyone help how to extract the OTBI report to find how many employees updated the Skills in the Oracle? Kindly help with the subject … -
How to show only the MAX response attempt for a questionniare response in OTBI analysisSummary: We have an OTBI Analysis that returns information based on a checklist questionnaire. Employee can be asked to review and revise this content. We then want to p… -
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we … -
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe… -
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Link external data inside BIP reportSummary: Hi! I have an external data that is in excel file, is there a way to import this data into BIP and access it inside the data model? If yes, kindly share a docum…
-
Can't see absence reason in reports after putting end date inside the relevant absence typeSummary Can't see absence reason in reports after putting end date inside the relevant absence typeContent Hi, We have an issue that after putting the end date to an abs…
-
Inquiring logic used in one field of OTBI reportSummary: Need to know the logic used to calculate the field 'Years of service' Subject Area: Workforce Management - Work Relationship Real TIme Measurement Name: Years o…
-
Report on Assessment in LearningSummary: Hi Reporting Experts, Is it possible to build a report on assessment for OLC in which we can determine who has changed assessment questions and date and time of… -
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…
-
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea… -
Report to Audit Approval Rules ChangesSummary: Just trimmed back access to Transaction Console, but would like to see who made the most recent Approval Rules changes to workflows, and when the changes were m…
-
Can you use wildcards in a CASE statement?Summary: I have an analysis where if the Job Name is like 'abc%', '%hpr%', then I want to display certain text. Note that there are multiple wildcards, some only before,…
-
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…
-
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 …
-
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…
-
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):
-
Length of Time in Job OTBISummary We have a reporting requirement where we need to capture the Length of Time in Job. Is it possible through OTBI? -
HR Security Access - ReportsSummary: HR admins have access to salary data for the organization, except for within the HR department. They are not authorize to see each other's salary data. We had c…