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 to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include… -
Does anyone have a SQL Query or OTBI report that will list by employee hours worked for the year?We are needing 2024 Paid Hours. We tried running the Periodic Payroll Activity Report but because the data is so large when including hours, it will not complete. I need… -
Historical report on positions held by active and inactive employee within a date rangeSummary: Looking for a historical report on positions held by active and inactive employee within a date range Content (please ensure you mask any confidential informati…
-
Matrix manager dimension in worker assignment real time subject areaHello Team, I have used attributes in matrix manager dimension of "Workforce Management - Worker Assignment Real Time" subject area to get all direct and indirect report… -
Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher ReportContent Hi Gurus, Can we Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher Report? I Created BI Analysis report and then Agent to call Analysis …
-
Show in OTBI Report the Phase and State Duration in Recruiting Event Real TimeHello Experts, I am creating a custom report showing how long or the number of days a requisition in its phase and state. I can see this field called 'Phase or State Dur…
-
OTBI Talent Review Rating HistoryHello, I need to pull a historical record of Talent Review ratings. I know it's possible to pull Performance Document rating history, but I'm specifically being asked fo… -
Dashboard on Development Area: hrr_tmpl_metric_configSummary: Goodmorning, we're fancing a problema with the Talent Review Matrix in the Dashboard Standard The matrix is empty: analyzing the query from the log, we've seen …
-
Long running BI report send notification message to userSummary: Hi Team, we have couple of reports are running in production environment are very long running its not throwing an error can you please suggest how to set the l…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable… -
Female turnover rates of DashboardI'd like to ask that if I select the Female as the Gender, how is the female turnover rates calculated? Is the denominator of the ratio in relation to all employees or o… -
OTBI report for role , Security Context & Security context Value access assigned to userSummary: Creation of OTBI report for role , Security Context & Security context Value access assigned to user Content (required): HI Team, We have one requirement to cre…
-
ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.Summary: How to solve ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Content (please ensure you mask any confidential informat… -
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…
-
Time spent per approver in workflow approvalsSummary: We have a requirement to report out how long a specific workflow proves (Approve Job Requisition) remained with each approver within the workflow. Is there a re…
-
How to Remove Duplicate Rows from Pivot table in OTBISummary: In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data? Content (please ensure you… -
Issue with the Custom Data roleHi, We are using a custom role titled "Hub Data Role - Hub Driver Services". Users assigned this role should be able to view all information related to that specfic job …
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…
-
-
how to remove blank line appearing at the top of manager and worker comments for employee objectivesWe have a custom BIP report for fetching the employee objectives and values details under performance module. The output of the report is in excel and while exporting th…
-
User who executed or modified a report in Publisher ?Summary: Is it possible to know which user executed and/or modified a report in Oracle Analytics (Publisher) ? Content (please ensure you mask any confidential informati… -
Scheduling FTP report - How to schedule multiple reports with one job?Summary: Our purpose is to launch only one job for multiple reports Content (please ensure you mask any confidential information): Hello experts, We have a requirement t… -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am … -
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…
-
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…
-
How to download the files that are uploaded in DOR against employeehi i have a query which shows al the files uploaded in DOR of emplyee . select fad.DOCUMENT_ID , fdv.DM_DOCUMENT_ID CONTENT_ID, fdv.datatype_code , fdv.FILE_NAME , fdv.T…
-
Line Manager Dashboard Reports for PerformanceSummary: The Delivered Line Manager Dashboard Report has lot of Tabs and For few tabs i am able to find the Analysis Report. For Performance I am able to see the Below D…
-
Cumulative Salary ReportSummary: Financial report of cumulative salaries per reporting period Content (please ensure you mask any confidential information): Hi experts I have a request to provi… -
OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job OfferSummary: Need Query Transaction Console Approver Name for Job Requisition & Job Offer i have tried this query select htce.object_name, htce.task_id task_id_hdr, htce.con…