Get Started with Redwood for Oracle Cloud HCM Begin Now
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 Reporting on BPM SetupSummary BI Reporting on BPM SetupContent Hi Team, Hope everyone is doing great ! We have a requirement to create a report on BPM Approval setup . Is there a table that s… -
Logical SQL join condition for Recruitment and Transaction ConsoleHi, I have a report where I am using below tables for fetching recruitment and postion details like JobRequisitionNumber, RecruiterFullName,DepartmentName,RecruitingType…
-
Bursting BI Publisher HTML EmailHi Experts, I have created the Bursting Definition below for testing purposes. select har.REQUEST_ID as KEY, har.RUN_ID as TEMPLATE, 'en-US' as LOCALE, 'PDF' as OUTPUT_F…
-
Query to pull the failed transactions from transaction consoleSummary Query to pull the failed transactions from Transaction ConsoleContent Hi Experts, Good Day!! We have the requirement to pull the failed transactions from transac…
-
Gross earnings reportSummary: Is it possible to create a report in OTBI that shows gross earnings per pay for a specific date range? If yes which subject area should we use? can anyone help …
-
Is it possible to identify the user running a BIP report to use for dynamic content?Summary Shared-service users need to run letters generated for employees and the signature must be the user who is running the report. How can we identify the user?Conte… -
Using dashboard prompts on multiple-subject area analysisSummary: Using dashboard prompts on multiple-subject area analysis Content (required): Hi all, I created an analysis to track a specific group of managers (narrower than…
-
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)…
-
Need to fetch HOD comments in Performance managementSummary: I am trying to fetch HOD Comments in Performance task in Fusion HCM? And which table this comments will store? Generally, comments will store in HRA_EVAL_RATING…
-
How to enable audit for any personalization changes that are done via a sandbox in Oracle HCMSummary: We have a requirement to capture any personalization changes that are done via a sandbox in Oracle HCM application. Kindly let us know how to enable and track t…
-
What does Oracle Cloud use as the out-of-the-box formula for time to fill for a job req?We are in needing to know what formula and/or calculation Oracle Cloud uses on the out-of-the-box Recruiter Dashboard for Time to Fill (Requisition Aging). We are rebuil…
-
Issue while extending offerSummary: Dear All, We are trying to extend the offer for one of the candidate and getting below error: The job offer couldn't be extended. There was a problem with the j…
-
OTBI with a List of Courses and a link leading to the course pageSummary: Content (required): Hi there, I have created a simple OTBI report with a list of all the courses we have in Fusion Learning - xml code is at the bottom. I wante… -
Employee Names in Local LanguageSummary Employee Names in Local LanguageContent Hi All I need to display the Employee Names (Example: First, Middle and Last) in local Language (i.e. Arabic) I entered t… -
Need assistance for bursting paramter4Summary: Hi Everyone, I need your assistance regarding the bursting report. I want to add a data source in my subject email but when I try to add it gives me an error. c…
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Does anyone know which tables I need to use to retrieve the Bonus Amount from the Compensation ModueSummary: I have a requirement to show last years performance bonus amount in a report and I have built most of the information using SQL but I am unsure what tables I ne…
-
How to get one object from a string in OTBI ReportsHi Team, We have a requirement where would like to get a particular object from a string which has _ in it. Example: This the string we have in one column Evaluation_OLC…
-
Changes reportSummary All changes for specified fields in date rangeContent Hi, Is there a report that shows all changes in period: ID Name Effective Date Old Department New Departmen…
-
Department Changes - BI ReportSummary Shows department changes for an associate for the current yearContent Hello, We are looking for a BI Report that shows department changes for the current year. I… -
HTML Markup values are not working after 23B updateSummary: Good afternoon, I am having issues while trying to save an edit of code within the sandbox > HTML Markup. When making the replacement, the system only saves par…
-
How to find the OTBI report last run history?Summary: Hi All, Need to find the history of the OTBI report last run, user-wise. Content (please ensure you mask any confidential information): Version (include the ver… -
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any… -
Subject Area for Organization AttributesSummary Subject Area to display attributes from hr_all_organization_unitsContent We deployed few attributes at PER_ORGANIZATION_UNIT_DFF under Manage Organization Struct…
-
Dynamically logos of the different legal employer dynamically in BIPSummary: I am trying to display the logos of the different legal employers dynamically on my BI report. I created a SubTemplate folder where I store the logos The Sub Te… -
Need table name to pull "payroll processing status" field from time and laborSummary Need table name to pull "payroll processing status" field from time and laborContent Hi Team, Need table name to pull "payroll processing status"(Like Processed …
-
Authorization error with REST API to move candidate between phases / statesSummary: Content (required): Hello everybody, We are trying to use the rest api made available by Oracle to move a cadidate present in the system in the ORC module betwe…
-
Employee advance settlementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How can I have a nested for-each group inside rtf report?Summary: How can I have a nested for-each group inside rtf report? Content (please ensure you mask any confidential information): If I add a for-each group outside anoth… -
adfdi-excel-addin-installer-current-user needSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…