Reports
Discussion List
-
Group By Function ErrorContent Hello, I'm trying to used the ranked last function and group by Person Number to pull the employee's latest assignment, but I keep receiving the below error. I'v…User_2025-01-31-00-25-12-234 40 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Show Field Data in Column instead of in RowsSummary Working on this in OTBIContent Hi All, I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using ra…tiffnyc 28 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard PromptsSummary AsOfDate not working in my customised versionContent Hi, I have been trying to copy and then customise the Line Manager Dashboard to suit our organisation which …User_2025-02-05-22-44-35-842 69 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need to Use Result of One Column in Formula for Next ColumnContent Hello there Reporting and Analytics experts. I am hoping one of you can help me out with an analysis I am working on. I am trying to get our FTE reports up and g… -
Recruiting - Reporting on a candidate source when added by a recruiterContent HI experts, I need your help if possible. We haven't been using agency recruiting in ORC because of a system functionality issue so have had to resort to a worka…User_2025-01-25-04-04-47-442 71 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Historic Position, Dept, job detailContent I have opened an idea ticket, but just checking to see if anyone has figured our how to create a assignment history report that brings in the position, job, dept…
-
Error in OTBI Analysis Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PContent Hi All, I have a OTBI analysis with Graph. When I move my cursor over the graph I see Hand means it's clickable. When i click I get following error, Can someone …User_2025-02-07-19-03-14-525 198 views 4 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Custom Dashboard HeadcountContent Hi, I have created custom Dashboard and created 3 different Headcount Analysis for 3 BU head count. When I run my dashboard first time it shows correct count for…User_2025-02-07-19-03-14-525 58 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t… -
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 116 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached …Vasanthakumar Ravi 120 views 6 comments 0 points Most recent by Debkanya! Reporting and Analytics for HCM -
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 40 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
BIP Bursting to email: how to embed a link to the application in the emailContent Hi, we created a bi publisher report with an RTF template. in the report we created a form field and in the bi publisher property we set: View the column NEW_L…Alberto Boccato 264 views 9 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
Resignation Submitted dateContent Hi All, We had a predefined report which use to give Resignation Submission date along with the Employee last working date. Few days back the report stopped work…Kiran Kancherla 40 views 4 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
OTBI - prefix for current date minus daysSummary How can I define prompt for an OTBI report which is the current date minus variable of daysContent Hi, I'm trying to create a prompt of number, so if the user wi…
-
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula…User_2025-02-07-19-03-14-525 9 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 40 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Getting Error When Click "Drill to Transaction Detail"Content Hi Experts, When I'm clicking on link "Drill to Transaction Detail" from HeadCount Analysis ( I copied it in my custom Dashbaord) I'm getting following error. Er…User_2025-02-07-19-03-14-525 34 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and …SantoshKumarBhairi 103 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of …Rob F 38 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
BI Publisher for WORD creates last row of a table as merged cellsSummary BI Publisher for WORD creates last row of a table as merged cellsContent With BI publisher for WORD I created a template with a table to be able to run the repor…Dena Swanson 38 views 4 comments 0 points Most recent by RaviThejaDarbha Reporting and Analytics for HCM -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…Bala Kasineedi 70 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…
-
How to convert a datetime columns from a timezone to another oneContent Hi, we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity …Alberto Boccato 24 views 2 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM
-
Locate First Names that begin with Blank characterSummary Locate First Names that begin with Blank characterContent Can anyone please advise on the proper Function or CASE statement to use in an OTBI Analysis to locate … -
Vacant Position report with Last incumbentSummary Need a vacant position report with last incumbent detailsContent Hi Team I need a vacant position report with last incumbent details in OTBI, can you please let …User_2025-03-07-20-55-01-859 61 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run iSummary Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run in 6 monthsContent Good afternoon. We are auditing our HCM BIP…
-
How to add employee picture on DashboardContent I can't seem to add the employee picture/image on Dashboard. Can someone assist.