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
-
Oracle HCM BIP Report - Employee Hierarchy querySummary: I have a BIP requirement to display the employee details in the report where I need to show the employee details like tree structure. Eg: Manager A has 2 report… -
Which PVO contains the organization unit legal info ?Hi, Do you know which PVO contains all the legal info of the organization unit in hcm please ? I'm trying to augment the data for FDI and I'm not able to find the right …
-
Seeded Line Manager Role cannot view Future-Dated Hire Events in OTBIContent Hi, We have a report on a Line Manager Dashboard that looks at future-dated hires. For this, we are using the "Workforce Management - Worker Assignment Event Rea… -
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i…
-
Fetching image in BIP RTF template from personal information type document of recordsHi All, we have requirement for generating DOR letters, to print image available in document of records attachments section(document type=personal information) Please su…
-
Query overview ofreports and analysis from analytics?Summary: I would like to query the names and file paths of all reports, analysis' and data models in a specific folder in Analytics in HCM. I am specifically looking for… -
Accrual ReportHello All, Is it possible to get Accrual rate in OTBI report? Thank you, Shameer Shaik
-
A HCM BI Report is giving extra duplicate pages but the output is valid (the o/p is 1 page gives 2)Summary: A HCM BI Report is giving extra duplicate pages but the output is valid. If the output is 1 page it gives 2 pages of same data only in production environment. I…
-
requires work schedule table which has effective from date as columnHi Team, We want to use work schedule effective start date to differentiate which day will be week off and working day of the employee in the report. Please suggest the …
-
BI SFTP connection no longer working due to Key Exchange Algorithm DeprecationSummary: One of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1 SSH Kexs on the target serve…
-
Display month name's with sorting in OTBI Analysis outputsSummary Display month name's in OTBI Analysis outputsContent Hello Team, I have created OTBI report in that month column value should be displayed like Jan, Feb, Mar, et…
-
element eligibility criteriaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How can i get Performance current task name in OTBI?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI report Fetching both Active and Inactive Records when select only Assignment status as ActiveOTBI report Fetching both Active and Inactive Records when select only Assignment status type as Active from Subject Areas : "Workforce Management - Worker Assignment Re…
-
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the report history in the front en, but I'm unable to find related rec…
-
Need a sample query of Team Time Card page, to fetch Reported hours of Calculation Time.Summary: Query to fetch Reported Hours in Calculated time section of Approved Time cards for an individual. Content (please ensure you mask any confidential information)… -
How to use nvl function in excel templateSummary: Using NVL function in excel template for Extracts Content (please ensure you mask any confidential information): Hi All - We have a requirement to fetch the req…
-
Table which stores the goal commentHi Team, I am working on BIP report to get the Goal details, I am using below tables for the report. HRG_GOALS HG HRG_GOAL_PLAN_GOALS HGPG HRG_GOAL_PLANS_VL HGPL HRT_REV…
-
Report on SkillsSummary: Report on Skills Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard or shared reports about Dy… -
Recruiting - Recruiting Real Time not showing jobs with 0 applicationsHi all, I am trying to build an analysis using the subject area "Recruiting - Recruiting Real Time". The issue that I am seeing is that, I am only getting results of job… -
EducationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Each sheet of a BIP report extraction is extracted to a different Excel fileSummary: Each sheet of a BIP report extraction is extracted to a different Excel file Content (please ensure you mask any confidential information): Hi Each sheet in the…
-
How to maintain the number format when a BIP report is exported to ExcelSummary: Maintain the number format when a BIP report is exported to Excel Content (please ensure you mask any confidential information): Hi When a BIP report is extract…
-
Can I make an Academic Year 'Time' dimension in OTBI?Asking for a colleague Hi all, I need to show workforce trends over time by Academic Year e.g. 2023/24 = 1 September 2023-31 August 2024. I have successfully made time s… -
I need to get the updateddate of the workflow when it is approved submitted by employeeSummary: I need to get the updateddate (FA_FUSION_SOAINFRA.WFTASK) of the workflow when it is submitted by employee in the manage document of records. I am using below q…
-
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: … -
Person Legislative Information Field Teacher Reference Number no longer showing dataSummary: After 24c was implemented on our Production environment we noticed that one of the fields in the subject area was no longer producing any data. The field in que…
-
Areas of Responsibility - No Results when including Worker DataSummary: No Results is being returned when including any Worker data into an analysis for Areas of Responsibiltiy Content (required): We are creating an analysis using t…
-
Performance Manager Not Appearing in AnalysisSummary: We are trying to create a report for our Performance Reviews that is able to show us an individuals Performance Review Status, Score, and other details. As part… -
Display Person Images on BI ReportContent Hi All, Do you know how to display Employee's image on the BI Report? Images are stored as BLOB files, then how can we display them? Read on to know more details…