OTBI
Discussion List
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 51 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)?Summary: I was editing the logical SQL of a seeded analysis and noticed that while it appears to have custom logical SQL, it still works just like a normal subject area … -
How to extract Questionnaires and Employee Response?Summary: How to extract Questionnaires and Employee Response? -
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha…
-
Which column in OTBI will display if employee is also a manager, We need this in Learning ManagementWhich coloumn in OTBI will display if employee is also a manager, We need this in Learning Managment OTBI reportsabhilashanand 11 views 3 comments 0 points Most recent by abhilashanand Reporting and Analytics for HCM
-
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default…User_I6AXL 60 views 2 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM -
Apprenticeship ReportingSummary Can we report on Apprenticeships?Content Hi all - we have been asked to report on Apprenticeships that are listed within the Talent Profile. I cannot find anywhe…Prudence K 72 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
Documentation on Scheduling OTBI ReportsSummary: Hi! My company is currently implementing Oracle HCM. Is there an oracle manual/guide which goes over all aspects (tabs) of scheduling reports through OTBI sched…Ameya_J 186 views 1 comment 0 points Most recent by John Hung-Oracle Reporting and Analytics for HCM -
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to put filter on Phone Line Type and also include employees without the type in OTBI?Summary: Hi All, I am fetching employee's data through OTBI where I also want to fetch the employee's Home Mobile Phone data only. After I apply the filter to Phone Line…Robinson Ng 31 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Busting OTBI Myths - Using different security in OTBI to HCM CloudContent Myth: OTBI doesn't allow me to access different data to HCM Cloud Occasionally you need to allow a user to report on more or less data than they have access to i…Julian Challenger-Oracle 754 views 5 comments 9 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a way to pull Executive Manager Name on a Terminated employee record?Summary: Trying to run a report by our executive manager's to see how much turnover each manager has had. Appears that Manager details are dropped from an employees reco…CGardner01 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Average Salary per HourSummary: We have an OTBI analysis with each department headcount and I need to get the average salary rate per hour in another column. Content (please ensure you mask an…Ayesha Iroshani 9 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Analysis multiplying fields ‘FTE & Salary’ – How to resolve?Summary: I am writing an analysis from three subject areas were multiple columns have expressions, when I add an expression which is including the Manager Flag from Work…Scott_Turner_ 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Human Capital Management - Transaction Administration Real Time - Assignee person is missingSummary: Hi, I am trying to create analysis to show all pending approval transactions using Human Capital Management - Transaction Administration Real Time, but I am una…Reem Ezzat 196 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
unpivot dataSummary: Move rows to columns Content (please ensure you mask any confidential information): I am looking to unpivot the data and move Input Value Name and Displayed Inp…Julia Kiszelewska1234 24 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manage Legal Reporting Unit Registrations ReportSummary: Manage Legal Reporting Unit Registrations Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I se…Parag Hiremath 1 view 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Columns as stagesSummary: im trying to find a way if possible to wrap a whole column in an arrow pointing right. I have multiple stages and want to flow from stage1 to stage5. The two wa…
-
Manage Legal Reporting Unit HCM Information ReportSummary: Manage Legal Reporting Unit HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I …Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Active Qualifying Scheme Name showing id rather than name in Payroll - Calculation cards Real TimeContent We have been starting to build a report using Payroll - Calculation cards Real Time looking at the pension auto enrollment card, however when we bring in the fie…Sharon Harper 45 views 3 comments 1 point Most recent by Sharon Harper Reporting and Analytics for HCM
-
Medical Examination Data OTBI report display problemHello, With a specific role created role of Medical examination I have a problem displaying the report while connecting as a nurse in my organization. At first there was… -
OTBI Analyses not showing Worker DataSummary: The User cannot see all fields in a report although all columns used are attributes from one Subject Area. The columns the user cannot see are Worker related co…Sa_De_Or 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
90 Day New Hire TurnoverSummary: Trying to properly capture 90 day new hire turnover. Looking back 90 days from the day the report is run (today). Content (please ensure you mask any confidenti…CGardner01 81 views 19 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Original Hire Date Changed for Pending Worker vs. EmployeeSummary: Our original hire date was historically based on the work relationship start date. However, after the implementation of ORC it is now the effective date of the …Chad Morris 252 views 7 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM -
Audit ReportSummary: We did enable the audit for the PER_PHONES table. This reports on future phone number change history. We included date prompts. I updated the phone of the user …Stela Martins-Oracle 21 views 2 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Finding Records with Trailing Space in OTBISummary: Finding records that have a trailing space in OTBI Content (required): We have file transfers that fail when a trailing space is on the end of Address Line 1. I…
-
Analysis done using Security Roles and Privileges real time does not show all privilegesSummary: Created a custom OTBI analysis to get custom role inherited roles and privileges, compared against exports directly from Security Console. There are plenty of m…DiegoCastanon 31 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, NivyaNivya Mathire 41 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Job Entry Date and Department Entry Date Equivalents in OTBIContent Wondering if anyone has identified a way to access job entry date and department entry date in fusion hcm. These were delivered calculated fields in People Soft,…Karen Costakes 255 views 7 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for HCM -
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want …