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
-
OTBI prompt set default values for date between first and last day of current yearI know that I can set a default for a prompt as todays date using the SQL expression select current_date from "Workforce Management - Worker Assignment Real Time" I thin… -
Any reports or Dashboards available for Fusion Applications Performance monitoring?Summary: How to Monitor Fusion applications performance? We are using FAs in more than 30 countries and there are many processes/ integrations/ reports scheduled to run … -
Specialization Completion PercentageSummary: I am looking to build an OTBI report that lists by associate an enrolled learning specialization and a summary count of the number of the courses in the special… -
How do I find out the end date used for a scheduled process that has already endedSummary: We are trying to find out the end date used when a process was scheduled that is already in "finished" status. One of our ESS jobs has stopped running and we wa…
-
How to Disable OTBI agentWe have almost 160 agents in one of the folders and we need to disable all the OTBI agents. How to check whether the agents are actively running and how to disable them … -
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…
-
Candidate’s application Question code in OTBI or data moduleI am looking to build a report that has the candidate’s application questions and answers and I need the question code on it for analytic purposes. I can build an OTBI b…
-
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar… -
How can we pass date parameters into the List of values to fetch the data based on the date rangeHow can we pass date parameters into the List of values to fetch the data based on the date range? Based on the dates the recoded should get refreshed in the parameter n…
-
Prompt not working in a logical sql analysisSummary: I created a logical sql analysis (see image1). And I also created a dashboard prompt (see image2). I filtered the "Calendar_Year" as 'Is Prompted' but for some …
-
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…
-
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B…
-
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and …
-
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…
-
Learn Records show Duplicates within OTBI Report for all employees and coursesSummary: Content (please ensure you mask any confidential information): Hello, I have recently created a report where the OTBI report shows duplicate rows for most cours… -
excel output, splitd linesSummary: Content (please ensure you mask any confidential information): HI team, I have a report that one of the field is HTML with new lines, the problm starts where I …
-
-
Oracle OLM - Business wants to track a user and his assigned course progress by date wise break-up.For ex: ******* 1. Maria John did a course on "Sexual_Harassment". She started the course on 1st Jan and stopped after an hour, again continued on 2nd Jan for an hour an…
-
Date Paid is Current Date (the date the report runs)Summary: I have an OTBI report using the Payroll Balances Real Time subject area. The report is scheduled to run every 14 days which is also the Date Paid. How can I set…
-
How to report on Owner Person Email in Workforce Management - Checklist Real Time subject areaSummary: Content (please ensure you mask any confidential information): We are building an OTBI report to display Journey tasks metrics using the Workforce Management - …
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…
-
PDF output with color background other than whiteDear Experts we have a requirement to print a RTF report - PDF output with black background. We have made the required changes. 1. On the Design tab, select Page color b…
-
candidate email address in OTBISummary: How do we fetch the candidate email ID in OTBI from recruitment real time subject area as per the email ID present in the candidate personal information page. I…
-
BIP report to fetch employees that are included in Automated Grade Step ProgressionSummary: Other than GSP_ELIGIBILITY_FLAG from PER_ALL_ASSIGNMENTS_M, is there any tables which can identify employees that are included in Automated Grade Step Progressi…
-
Why Oracle did not create Per_All_Assignments_D View In HCM CloudSummary: Dear All, Since we can't create any objects in the Cloud Database like Views, why oracle did not bring one of the most useful HR Assignment view used on the EBS… -
-
Hierarchy Report - Top to bottomHi, Is there any way of reporting on the hierarchy from the top to the bottom? In OTBI there is this 'Parent Manager' field that is ordered bottom up. Is there any way o…
-
Actual Goal Names are not reflecting in the Analysis ReportSummary: We are trying to build OTBI Analysis Report with the following attributes from Two Subject areas: Person Number, Name, Position Name, Unit, Department Name, Man… -
does the system keep track of changes made by the manager on the employee's goal plan?Summary: Is there any way to track the historical data of an employee's goal plan? when the manager makes changes to the employee's goal plan (e.g., in the mid-year time…