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
-
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Document Of records- Headcount - Document Count inconsistent resultSummary: I am trying to create a report with employees who have updated their 2nd covid vaccine on the DOR. I am able to get the count correctly. Then I am trying to get… -
Issues Reporting on Development Goals after a Global TransferSummary: We are facing an issue in reporting (both OTBI and BIP) where an employee adds development goals and shows on our reports as expected, but after they have a glo… -
Enforce 2 decimal places after a column result in s query.Summary: The table column can have values like 2,3,56.78,34,8 etc. We need something on the query such that 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 4… -
Filter to bring back the greatest Response Attempt NumberSummary: Content (required): We have an OTBI report using looking at employees Performance Review Rating (workforce performance - Performance Rating Real Time), for most… -
Promotions and Transfers Reports and Data ModelsSummary: Business need for two reports: promotions and transfers showing From and To information Content (required): Hi, everyone. We are looking for an example of a rep…
-
Non-Hired ApplicantsSummary: I need a report that lists all non-hired applicants in the past year. Content (required): Looking for a way to list all candidates that applied for open positio…
-
Documentation or Use Cases for putting reports on pages that use parametersSummary: Displaying reports on various pages that require page filters Content (required): We have successfully been able to add OTBI analysis to pages and filter on the… -
End user unable to schedule OTBI reportSummary After clicking on the more button of an OTBI analysis, the 'Schedule' option is not availableContent Hi, I've had a quick look, but couldn't find anything linked…
-
Tax rates vs Tax codes SQL from HMRCSummary: How to query how much percentage of deduction is associated for each tax code based on HMRC definitions? in which tables this data avilable? for example for BR …
-
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly executed) Is there any way to find. Thanks -
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform… -
Resource Alert: Waitlist Exit AlertSummary: Hi All, I am working on a resource alert(alert composer) to achieve those learner details whose offering status change from waitlist status to some other learn … -
Why I am getting no results after using Workforce Management - Documents Of Record Real TimeSummary: Why I am getting no results after using Workforce Management - Documents Of Record Real Time . When I am using column Person Number and Document Type there is n…
-
Job offer letters issuei am working on recruiting module in HCM Cloud i wanted to create Job offer letters. we have mulcible templates for same requisitions using some conditions in main templ…
-
Using Greater Than condition in RTF templateSummary: Content (required): Hi, I'm trying to use the following in an RTF template to select between two blocks of text. The value of…
-
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…
-
Is there a way to track the 'Recommended Candidates' from the AI database tables back to the req?Summary: The aim is to develop a report to analyse how many 'Recommended Candidates' are actually being hired. Hence, looking for a way to report this using the AI table… -
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would… -
Does JWT token Authentication supported in Generic Soap WebserviceSummary:Does Generic soap webservice for BIP Report scheduling support JWT Token Authentication Content (required):Does Generic soap webservice for BIP Report scheduling…
-
How to "decode" Notice Period UOMSummary: How do one decode Notice_Period_UOM in SQL/Query Builder Content (required): How do one decode Notice_Period_UOM in SQL, so that the output display e.g. days, m…
-
OTBI Concat FormulaSummary: Concat formula Content (required): I need to create a field in OTBI to show last name, first initial. Is there concat formula I can use to show this? Version (i… -
Date Parameters in Headcount AnalysesSummary: I am just starting in OTBI Development and trying to understand how I achieve the desired analytic with results based on comparative dates. Content (required): …
-
Need table names for reporting on the report job historyContent Hi All, Could you please provide the table names associated with the report job history. We need to pull the data for a report where email is being sent to emplo… -
OTBI Report (Count Distinct - Accomplishments)Summary: Hello, I'm running an OTBI report. Is there a way to use count distinct in Accomplishments? Subject Area: Workforce Profiles - Person Profile Real Time But the …
-
Table Info Alert Composer NotificationHello everyone, we need to see the history of when notifications created with Alert Composer have been changed, does anyone know if there is a table where this informati…
-
Accrual balance with different start dates for plansSummary: my customer is an international company and the various countries have different accrual plans. For most countries the plans start at January 1th of a year, but…
-
how to send a email and place file in sftp server using BurstingSummary: how to send a email and place file in sftp server using Bursting Content (required): My Requirement is to place a file into SFTP location and sending a email no…
-
Having an issue while opening Analysis with HR Specialist roleSummary: I have an issue when I'm trying to open an OTBI analysis from the user account with Human Ressource Specialist role. But no issues occurred when I open it from … -
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…