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
-
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…
-
How to have the report names show when embedded on the left side bar?Summary: Hi there, We are embedding reports as pages/tabs to the left side of certain pages I'm not sure how to get the name of the tab to show. Is there a setting that …
-
OTBI Managers and Direct Reports Additional FieldsSummary: I need to create a report that summarizes the span of control for job levels that have direct reports. Looking for the right fields to use. Content (please ensu…
-
BIP publisher email unable to send to icloud candidate emailSummary: Hi, we are using BIP jobs to trigger emails to new hires based on task completion in journeys and recently BIP email is getting failed to deliver to icloud doma…
-
Default View Reports and AnalyticsHello all - We're currently looking for a way to default the displayed folders application and user wide when navigating to Reports and Analytics from the home page. Doe… -
DFFs missing from few OTBI Subject areasWe have Multiple OTBI reports in which the DFF columns are missing from the subject areas. after running the “Import Oracle Fusion Data Extensions for Transactional Busi…
-
Is it possible to access the audit logs of selects placed on certain tables via Oracle cloud?Hi, I need the logs of some tables that are important for confidentiality. Is there a table on BI Publisher that contains the details of who ran it and when it was run i… -
Get History Data Using Workforce Management - Person Real Time Subject AreaGood Day Experts, As stated in the subject area description, Person Real Time subject area only retrieves latest and current personal information as of today but can use…
-
Issue with Vertical(portrait) view of offer letter over mail on mobile devices.We have noticed a display issue with the offer letter email when viewed on mobile devices in portrait mode(vertical view). The email requires horizontal scrolling to vie…sreenivasulu.devineni-Oracle 31 views 2 comments 2 points Most recent by sreenivasulu.devineni-Oracle
-
Oracle Tables for Benefits Person InfoSummary: I am checking the tables for the Person Info data in Benefit Enrollment page for Employee Content (please ensure you mask any confidential information): Version…
-
How to filter a column?Summary: Hello, I need help on how could I filter to show only the last row. Thank you in advance! Content (please ensure you mask any confidential information): Version…
-
losing headcounts while using some columns in parameter FDIHello I'm facing an issue while using a parameter in FDI for the subject area HCM - Workforce Core. below an example when I use this paramater, I get the right headcount… -
Need API for User module name , Module key and module type under manage value setsSummary: Hi Team, We need a API to get User module name , Module key and module type under create value set as shown in below screenshot. Content (please ensure you mask…
-
Absence Date Start in OTBII created a report using Workforce Management - Absence Real time that shows absences employees have along with the date created, and date start of the request. I notice…
-
Ability to pull criteria used in OTBI reports using Bi Data ModelHi, Do we have possibility to pull the Criteria used in OTBI reports using bi data model? Example: We have 100+ OTBI reports created for Module Enrolment under Learn Fol…
-
Hcm tables/query which stores CA meal and rest break detailsHi Team, We have client requirement to create report for following details. Time Code(s) = Rest Time Violation and Meal Time Violation Time Card Work Date Attestation Qu…
-
Moved: Converting PW to EMP future installments switched to paid on start date instead of staged fu…This discussion has been moved.
-
Restrict report access based on AORHi All Can we restrict the report access on a common report which has Master details based on the department. Lets say there are 10 departments in the report and Person … -
Bursting emails are not triggered when sent from any other email apart from domain @oracle.comSummary: We are currently using bursting email notifications to notify employees . However, we have encountered an issue. When we set the "From" email address (Parameter…