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
-
How to show a report in the user interface?Summary: How can I show a specific report/analysis directly to end users in different screens? Content (required): Basically I want to know how to show data to end users… -
When we apply below query we only get the one recordHi Team, When we apply the query the only we get the one recod. Could please assist on. Thanks, -
How to add logical sql analysis to dashboardContent Hi, I have created logical sql OTBI analysis , now I want to add this into Dashboard page which is already having dashboard prompt(all are column prompts) and ot… -
Business Title Not Pulling CorrectlyContent We are currently migrating to use the delivered business title field, but I'm having some difficulty pulling it into an OTBI report. If I don't add any employee … -
we work in Hebrew environment but language changes to EnglishSummary: Our site work in Hebrew in most cases, when entering into reports and analytics many times the UI language changes to English Content (required): how to avoid t…
-
What filter can I use to only list the Last Assignment details for employees and not duplicate rows.Summary: Hello Community - I need assistance listing employees "Last Assignment" or "Latest Assignment" details. If someone was Rehired, or Terminated more than 1 time, …
-
Any way to find that scheduled BI report is running or got struckSummary:Any way to find that scheduled BI report is running or got struck Content (required): Hi All, We have scheduled a Custom BI Report to pull some payroll related d…
-
How to split in two different columns an information through OTBISummary: Need to create an additional column for "Email type" Content (required): Need to have two different column for work email + personal email and not different row… -
How to change path color for a node path in Hierarchy TreeSummary: Change color of the node path in Hierarchy Tree. Content (required): Hi All, We are creating a manager hierarchy tree report, our client wants to change the col…
-
Performance Tile counting assignments based on the sum of a flex field by assignment.Summary: Since upgrading to 22A we're having trouble with a performance tile used to count assignments based on the sum of a flex field we've designed and I'm looking fo… -
Remove filter values from Export to Excel from DashboardSummary: Content (required): I would like to remove the filter from a dashboard when exporting to Excel. As seen below there is a screenshot of the Excel export I made. …
-
OTBI - Is it possible to retrieve working days per employee?Summary: Hi, We are using absence mgmt module (no time and labor) and one of the reports requires us to display how many days a month is an employee supposed to work (ba…
-
I have create a analysis on seniority subject area but few employees who have seniority are missingSummary: I have create a analysis on seniority subject area but few employees who have seniority are missing Content (required): how it can happen and where to start che…
-
List of All reports in BI PublisherHi Experts, Do we have any table or web service that can list out all reports present in a BI Publisher instance? So far we have used: XXXXX.oraclecloud.com:443/xmlpserv… -
Effective DatingSummary: I'm using Compensation - Salary History Details RT subject area to get someone's salary as at 29-10-21 (so in that subject area I use the Salary Change Date
-
Burst notifications are sent to inactive managersSummary: We have notifications to inform the current manager about the contract expiry dates of their employees. The OTBI was done using the Worker Assignment Real Time …
-
Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY are unable to see their own development goals.Summary: Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY inherited by either ORA_PER_LINE_MANAGER_ABSTRACT role or ORA_PER_HUMAN_RESOURCE_ANALYST_JOB role are unable…
-
Additional comments and Reason for joining can't fetch the OTBI reportSummary: Question test to response answer in Pivot Table format Content (required): Formula for Question test CASE WHEN "Checklist Questionnaire"."Question Text" = 'What…
-
Where to find in OTBI Calculation Card Start and End Date?Summary: Where can I find in OTBI Calculation Card Start and End Date? Content (required): Please see image below. I am using the "Payroll - Calculation Cards Real Time"…
-
I need to create a group or a bin based on 2 different columns. Is that possible?Summary: Group or bin based on 2 fields Content (required): I am working on turnover report and need to create groups or bins from a hierarchy tree value and a company b… -
I have 2 parameters for analysis both are list of values on the same table - how I can write the sqlSummary: I have 2 parameters for analysis both are list of values on the same table - how I can write the SQL the will limit the lov of the second parameter Content (req…
-
BIP Report is missing the schedule - How to find the reason for the miss?Summary: We have a BIP report which is scheduled to run daily with scheduled end date in 2024. However, the report hasn't run since 15th Sep. It is not failing either. H… -
How Shows/Downloads OTBI Analysis results in Excel fileSummary: Content (required): Hello Guys, We would create an analysis which extract all the candidate members inside all pools. We have a lot of candidates and for this r… -
Printing details on a single row using a EText Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio… -
Workforce Trend Real time subject are not giving the dataSummary: I am using workforce trend real time subject are and it is not giving the correct data when we migrate it to another instance. Content (required): We have migra… -
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…
-
How can I locate which subject area the IR35 (Off-Payroll Worker Flag) is in?Summary: Trying to produce an otbi report including the IR35 flag which I think is in the Legislative Info Section of Person Management in the Person area. Can someone p…
-
Extract Otbi Analysis with more then 25000 LinesSummary: Content (required): Hello Guys, We would create an analysis that it extract all the candidate members inside a candidate pool. The candidate pool is very large,…
-
Passing Prompts through an AgentSummary: Does an OTBI Agent use the hardcoded prompts? Content (required): Hi, I have an OTBI headcount report that has a hardcoded effective date prompt for the last da… -
Dynamic effective date on AnalysisSummary: I am trying to get active employees as of a future date in Analysis "Workforce Management - Worker Assignment Real Time" Content (required): I am able to use a …