Get Started with Redwood for Oracle Cloud HCM Begin Now
Reporting and Analytics for HCM
Discussion List
-
Does an Agent(OTBI) continue to run even though the user who set it up is inactive?Summary: Is there any way to find out the agents created by a user(Inactive now) in "MY Folder"? Also does an Agent continue to run even though the user who set it up is…
-
Headcount and Termination # for Turnover and ESG reportHi there, We are looking for the columns in subject area to display precise headcount and termination number for Turnover and ESG reports. Below are other numbers which …
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…
-
-
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…
-
person flexfieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BIP - Completed Learnings ReportSummary: Hello, Has anyone tried creating a BIP report that contains all of a learner's completed learnings at a course level? (Completed, Bypass Completed) Below are th…
-
-
Need to know tables used for storing geographies for use in BI publisher reportSummary: Can someone help me with names of tables that internally store all geography hierarchy information in HCM. I need to use this in my BI publisher report to extra…
-
How can I set the default of a date parameter to the same date in the prior year in Bi Publisher?Summary: Due to leap year, {$SYSDATE()-365$} is no longer working correctly to set the default for a date parameter to the same date in the previous year. Content (pleas…
-
Candidate is incorrectly transferred to HR moved to previous phaseWe have an HR report under tools>reports and analytics report name: New Hire and Pending Starts Report - ExternalsNew Hire This report calculates candidates that have be…
-
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.
-
While scheduling a OTBI report, run time parameters are not coming up in General TabSummary While scheduling a OTBI report, run time parameters are not coming up in General TabContent Hi Team, When i tried to schedule a report using OTBI, there are run …
-
Table containing Attestation details for Activities - Oracle BI PublisherSummary: Need to know which tables store the Attestation details for the Learning module, which is available in the Activities section page. Content (please ensure you m…
-
Query for Role – AOR Mapping ReportHi All, We need a query for "Role – AOR Mapping Report". Can someone help to provide the query of this if anyone has already gone through this type of requirement? The f…
-
Primary Beneficiary DetailsSummary: I need to create an OTBI analysis for to get details about one benefit plan including primary beneficiary details. I used the Benefit- Enrollment Real time subj…
-
Original Referral SourceSummary: How can we show the original referral source from the candidate's general profile? Content (required): If an employee refers a candidate for the first time the …
-
is there an easy way to extract all the data from a specific table?Summary: Sorry in advance if this has been asked but I have not been able to find a resource to help me. I am looking for an easy way to extract all the data from a spec…
-
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…
-
Termination report pulling last compensation of hourly associates but not salaried associatesSummary: Term report pulling last salary of hourly associates but not salaried associates Content (please ensure you mask any confidential information): Hi! I am in need…
-
Payroll Results with Details NeededDoes anyone have a query or XLM for a payroll results report that provides the hours and amount by pay element along with the specific pay rate for each element? We are …
-
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det…
-
Diversity Report - multiple linesSummary How to report on the latest entry?Content Hi, The report attached works for me apart from 8 employees that are appearing with multiple lines of data. I've spoken…
-
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…
-
Null row is occurring in OTBI because of Case statementI am facing some strange issue where null row is getting when i had use case statement one of the attribute as we have multiple phone types and for one of the employee h…
-
BIP report with Excel template output file showing wrong time when compared the value in Data modelHi Al, I am working on a conversion BIP report where I am printing Start Time, End Time in the output file. when I loaded the XML and inserted the fields into the Excel …
-
Moved: Compensation Change statementsThis discussion has been moved.
-
Moved: bulk release of compensation change statementsThis discussion has been moved.
-
Report on Denied Absences (OTBI)Summary: I am trying to create a report on Absences which are in "Denied" Approval Status using the Workforce Management - Absence Real Time SA. The Approval Status fiel…
-
Using SET VARIABLE PARAM_EFFECTIVE_DATESummary I'm trying to default the "SET VARIABLE PARAM_EFFECTIVE_DATE=" back 3 daysContent I'm trying to set the "SET VARIABLE PARAM_EFFECTIVE_DATE=" prefix. I want to us…