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
-
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens… -
IN BI report how to restrict the usersSummary: Hi Team, how to restrict the user in BIP query. suppose i want to restict one person in query how can i restrict. Thanks, Ajay Content (please ensure you mask a… -
Adding multiple phone numbers to analysisSummary Add multiple phone numbers to an analysisContent Hi All, I just need some direction on adding multiple phone numbers for an employee in an analysis I am modifyin… -
OTBI report for learner count, count of learner according to number of courses completedSummary: I have to create a report to get the count of learners who have completed more than 1 course and learners who have completed more than two courses. Also I need … -
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you… -
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded … -
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… -
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… -
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 …