Get Started with Redwood for Oracle Cloud HCM Begin Now
Reporting and Analytics for HCM
Discussion List
-
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 …
-
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …
-
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…
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
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…
-
In which table does the Candidate Job Application Fields are storedSummary: Hi Everyone I have loaded the Candidate Job Application into the system using HDL. So I'm trying to fetch those loaded fields using SQL for verification. Conten…
-
Absence Calendar Details Real Time - Reporting on employee absences by daySummary This is a white paper to enable the customers to generate and render worker absences breakdown by day using the absence calendar details real time subject area.C…
-
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…
-
line manager DashboardSummary: In Line manager dashboard, we are getting head count from "Workforce Management - Worker Assignment Real Time" subject area. I am able to see all records in thi…
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…
-
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…
-
People Group Flexfield segments not available in OTBISummary Unable to report on People group flexfield segments in OTBIContent Unable to report on individual People group flexfield segments in OTBI. People group is a key …
-
PersonProfileItemPVO Issue post 23D, what's changed to impact this?Summary: We have a nightly extraction that retrieves delta data. Since 23D was applied the extraction is retrieving all data, causing timeouts due to the volume it is tr…
-
I am looking for Oracle fusion HCM exit interview questionare tables to develop a BI reportSummary: with the columns mentions below Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code …