Get Started with Redwood for Oracle Cloud HCM Begin Now
Reporting and Analytics for HCM
Discussion List
-
Please guide how to get audit trail report for "Add / Modify Reports" and "Modify Configuration".Please guide how to get audit trail report for "Add / Modify Reports" and "Modify Configuration". We want to check who is add a new report or modify any report in tools … -
Which table stores the acknowledgement date of performance document and comments entered by employeeSummary: We are trying to customize one performance module seeded report. In the report, we are trying to fetch whether document is acknowledged by employee or not. If y…
-
Exclude Data Models in BI Search ResultsWe don't want end users to see data models in BI. We have followed the typical approach of saving data models in a Data Models folder where the permissions on the folder… -
Is there a report that lets you know when there is an empty position with direct reportsSummary: Hello - We are trying to find out if there is an alert, notification, or OTBI report that is delivered when there is an empty position with direct reports. We w… -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…
-
ORACLE FUSION HCM QUERY TO GET USER ACCOUNT LOCKEDSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…
-
Unable to find Title field (on Record External Learning Experience page) in OTBI ReportHi Team, We are unable to find below field in my OTBI report. Could you please help us to find the same. Field Name: "Title" (on Record External Learning Experience page…
-
Query to fetch the individual Manager Rating and Employee rating corresponding to each Goal.Summary: I am creating a custom report to get the employee and manager ratings for each performance goal. I got the summary ratings from table 'HRA_EVAL_RATINGS'. But fo…
-
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… -
Query to get costing and Element linkSummary SQL Query to get costing segment columns and element link name columnContent Hi All, I want to pull the costing segments along with credit, debit amounts and ele…
-
Can i see what a user sees from PER_ASSIGNMENT_SECURED_LIST_VWe have a user downloading a report but seeing just 600 result compared to another users that can see more than 800. The only thing in the report that could prevent him …
-
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 …
-
Logic to know the Insert/Update/Delete as Audit Action in Audit Salary Report for HCMWe want to build an HCM audit report in OTBI. HRDirect needs an audit report to see when a salary change was added, updated or removed an individual. Filters: Employee I…
-
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.… -
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…
-
How to track candidate personal information changes by themSummary: How can we track the changes done on Personal Information on a candidate profile Content (please ensure you mask any confidential information): If a candidate c…
-
recruiting - recruiting real time Candidate AttachementHi Experts, I'm trying to fetch candidate attachment files/URLs by using this recruiting - recruiting real time OTBI. Unfortunately, I can't see any attachment files or …
-
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… -
Asking for some tips for these column in OTBI to BIPSummary: Hi there!. May I ask some idea where I could find these columns in BIP - Report Content (please ensure you mask any confidential information): Version (include …
-
Can you pull columns from one OTBI analysis report to another like a Vlookup?Summary: We have created a Checklist Task which has a DFF that generates a Person Number ("Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_DESC_NOMINEENAME_") an…
-
OTBI excluding the requisitions that are in any other phase other than "Open"I am creating a report using "Recruiting Real Time". The report works fine when i run with the basic attributes like Requisition number, name etc. But as soon as i inclu… -
Compensation Business Process Dashboard Access ControlSummary: Business requirment is to restrict access to the seeded Compensation Business Process Dashboard for Line Managers. Identified that Workforce Transaction Analysi…
-
Role for OTBI reportSummary: Role for OTBI report Content (please ensure you mask any confidential information): Hello experts, we have created a custom role (BI-Abstract) that allows users… -
Learn Report not able to access ActivitySummary: After we enabled redwood, our learning reports stopped working. upon checking, in offering hierarchy table "WLF_LI_HIERARCHIES_F" the type is coming as "ORA_CLA…
-
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol… -
Transaction table is not storing the details of all offer approvalsSummary: Hi Team, We have a requirement to get the offer approval history from transaction table. The issue we are facing is the table we are using does not have the det… -
Error message: ORA-01898: too many precision specifiersSummary: Error message: ORA-01898: too many precision specifiers Content (please ensure you mask any confidential information): Hi, we have run the SQL query I attached,…
-
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a… -
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…