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
-
Are there any jobs to schedule hourly/daily/weekly for OTBI?Summary: We have schedule jobs for various areas of HCM but nothing that runs hourly/daily/weekly for OTBI reporting. Are there any jobs that you can recommend to schedu… -
Unable to configure RTF Template on the basis of DatesSummary: Unable to configure RTF template on the basis of date of completion of course. For example CPO of the client firm has been changed and the change happened on 2n… -
Reporting on total number of employees that completed a subset of learning itemsSummary: I have a requirement to create a summary report that includes how many employees have completed a subset of all of the learning items included in the filter of …
-
DNUSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Do we have any delivered HR and Manager dashboards in 24ASummary: Where can I find the delivered HR and Manager dashboards in 24A Content (please ensure you mask any confidential information): Are there any delivered manager a… -
Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe… -
I am getting exception error for one of scheduled report through bursting.Summary: I am getting exception error for one of scheduled report through bursting. Does anyone know what should be the reason. Content (required): Job Priority: Normal …
-
How to derive Running Average of Monthly Attrition rate in one OTBI reportSummary In one OTBI report, I would like to see, the monthly attrition rate and monthly running average attrition rateContent Can anyone please help me how to do this? I… -
How to create a report with full and part time EMP count as per department ?I have created a headcount report with basic employee info. I want to modify it such that it has Emp ID, Dept ID, Full time & Part Time Empl count. Basically I am lookin…
-
Send a BIP report to PRINTERSummary: How to send a BIP Report output to PRINTER directly Delivery output should be directly sent to PRINTER Content (required): Version (include the version you are …
-
Report Job HistorySummary Report job history only goes back 9 months from current dateContent Hi, After a query from an end user in HR we've noticed that the report job history only seems…
-
How to add a count column for employees aligned to a job in OTBI.Summary: I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job…
-
In which table does the Candidate Selection Process Code field is storedSummary: I'm trying to fetch the Candidate Selection Process code, but couldn't figure it out where this field is stored. Content (please ensure you mask any confidentia… -
Assignment Manager - Performance Document ReportingHi all, We've built a report that we'd like managers to be able to run that'll return their direct and indirect reports Performance document status details. The issue we…
-
Draft water mark is missing in the draft fileSummary: Content (please ensure you mask any confidential information): Hi Team, Draft watermark is missing in the draft file. I have used the RTF template in the report…
-
Dashboard prompt not applying to linked analysisSummary: The Dashboard prompt for 'Name' is accurately returning the number of Employees for our 'Headcount' tile, but when navigating to the link analysis for Headcount… -
Max assignment logic not working as expected in OTBI Analysis in Workforce Management Subject AreaContent We have several requests to bring in an employee’s max effective row in OTBI. We could use the Workforce Management Worker Assignment Real Time, but the issue wi… -
"HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO" Does not give latest LE namesSummary: We are not able to get latest LE name from this "HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO" , is there any Synch job that can be run to synch… -
How do I add last salary and manager details in terminations report ?I am using Workforce Management - Worker Assignment event real time to pull the terminated employees. . I have joined the compensation real time salary details to pull t…
-
We are trying to extract month from a date column in OTBI after we convert it to Mountain Time.Summary: We are trying to extract month from a date column in an OTBI report after we convert it to Mountain Time. However we get the month from UTC only.Any suggestions…
-
Moved: How to Disable/Remove/Hide Inline Attachments in Attachments Category in HR Help DeskThis discussion has been moved. -
Gigs progress history is not available in IRC_LC_HISTORY tableSummary: Gigs progress history is not available in IRC_LC_HISTORY table such as Gig Filled date, Gig completed date, unpublished date, etc. We are unable to extract data…
-
How to Prevent Spacing between unmet conditions?Summary: I am currently in the process of consolidating multiple offer letters into a single document. Within this composite offer letter, I've included several sequenti…
-
Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …
-
In oracle fusion which table have NationalityDear , I want to know in oracle fusion which table i can find nationality . in fusion i can see nationality in person document but not found in table Thanks -
How to Retrieve Employee Active Assignment through Groovy ScriptsSummary: We are trying to get employee active assignments inside the Groovy scripts. For that, we need to configure the endpoints in web services. In the latest worker e… -
How to query rehire contingent workers in BI reportSummary: I need to query for rehires To look for rehires the person has to have an active Contingent Worker assignment from the past and either a pending worker or conti…
-
Need column mapping of With this note in learning assignment in OTBI Subject areaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Need to provide SFTP URL as a hyperlink in RTF template.Hi, We have a requirement to send email notification to user after extract run, in email we have to provide SFTP location as a hyperlink so that when user clicks on it, …
-
OTBI analysis with Termination Reason and Termination Category are failing after 24A upgradeSummary: Hello, All our OTBI analysis with Termination Reason and Termination Category in them are failing after 24A upgrade. I forced deployed PER_ACTION_OCC_EIT_EFF ex…