OTBI
Discussion List
-
Is it possible to download the BIP output files to the particular folder in Machine?Summary: Is it possible to download the BIP output files to the particular folder in Machine? Suppose when we run any report, is there a way to download the output files… -
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names/SQL that is being used in the Workforce Learning - Learning Management Real Time subject are .we have requirement…minati_behera-Oracle 91 views 2 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?Summary History records of a personContent Hello, Can anyone please help me with the below scenario? I would like to get previous job changes/history (and few additional… -
Is there a way to display the values selected in the Prompt on the DashboardSummary Is there a way to display the values selected in the Prompt on the DashboardContent I created a dashboard, which contains the prompt and result area. as shown in… -
How to create date range parameter i.e. Date from and Date to in OTBI report?Summary: How to create date range parameter i.e. Date from and Date to in OTBI report? Content (required): We want to fetch payment details from specific date range in O…Priyanka More-Oracle 1.5K views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 66 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
User folder not visible in right pane due to system limitation of 300 folders at a timeSummary: Per Doc ID 2443757.1 users folder permission can be set by navigating to folder. However though I can see the user folder in left pane can't navigate to the sam…
-
Workforce Management - Absence Real Time Subject Area not returning any dataContent Workforce Management - Absence Real Time Subject Area displays 'No Data found' . Can someone who has used this Subject Area please let me know the roles that hel…Shruthi Ramesh 215 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Email Notification when Employee Changes Their NameSummary: I would like to setup an email notification to go out to a particular address each time an employee changes their name. Or optionally one email per day with a l…User_2025-02-12-02-38-00-520 22 views 4 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM -
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM - Administrator Role for Report Scheduling in HCMSummary: Create an Admin record in HCM for Report Scheduling Content (required): Is there a way to create a user account in HCM that can be used as a central scheduler f…
-
Release 13 Version 20B: Steps to enable and create an infoletSummary Release 13 Version 20B: Steps to enable and create an infoletContent Hi All, Please find attached herewith, a step by step documentation with screenshots on how …User_MC37Q 243 views 2 comments 15 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec…gguittini 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 454 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
HCM reporting on hours and average hours workedSummary HCM reporting on hours and average hours workedContent Hello Does anyone have any ideas about tracking average hours worked for hourly associates, as it relates … -
OTBI Report for a list of OTBI ReportsContent I'm looking for a way to report on our current OTBI reports in their respective folders. I'm not sure if BI Publisher is the only route, but I couldn't find any …
-
Converting UTC to EST time zone in Logical SQLSummary: Our report is built with logical sql, the approval dates are displaying in UTC time zone and we need these to reflect EST time zone. Need help with syntax. Cont…Denise Izzi 2.5K views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Aggregate function in OTBI AnalysisSummary: Please share some documentation on using various aggregate functions on any column of an OTBI analysis Content (required): Need to use aggregate functions acros…Hem 393 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Users cannot see their own accrual balanceSummary: Users cannot see their own holiday accrual balance in OTBI accrual report Content (required): I have an OTBI report showing Accrual Balances using the Accrual R…s_b 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need inputs to get the Target Element Name under Status Processing RulesSummary: Need inputs to get the Target Element Name under Status Processing Rules in Element UI Content (required): We can have a link between Pay_Element_types_vl and P…
-
OTBI reports to replicate delivered reports in Workforce Compensation > Pay for PerformanceSummary: Workaround solution following 21D release "improvement" Content (required): It has been decided by Oracle to disable reports in order to improve the performance…Amandine C-Oracle 31 views 1 comment 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Analysis with Approval Notification Data (Initiated/Approved dates) for terminationsSummary Creating an OTBI for terminations that include the Initiate Date and Final Approval Date from Approval Notification Subject areaContent Hi, We have an OTBI Analy…Denise Izzi 104 views 6 comments 2 points Most recent by Denise Izzi Reporting and Analytics for HCM
-
Security for OTBI ColumnsSummary Security for OTBI ColumnsContent Is it possible to Apply Security around specific columns in an OTBI Subject area? The current understanding is access to Subject…Harish Kumar Kovi 106 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard over a Mulitple assignment HCM config - need to eliminate wrong result from dashboardSummary: VP is seeing an Indirect reports Director that is outside of Talent/Performance Goal Drill-down compared to User Interface for Performance and Goals (Talent) Co…John White-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination Report needed (workflow initiated date vs the actual termination date)Summary: We are in need of a report which will help us catch "late terminations". Report should have a date in which the workflow was initiated, and then the termination…
-
Denied the delete option from everywhere.Summary: Hi Team, I have created a custom role, and I want to denied the delete option from which function need to denied for my custom role and only the "BI Author Role…User_2025-02-12-18-16-01-181 42 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Error When Trying to Save Agent (Scheduling a Report)Summary: I am getting this error "The following error occurred: Oracle BI Scheduler Error: [nQSError: 12017] Unexpected socket read timeout: connection terminated by net…Erin Hamrick 12 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM