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
-
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'… -
Looking for lineage data for a few VOs which are missing in Rel13_24C_BICC_HCM mapping sheetSummary: Looking for linkage details for following PVOs. These are not deprecated but missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects sheet. Any help wil… -
How to make a BIP deep link opens in the same pageSummary: How to make a BIP deep link opens in the same page Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
Looking for linkage details for some of the Fusion HCM PVOsBelow is the list of PVOs which are missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects. If anyone happen to have these details please share. Hcmtopmodelanal…
-
Passing the parameter at run time from the URLI am creating a BIP report and want to pass parameters from the URL. For example, I have a report with a parameter for Assignment ID. When I open the report, it should l… -
LAG Function not able to pull previous job of an employee.Hello Experts, I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job, but i turns out to fetch the same data …
-
OTBI Performance Management Summary dashboardSummary: Need path for this seeded report dashboard Content (please ensure you mask any confidential information): Our customer has this screenshot showed and mentioned … -
24C Worker Sensitive Informationhttps://docs.oracle.com/en/cloud/saas/readiness/hcm/24c/hure-24c/24C-hr-wn-F34150.htm#hure-24c-f34150 I am testing the Secure Reporting on Worker Sensitive Information f…
-
Can we add Settlement Date to OTBI reportSummary: Can we add settlement date to OTBI reports? Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…
-
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…
-
HR benchmarking data - best practicesHello All We have recently been requested to pull HR bench-marking data, so we can do some analysis on KPIs and metrics that represent the typical performance within our… -
looking for ytd and ptd bip reportSummary: lookind for ytd and ptd bip report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Co…
-
Veteran Self-Identification Status - no results in OTBI Person Real Time SA **Updated**Summary: I have the 'Veteran Self-Identification Status' along with the other Veteran statuses in multiple analyses and dashboards. Recently, sometime after 8/15/2024, t… -
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg… -
CMP_ASG_SALARY_V we need these fields zone_name,ZONE_TYPE_NAME,ZONE_TYPE_ID,ZONE_ID related querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
In OTBI, how to set the filters to fetch data between the last 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…
-
Getting different employee counts using the same filtersSummary: I was getting inconsistent employee counts on a dashboard I was working on so I created 2 different analyses from different subject areas and applied the same f…
-
Recruit to Hire Dashboard customizationHi Team, As we have seeded Recruit to Hire Dashboard, we want to have customized dashboard based on our requirement. we want to hide below items from the dashboard. Can …
-
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo… -
Terminated Employee QuerySummary: Can anybody Please share a query where the Terminated Employee should be Pulled in the query on the Day of Termination as Active Record. Content (please ensure … -
Custom folder structureSummary: My client wants to change the Custom folder structure. My client does not want path to be Shared Folders > Custom > Human Capital Management. My client wants to… -
New fields not showing any data in rtf template for document of recordsHello, I have one Document of record which is working fine but requirement is to add 3 new columns in that , For example Notice period/Hours and contract so i added all … -
Email Notification Report for NudgesSummary: Email Notification Report for Nudges Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to get the list of email …
-
How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…
-
Excel template missing row header infoSummary: I have converted an Excel template to display in rows rather than columns. I have updated the Name Manager and the results display as expected however the param… -
How to enter a Column Group in a OTBI reportSummary: How to enter a Column Group in a OTBI report Content (please ensure you mask any confidential information): Hi, we would like to create a new OTBI report, which…
-
Need assistance on Bursting report for Visa and Passport expirationSummary: Hi, Our requirement: The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days. Currently Alert composer… -
Send Email to multiple employees based on the region they belongHi Team, We have received requirement where we need to send the email to all pending workers who are based in an office, and provides important Day 1 information. There …
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…