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.
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
-
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act… -
Person Management>HCM Group Override - Cannot find this field in Reports and Analytics.Summary: Trying to build a report that includes the values of the field "HCM Group Override" in Person Mangement in Oracle Fusion. I cannot find this field, and I've loo…
-
Presentation variable in Column Filter possible?Summary: Hello all, Not sure if this is possible - I would like to use a variable inside a column filter, for example for YTD Actual I have filtered on scenario Actual H…
-
How to show an icon based on company?Summary: How to show an icon based on company? Content (please ensure you mask any confidential information): An icon of a report can be shown only if user has specific … -
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…
-
Add record ‘creation date’ in an otbi reportSummary: I would like to add the event 'record creation date' in an OTBI report I am developing, using the 'workforce management - worker assignment event real time' sub…
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…
-
Payroll Report HelpI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…
-
Payroll Report Pulling Wrong Assignment Manager in BI ReportI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…
-
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo…
-
Percentage of Employee With and Without Goals not showing properly in columnsSummary: Hello again, I need help to check my case statements. The % of employees with and without goals are not reflecting properly. CASE WHEN "Workforce Goals - Goal S…
-
SQL query that brings the fields to HDL for CostCenter?Summary: Content (please ensure you mask any confidential information): Does anyone have a SQL query that brings the fields to HDL for CostCenter ? Simple with the minim… -
URL from HCM Cloud page with one of the parameters = NUL not opening BIP reportHello We had a requirement to open a report from HR Help desk page. Initially we had OTBI report with 2 parameters, Primary Person ID and Affected Person ID. Even if the…
-
Can we display alpha numeric values in Pivot table?Summary: Can we display alpha numeric values in Pivot table? Content (please ensure you mask any confidential information): We have a requirement to fetch the UDT (User …
-
Talent Review in OTBIGood morning, we are fancing an issue in a OTBI report based on the SA "Workforce Talent Review - Talent Review Meeting Real Time" in the Dashboard standard: we're able …
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…
-
No language pack but still errors coming in Hungarian LanguageWe have language pack installed but Hungarian language is not enabled. But still our users are receiving errors in Hungarian language Nincs eredimeny - No Results Found
-
Default Expense Account in Person Management > EmploymentGood Day Experts, What subject area to use in order to pull the 'Default Expense Account' below in OTBI analysis? I cannot see the field in Worker Assignment subject are…
-
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…
-
Help! Need to increase Font SizeHi We are working on our Line Manager Dashboard. We would like to add a custom tab in the dashboard. The tab would be all text as we want to add key definitions for some… -
What table stores the extended lookup code name for Visas and Permits?Summary: I am trying to build a DM for Visa and Permit notifications. What table stores the extended lookup code name for visas and permits? I would assume there is a ta… -
Count of All Performance Goals is not showing properlySummary: Hello, can you pls check my filters below. The Count of All Performance Goals is not showing properly so I added the Goal Status filter but still not showing up…
-
Transaction console approvals reportThe user is asking for a BI report that shows all the approvals for a transaction in HCM, right now I'm able to find the current and historical approvals but I can't fin…
-
Setup connection/API from Fusion reports to Azure data warehouseSummary: Hi Team, Any suggestions on sending the data from Fusion reports (OTBI/BIP) to our internal Azure data warehouse without using a flat file method of SFTP. Any o…
-
Workflow Notification addition to DM and BI template not showing up on UI page (ManageCompensation)Summary: Hi Forum: on a Redwood-enabled workflow notification, our additional JobCode field we added in Employee Details section of ManageCompensation report/DM does not…
-
Moved: Will the process Import User Login History affect performance?This discussion has been moved. -
We are looking for the SQL to fetch the last updated by/last updated date of wage basis rule.Summary: employee from NJ state (US). When we ran the payroll the amount for element named Deferred comp regular was recorded under pretax deduction balance. This was be…
-
How to identify who made changes to the DFFs we used in our OTBI reports?Summary: There are few OTBI reports in Dev env which resulted in error because of missing DFFs. we got the DFFs back by running the schedule process. but we want to know…
-
Oracle SQL - Position at a point in timeSummary: Hi, I am just writing a query to get any employees that are on secondments, leave, etc at a given point in time. One of the key requirements is to get all the a…
-
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With…