OTBI
Discussion List
-
Unable to Combine 2 Subject Areas throws error.Summary I am trying to combine Compensation salary history and payroll element history Subject area it throws me error. If someone can help out or would appreciate if th…User_2025-02-07-09-10-02-492 53 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Converting what pulls through as text to a numberContent I have created a report in OTBI but the 'Displayed Input Value Meaning' is coming through as a text field rather than a number field and ideally I would like to …User_2025-02-06-11-18-47-896 919 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Invalid Payroll Transactions in the SubledgerContent We have been up for a year on Oracle and have had a very rocky go of it. We have about 50k (yep thats right) invalid transactions for 2020 in the subledger from …Rebecca McArthur 21 views 2 comments 0 points Most recent by Rebecca McArthur Reporting and Analytics for HCM -
Field School Empty in Subject Area “Workforce Profiles – Person Profile Real Time”Content Hello All, We have created the following report “Report Degree” which uses the subject area “Workforce Profiles – Person Profile Real Time” and the following col…Bernard T 66 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Point in Time - Home Address for EmployeesSummary Point in Time - Home Address for EmployeesContent Does anyone know if it is possible to create a report that returns employee's home address as of a specific dat…Kathleen Nguyen 26 views 8 comments 1 point Most recent by Kathleen Nguyen Reporting and Analytics for HCM
-
Misalignment of DatesContent Hi all - I have an issue I've not experienced before. I have an LSQL for a changes report I am working on, and I am pulling in the Last Update Date for the assig… -
Subject Areas in Union analysisSummary Only the primary subject area is visible in a Union analysisContent Hi, We're busy building reports ahead of a not-too-distant implementation of Cloud for HCM & …User_2025-02-08-05-56-00-229 46 views 7 comments 0 points Most recent by User_2025-02-08-05-56-00-229 Reporting and Analytics for HCM
-
How to Add Worker Details to Job Details in a single report in OTBIContent Hello, I am trying to add the following under Workforce Management-Worker Assignment Real Time subject area: Job-> Job Name, Job Code and Level Worker-> Name Whe…User_2025-02-10-12-13-36-181 21 views 4 comments 0 points Most recent by User_2025-02-10-12-13-36-181 Reporting and Analytics for HCM
-
Set Column Filter Formula to 'Full Time' - Dashboard TileSummary I've created a headcount dashboard with tiles by employees, contingent worker, Full Time, Part Time, PRN. I've created a column filter formula for all of the til…Monique Moore 10 views 1 comment 1 point Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Action Link LayoutContent Hello experts. I'm trying to use action link. but I'm also unable to edit the layout. I'd like to make it like abutton, not a single stream of text as default. A…Pedro Teixeira 41 views 9 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Question marks in attributes causing filtering troubleContent Hello Experts, We've encountered a situation where a course has been setup in our learning module with a question mark at the end. We've found that when we try t…Rob F 12 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Can we create the output as .txt file in analysisSummary Can we create the output as .txt file in analysisContent i have created a analysis to fetch the assignment number for all the employees.but we need the output as…User_2025-02-05-02-11-29-794 39 views 8 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM
-
User behavior and AnalyticsSummary Is there a BI table which captures information on user behaviorsContent Our customer is looking for information on user behavior - which Fusion page is being use…Akash Kiran Jana 28 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI repoSummary Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI reportContent Hi I have 2 prompts on my OTBI report. Period Name … -
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 42 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Report OTBI based on role and delegationContent Hi All, Do you know if is it possible to create an OTBI report that extracts all delegations done through the functionality role and delegation? I saw that these…Valeria Longoni 82 views 5 comments 0 points Most recent by Steve_Wright 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 29 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 67 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… -
Error while using FILTER/DESCRIPTOR_IDOF in formula with multiple subject areasSummary The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID columnContent I'm trying to summarize Headcount based on Gender, Ethnicity and …
-
Report to show latest demographic infoSummary Report to show latest demographic infoContent Trying to report on latest demographic info for a population but duplicate rows are being returned when I only want…Emily Robinson 53 views 2 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
Creating a line graph of headcounts across the past 6 months (for each country)Content Hi, How would one create a line graph of historical headcounts for each country? The date should be on the x-axis and the FTE headcounts on the y-axis, with the …User_6PCL3 23 views 3 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Generating FTE Headcounts for the past 12 months based on each region/business unit - OTBISummary Generating FTE Headcounts for the past 12 months based on each region/business unitContent Hi, How would one generate a time-series plot of the FTE headcounts ac…User_6PCL3 24 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI: is there a restriction in OTBI reports that it can return onlySummary OTBI: is there a restriction in OTBI reports that it can return only Content Hi, Had a question: is there a restriction in OTBI reports that it can return only
-
OTBI report to get former and current job title, job code, department, business area for internal hiSummary I would like to create a report that can be run by work relationship start date which will provide information on an internal transfer candidate who moves from o…Amrita Basu 697 views 1 comment 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
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 207 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 60 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Send a system notification for all employeesSummary Send a system notification(Not an email) to all employees of their previous day attendance reportContent My requirement is , need to send a system notification t…Murugesu.V 39 views 3 comments 0 points Most recent by HarishVummidi 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 -
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 35 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM