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
-
Duplicate data for employees Worker Assignment Real Time & Employment Contract Real TimeSummary: We have an analysis to fetch the full staff list. Recently, we have updated some position with new departments and parent positions due to organization restruct… -
How to Output a Table Entered in HTML Format in a Document Using BIPSummary: I am creating a document using BIP. I want to output table data entered in HTML format. I would like to confirm the following two points: What kind of SQL state…
-
How to link pay_costs table back to an organization_idSummary: How can I get pay_costs info to tie back to an organization_id? We want to be able to derive our costed department name the same way that the costing segments a…
-
How to handle "Personnel File Request" in Oracle HCMSummary: Hello, Per Personnel Records Review Act, Current and Former employees can request their Personnel File information from the employer. I would like to know the f… -
How to remove blank line from RTF template report output?There is a BI report(RTF Template) with the following data as output: Name: DOB: Gender: DOJ: The requirement is to hide DOB(both text and the value) for a certain c… -
User Entity to extract Absence plan enrollments of an employeeSummary: I have a requirement to extract all absence plan enrollments of an employee , using HCM Extract. I am looking for a User Entity which can suffice this need. The…
-
Employee details at the time of the absenceI would like to report on the worker details at the time of the absence. If for example an employee changed department today, the absence from last year would show the d…
-
360 peer review participants not showing in OTBI reportI am trying to create a report to show the name of the peer participant and status of the task for a 360 document. The only names that I can get to appear are the employ…
-
Need help on combining these two analysisSummary: Hi, I have to create an OTBI report(attached screenshot) where I have to show voluntary termination/active HC and total termination (vol+invol)/active HC in one…
-
Perfermance Status Chart (SPI AND CPI)Summary: In which type of Analysis the said graph could be made. Thank you for your prompt attention to this matter.Looking Forward for your reply. Version (include the …
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent… -
send alert to employee department headwe need to Alert notification to employee department Head, could you please assist on this
-
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time…
-
Calculated Eligibility fieldSummary: Hello, We're trying to extract the Calculated Eligibilty column in SQL, as we need to know the value if it's Forced Eligible or Eligible. However, we cannot fin…
-
How to pull employees and contingents on a OTBI report along with seniority datesSummary: Hello, I am trying to pull both employees and contingents on a OTBI report along with seniority dates. I am noticing that since contingent workforce donot have …
-
Unable to see newly created elements in OTBI reportSummary: I am using the attached report and am able to see elements on employees/pending workers. We recently created some new elements, and I can't get them to pull eve… -
extract best-fit results from the HRT_PROFILE_BESTFIT_RESULTSummary: I access the HRT_PROFILE_BESTFIT_RESULT table to extract the values in the following columns (COMPETENCY_SCORE,WEIGHTED_SCORE), I can't find the plain text desc…
-
Custom Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information…
-
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi… -
Set up a virtual/matrix organization in Oracle HCMSummary: In our organization, there is a regular organization hierarchy showing the line manager and its department. However, as we move more into an agile way of workin… -
Moved: Locked Goals IssueThis discussion has been moved. -
Not enrolled in Waive but showing on OTBI report, along with standard enrollmentIn OTBI using Benefits - Enrollments Real Time, we are getting 2 records on some employees - 1 enrollment in Waive and 1 enrollment in Medical. They are only enrolled in…
-
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay Content (please ensure … -
How do I Round Down my TIMESTAMPDIFF formulaSummary: I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years. Content (pleas…
-
Call a bi publisher report from redwood pageSummary: Hello, Recently we have transformed absence standard page in fusion to redwood, can I call a custom BI Publisher report from this page and pass specific paramet…
-
PVO hcm extracts what types should be used and how ?Hello , We would like to use PVO extracts of Oracle of HCM type. Purpose -to get the worker (employee) details including their current manager, location, assignments, et… -
Requisition: Is it possible to create a report to see who deleted a candidate from a requisition?Hello, Is it possible to create a report/analysis to see who deleted a candidate from a requisition? If so, could you please tell me how? I am not so familiar yet with O… -
Moved: Trying to invoke candidate attachment REST API through PL SQL procedure giving errorThis discussion has been moved.
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…
-
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are…