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 Data Missing After Excel ExportThere are two instances with OTBI reports where I have gotten the message below that have impacted reports. In one report, hyperlinks are not working, and in another, ro… -
Login Data from Identity Domain in Reporting and AnalyticsHello, Does anyone know if it's possible for login data from Identity Domain to be displayed somehow in HCM? I've tried the "User System Usage" OTBI subject area, and I'… -
Phone numbers repeating instead of suppressing duplicatesSummary: Mobile phone and home phone number columns are repeating even though they are duplicates and the columns are set to repress. Content (please ensure you mask any…
-
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e… -
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…
-
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …
-
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…
-
Subject Area (or Table) for Regional General Preferences?Summary: Are the General Preferences: Regional reportable in OTBI/BIP? Content (please ensure you mask any confidential information): Hello everyone, Asking if it is cur…
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…
-
How to fetch latest record in OTBI ReportSummary: Hello All, I am developing an OTBI report to fetch Person's Skills and development data. For this, i have used 'Workforce Management - Person Profile Real Time'…
-
Report agents are not working post 24B upgradeSummary: We did 24B upgrade on Saturday and several reports scheduled via agents were not delivered after the upgrade. Below are the observations so far; Some reports th…
-
SQL unexpected token errorI have the below section as part of a long query that keep spitting out the error code: Encountered unexpected token: "(" "(" at line 188, column 13. Was expecting one o…
-
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…
-
How to report on worker attachments and correlate to the Performance Document they were uploaded in?Summary: Hi all, My organization has our workers uploaded attachments as part of their annual performance reviews. In attempt to properly maintain full performance recor…
-
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…
-
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… -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…
-
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report … -
What is OTBI field name that shows responses under ''Additional Comment'' boxSummary: When we create a questionnaire, under each question, you can enable ''allow additional comment'' box. I did for all questions, however I could not find that fie… -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming… -
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 …
-
How to create a link with dynamic user IDSummary: Content (please ensure you mask any confidential information): We have a button inside the Goals page where the manager can give feedbacks to the employee in an… -
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 …
-
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…
-
Query to link Location to Reporting EstablishmentSummary: Hello, CC! I am in a need to find a way to develop a query that can list all the Locations given for a Report Establishment(Or a Legal Employer) for a Report I … -
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …
-
to insert dynamic images in rtf template horizontallyHi, We have a requirement to insert the dynamic images in an RTF template horizontally. we are fetching the image from PER_IMAGES table, but currently the images are fet…
-
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…