OTBI
Discussion List
-
How to get Salary Transaction entered by Name from Salary Transaction entered by for a Person NumberHello Everyone, I am using "Compensation - Salary Details Real Time" subject are to build a report. This subject area already holding a field "Salary Transaction entered…Ranjubala Pradhan 21 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to link Dependent Care Physician to DependentSummary How to link a Dependent with their Dependent Care PhysicianContent I am trying to pull a report of employee and dependent care physician after Open Enrollment. I…User_2025-01-30-03-28-08-030 41 views 9 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Direct join between Benefit and Element tables issueSummary: Hi, I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry…Ranjubala Pradhan 81 views 3 comments 0 points Most recent by Ranjubala Pradhan Reporting and Analytics for HCM
-
Not getting the proper charts on the user defined logical sqlSummary: I have written a sql statement by performing a left join between two subject areas. Have got the desired output. However am note getting the expected outcome wi… -
Absence Date End problem with clock change in OTBISummary: During British Summer Time (BST) (GMT+1) the Date End of an absence has a time stamp of 1am the next day. So 01/05/2021 00:59 not 30/04/2021 23:59. Content (req…Robert Craske 41 views 4 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Check list real time SA for onboarding questionnaire but output vertical view issue in reportSummary: Hi Team, How can I convert Vertical into horizontal of question text and response answer . we need candidate onboarding questionnaire feedback suervy but in que…AjayKumar Maddipati 51 views 10 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI Dashboard Usage Via TileHi all, We've built an OTBI dashboard and we'd like to share this via a tile on the front end of PeopleCloud. We've followed these instructions we found on here (pdf att…MikeW 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
US compliance reportingWe plan to retire our US & CA Operational Data Store (ODS). Currently, it feeds HR & payroll data to multiple downstream applications. Equally as important, it helps us …Santo Campione 22 views 2 comments 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM
-
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 35 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
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 73 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 191 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 755 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 203 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