OTBI
Discussion List
-
Cross-Subject Area Report with 'Security - Roles and Privileges Real Time'Content We are in search of a report that would require a cross-subject area analysis using Worker Assignment Real Time and Security Roles and Privileges Real Time. I am…User_2025-02-08-03-57-26-191 58 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
schedule a OTBI Report when data is thereContent Hi, I want scheduler to run only when report has data. I have developed OTBI Report. Can you please tell me how I can do it in BI and OTBI. Thanks, VijayUser_2025-02-07-19-03-14-525 24 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
Workforce Management - Workforce Trend Real Time pulling current employee typeContent Hello, I'm working on making a headcount report using the Workforce Trend Subject Area, but I've noticed the subject area is pulling the current employee type ra…User_2025-01-31-00-25-12-234 23 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Business Unit Headcount vs recognitionContent I am trying to create a pivot table to show headcount of business unit against our recognition values which employees have been awarded. So I can clearerly see a…User_2025-02-06-11-18-47-896 22 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to identify loops in the line manager hierarchyContent Hello, Does anyone have a report that they could share that identifies a loop in the line manager hierarchy i.e. an employee lower down in the hierarchy also man… -
Report with null data between tablesContent Hello experts I've managed to make an interaction between 2 tables in OTBI DataModel. Then I need to create a report. The problem is the report does not show the…Pedro Teixeira 15 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Summary Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Content Hi, We have a requirement were we need to hide a Performance Ti… -
Query Absence Pending TransactionsContent Hello experts. I'm trying without success to create a report that gives me the history of transactions. Category - Status - to whom - initiated at - Approver (As…Pedro Teixeira 287 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Reporting on reversed terminationsContent Hi all, I have searched on this topic but have not found a working example of this report or confirmation that it can be done. Can anyone advise whether it is po… -
How to modify existing OTBI analysis built using Logical SQL?Summary I am new to Logical SQL OTBI reports and want to know how to make modifications to an analysis once I created it using logiical? I have to add a new column and p…User_2025-02-05-23-02-13-475 254 views 10 comments 2 points Most recent by User_BUU5W Reporting and Analytics for HCM
-
Change the language of the text in RTF template.Content Hi Experts, I am looking for a function for RTF template using which I can change the Language of the text. for eg: Orignal Data- English: One Thousand Two Hundr…Jaswant Prajapati 316 views 3 comments 1 point Most recent by Misbahul Khair Reporting and Analytics for HCM
-
Who hasnt submitted a TimecardContent Hi all We have been live with HCM for a year and i have been tasked with providing a report that shows who has not submitted a time card. The seeded reports dont…Dawn Cawston - CPS 76 views 1 comment 0 points Most recent by SameerJain Reporting and Analytics for HCM -
Unable to access reports and analytics after userid changes in OTBISummary User no longer is able to access reports and analytics. Receives error 'Unable to reconnect (after 3 tries) to BI Presentation Server using the connection Id =BI…
-
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 907 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 22 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 67 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 27 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 47 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 11 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 14 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 34 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 27 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 40 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 84 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 28 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM