OTBI
Discussion List
-
Admin tool or (other method) to identify all OTBI Subject Areas that my company can accessSummary: Is there an admin tool (or other method) to identify all OTBI Subject Areas that my company can access? Content (please ensure you mask any confidential informa… -
Recruiting Custom Posting Description Fields Query / SQLHello Experts We need to fetch in a query posting descriptions, for internal and external posting, that were entered by the Manager on Job Requisition Creation > Recruit…Pedro Teixeira 202 views 1 comment 0 points Most recent by Ben Baumes-Oracle Reporting and Analytics for HCM -
Top 5 reasons for sicknessSummary: Hi, Has anyone got any ideas how i can get top 5 reasons for sickness and display the same as a % of the total absences? Also how to achieve the top 5 reasons a…BillM 36 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Database table that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real TimeSummary: Can someone provide the Database table name that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real Time specifically looking for the Calcula…Laura Goodall-Brown 23 views 2 comments 0 points Most recent by Laura Goodall-Brown Reporting and Analytics for HCM -
Talent Review - no results OTBISummary: We have created a custom Talent job/data role which contains the relevant security access to view Talent in My Client Groups. We now want this custom Talent rol…Jo Ord 27 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Data is not retrieving for not started status in OTBI DashboardsSummary: Hi Team, I hope this message finds you well. We are currently facing an issue retrieving data for the 'not started' status regarding employee feedback. Specific…Sujan Kumar Dash 16 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Payroll - Payroll Balances Real Time subject area giving No ResultsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Opportunity market place report - Self service PUBLICSummary: Do you have any report available that could help me to provide a listing of all jobs available in opportunity marketplace ? The report should be public (linked …Jacqueline GRANDIN 20 views 3 comments 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Sickness Absence ReportingSummary: We have work schedules entered for all employees showing their working days. We need to export this in our absence reports so we can calculate working days lost…Karen Wilson 16 views 4 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
How should I find the full names of the people in the approvers column in the fa_fusion_soainfra.WFTHello, I use the APPROVERS column in the fa_fusion_soainfra.WFTASK table in my report, but the username is included there. I need approvers display name information. Can…Cansel Karasoy 25 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
pivot table/ stacked graphSummary: Hi all, I have created an analysis and used a pivot table to generate the stacked graph. Does anyone know if we can move the totals to the top so that it is not…
-
How to set a As-Of Date Prompt in a Dashboard PromptSummary: How to set a As-Of Date Prompt in a Dashboard Prompt Content (please ensure you mask any confidential information): Hi, we created a dashboard. This dashboard h…Barile Alberto 94 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 24 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Excel Report Errorummary: Hi experts, we are trying to upload a ready excel file as a Report, but we continue to receive the following error message when trying to view it. We have alread…Marlon Castillo Maliglig 17 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
SQL IF Statement for FiltersSummary: I am attempting to create an OTBI report that has both work and personal/home email for new hires. For the work email I have that information from the Worker As…
-
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 17 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM
-
OTBI: manager with at least a direct report both based in the same countryHi everyone, Our customer has the following requirement: To retrieve the list of the manager L1 located in italy with at least a direct report Both manager and direct re…Alessandra T. 18 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Pivot Table limits numbers of rowsHi, I have an OTBI report for Total Comp Deferred Cash Payments year wise. This is a simple report from subject area - Payroll - Element Entries History Real time. We ar…Arnabb 51 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to report on Directly Assigned detail in AOR TemplateSummary: I'm looking to report on the Directly Assigned detail in an AOR Template Content (please ensure you mask any confidential information): I've looked in all the A…
-
Absence Accrual BalancesContent Hi - I have a report that shows the absence accruals for each of our plans and it works great for those that are calendar year Plan Period Type. It shows me the …Prudence K 356 views 27 comments 4 points Most recent by Shameer Shaik Reporting and Analytics for HCM -
Line Manager Dashboard custom with Manager Name HeadcountSummary: Hello, I made a custom OTBI dashboard from the vanila Line Manager Dashboard. In that dashboard we added one prompt Manager Name that is prompted. So when we se…Ilzura Ismailhodjaeva 66 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Compensation OTBI Best PracticesSummary Technical brief discussing compensation related OTBI best practices Content Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 152 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Benefits arrears OTBI reportHi all, We are trying to develop a new OTBI report for benefits arrears , we have used the following 2 subject areas with effective date prompt. 1.workforce management -…yugandhar 171 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How to select more than one filter option in OTBI ReportSummary: How to select more than one filter option in OTBI Report Content (please ensure you mask any confidential information): Hi, we created an OTBI report. This repo…Barile Alberto 65 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Recruiter Preferred NameSummary: Wondering if anyone was able to pull the recruiter preferred name and preferred last name in OTBI reports.Marta Martinho 16 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI - worker assignment real time - user visibility issueSummary: OTBI - worker assignment real time - user visibility issue Content (please ensure you mask any confidential information): Hi team, we have an issue with an otbi…Claudia Schiff 17 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Get all EMP reporting to a manager in certain time periodI am looking to get all direct reports(all active and term) of a manager during the time period 10/31/22 to present day 05/20/24. If termed I need also need the term dat…Trupti Khodke 16 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM