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
-
How can I get only the latest results when reporting on the status of a certain training?Summary: I try to report on the status of a certain required learning to see who has not completed it yet. If the learning was deployed this year, but also the year befo… -
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…
-
While running whole population in OTBI we are facing issue.Summary: Content (required): we are using Pivot table output in the OTBI report for 1 or 2 employee it's working fine when we are running whole population, we are gettin…
-
Unable to see the Goal Status for Goal plan reportSummary: Unable to see the Goal Status for the Goal Plan OTBI report Content (required): Employee has submitted the goals for approval, but the same is not reflecting in…
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca… -
How to report date/time stamp when a Candidate Label was added.Summary: Content (required): is there a way to report the date/time stamp when a label was added to recruiting>candidate>candidate - labels> label Name ? I see there is … -
Report to get the duplicate element entries in a given pay periodSummary: Report to get the duplicate element entries in a given pay period Content (required): Hi Team, Greetings! Is there an existing report to get the duplicate eleme…
-
Alerts Composer - Has anybody worked on creating custom Alerts in HCM using Alerts Composer ? We havSummary Alerts Composer - Has anybody worked on creating custom Alerts in HCM using Alerts Composer ? We have requirements to create custom alerts instead of OTBI notifi… -
Mass Update messagesSummary: Content (required): What table stores the messages from Mass Update transactions? Version (include the version you are using, if applicable): Code Snippet (add …
-
Hide "Create Bookmark Link" LinkSummary: Dears we are trying to hide the link highlighted in screenshot attached but we dont understand how. OTBI is available to users within a dashboard, we already ch…
-
Using OTBI to fetch latest ACTIVE assignmentWe would like to use a filter which we can re-use to fetch the latest active assignment for a person. For 99% of our population, it works to do MAX("Worker"."Assignment … -
Invalid Number Error in fetching Basic Salary ComponentSummary: We are writing an oracle sql query to fetch different components in the salary for inactive employees. But it keeps showing below error on runtime. ORA-01722: i…
-
Can we hide a specific sheet in the excel output for some users?Content (required): We have an excel report which contains 2 tabs where 1st sheet contains the data dump and 2nd sheet is the actual report which is based on the 1st she… -
Total Actual Effort in Learning by DepartmentSummary: I am trying to write an OTBI analysis where we are able to pull in the total headcount of a department, the total actual effort hours of learning for that depar…
-
OTBI - How to get all workers who are hired, and transferred to the target department in 30 days?Summary: OTBI - How to get all workers who are hired, and transferred to the target department in 30 days? Content (required): Hi experts, Could you point me in the righ… -
Hiding Out of The Box Reports - (Human Capital Management)Is it at all possible to hide the folder that contains the out of the box reports (Human Capital Management)? I can see we can remove the 'BI Consumer Role' from our rep…
-
OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbentsSummary: OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbents Content (required): Hello, I'm building a data quality dashboard and would like to ask … -
Column Data to print inline using Logical sqlSummary: We want to print area manager value in single column if there are multiple of them, currently its printing in two separate lines. Content (required): OTBI repor…
-
Cannot display data on standard analysisSummary: Generic user cannot see data while admin user can Content (required): Standard Analysis "Recruiter Work Load Details" saved under /shared/Human Capital Manageme… -
Automatic parameter binding for contextual reportsSummary How to configure R13 functionality "Application Context Passing to Embedded Reports"Content We are trying to configure the solution "Application Context Passing … -
Reporting on OTBI and its Subject areas in UseSummary: There is requirement to check if there are any existing OTBIs that uses fields identified as sensitive. Is there a way to achieve this? Content (required): refe…
-
Performance Reviews for Inactive employeesHi, I am trying to pull a performance review for a terminated employee.When I go into the performance performance goals screen and search for the employee, he iş appear … -
Reporting Comments on Termination/Resignation Quick ActionSummary: Content (required): In classic UI, we were able to pull Employer Comment on OTBI analyses but that field is not available in RUX and is replaced with Comments a…
-
How to get effective date of analysis so only values with a date greater than a specific date show?We have a report build to view talent ratings and are using the subject area Workforce Profiles - Person Profile Real Time. Our report is currently showing every record …
-
FEIN Number in OTBI AnalysisSummary I'm trying to pull in the FEIN Number that my roster of active employees are assigned to. Is that possible?Version Oracle Cloud V20BUser_2025-02-04-18-03-17-329 142 views 18 comments 0 points Most recent by Venkateswara Rao Vadlamani
-
BIP reports emailed securely from HCM (by default)?Summary: BIP reports emailed securely from HCM (by default)? Content (required): We are scheduling a new BIP report to go to internal users and external (outside the com… -
What permissions do I need to run BI Publisher Web ServicesSummary: Getting this error when trying to run the runReport request for the BI Publisher ReportService: PublicReportService::generateReport failed: user: [XXXXX] does n…
-
Need table name for Additional Person InfoSummary: Need table name for Additional Person Info.Please refer the attachment for the screenshot.
-
How create a column by concatenating multiple columns in otbiSummary How create a column by concatenating multiple columns in otbiContent We have a requirement to concatenate multiple columns and print it as separate column in otb…
-
Need to display terminate records as on Yesterdays dateSummary: Need to display terminate records as on Yesterdays date Content (required): We are referring "Workforce Management - Work Relationship Real Time " subject area.…