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
-
LISTAGG Function Not workingSummary: Hi Team, Please help me debugging or optimize the below query. Content (required): The result: The result I want: Version (include the version you are using, if… -
how to call value set in fast formulaSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Payroll - Element Entries - Real Time Subject AreaSummary: We have a requirement to enable our Reward Team to have the ability to report on Element Entry Values. I have read many similar posts regarding this and i under… -
OTBI create/edit/view accesshi, We have a requirement to give OTBI access to business users. business user should be able to create/edit/view report for all the subject areas Should not have access… -
How to access Pulse score comparison of employees/ direct reports from Touchpoints as a report?Summary: From Reports and Analysis tool, I want to view the analysis displayed in the Touchpoints dashboard so that I can export them as an excel. Content (required): Ve…
-
How to automatically expand the Organization Tree in OTBI?Summary: How to automatically expand the Organization Tree in OTBI? Content (required): I want display the Organization Tree in a hierarchy in PDF. When I export the dat… -
OTBI: Remove Duplicated records that have different Assignment Start DatesSummary: I am running a report that is returning multiple records for the same employees. The difference is the Assignment Start Dates. I want only the record with the m…
-
Best way to Archive and Unarchive the BI Reports in Oracle Cloud HCMSummary: Best way to Archive and Unarchive the BI Reports in Oracle Cloud HCM Content (required): Hi all, When we archive a BI Report ( Data Model or Report ) in one ins… -
Unable to get below requirement of absence columns in BI or OTBISummary: Hi Team, I need to develop thebelow cloumns through OTBI , how can we get below cloumns in absence subject areas. in between 1st apr-22 to 31st mar 23 but i don… -
eText RTF error on Open "XML-20211: (Fatal Error) '--' is not allowed in comments."Summary: Hello I've attached my eText RTF template (in Docx extension per forum rules) and XML (as .txt) I have gone over the template and my Data Model SQL data sets bu… -
Long Running Custom BI Report OptimizationSummary: We have created custom BI Report which is running for long almost 4.5 hours and wanted to improve the performance of the report. we have used sub query in the s…
-
Add Days to day_start_timeTeam, How to add days to datetimestamp. We have a requirement to add one week to the date timestamp and display. day_start_time in hwm_tm_rpt_entry_v. If the date is 25-…
-
How to use Custom fonts i.e., Open Type Fonts (.otf) in BI ?Summary: How to use Custom fonts i.e., Open Type Fonts (.otf) in BI ? Content (required): Version (include the version you are using, if applicable): Oracle Fusion Cloud…
-
Recruit - reporting on event date for Interview to be ScheduledSummary: We have a report which shows all candidate at state of Interview to Be Scheduled, but we want to add the date which they got moved to this state. I have added s…
-
Report parameter definitionHi, There is a absence start and end date in the absence used report I created.and when i select start and end dates i want to see absences in that range this is how i d… -
Duplicate Reports sent out by SchedulerSummary: Hi all. A few of the schedulers I have set up are suddenly sending out anywhere from 2-4 reports. This seems to only be happening since our 23C install, at leas…
-
OTBI: Succession plans report, how can I add the Incumbent person number?Hi all, I have a problem in editing a report on succession plans. I have these columns (Plan ID, Incumbent name, Candidate name, Person number). I want to add a column w…
-
How to export 'comments' within OTBI Recruiting Real Time - "Job Application - Interview Feedback"Summary: We have a questionnaire that allows for comments (highlighted in picture below) to be manually added within ORC; when we export the questionnaire we cannot find… -
Length of Service CalucationSummary Need to subtract Current Date from Legal Employer Seniority DateContent Does anyone know of a SQL formula to subtract the current date from Legal Employer Senior… -
OTBI Report - Performance Goals ApprovalSummary: Hello, Does anyone know how to fetch performance goals approval (pending, draft, etc.) using OTBI? Content (required): Does anyone know how to fetch performance…
-
Increase font for Dashboard Link objectSummary: Increase font for Dashboard Link object Content (required): We are developing the report landing page using a dashboard page where we want to link all reports. …
-
Department EFFHi, From which table can I find the EFF field defined on the department? If you know, can you share? Regards,
-
Some of employees not showing checklist task name of 30days HR questionarieSummary: Hi Team, we have onboading perosn task list but some of employees have not showing even task name also and task status also. any one assist me on ? that issue s…
-
Tables available for ConnectionsHi, What are the tables available for "Connections" reporting. Regards, Nivya
-
Catalog objects not visible while creating Data model using Oracle BI analysisSummary Catalog objects not visible while creating Data model using Oracle BI analysisContent I am creating a new Data Set using Oracle BI Analysis, when I click on Orac… -
Team Dashboard ErrorSummary: Content (required): I have created a custom role but it is unable to see the compensation tab of the team dashboard area. I know it is a missing role problem bu… -
Need to display Employee Image in the BIP report outputSummary Requirement to display Employee Image along with employee details in the BIP report outputContent Hi All, We have a requirement to display Employee Image and wit…
-
Report to show OTBI filters/parametersSummary Report to show OTBI filters/parametersContent Is there a report available, or a way, to pull report filters/parameters out of OTBI analyses to view? I have a lar…
-
How to calculate the number of active assignments for a personSummary: Question from a beginner: How can I calculate the number of active assignments for a person to isolate profiles with potential duplicate assignments? Content (r… -
Seeded/Custom report indicating time spent in previous jobs before moving to current jobSummary: Please share any seeded/custom report that indicates the total time spent by employees in their previous jobs before moving to current Job Content (required): R…