OTBI
Discussion List
-
Areas of Responsibility - No Results when including Worker DataSummary: No Results is being returned when including any Worker data into an analysis for Areas of Responsibiltiy Content (required): We are creating an analysis using t…David Bean-259734 460 views 14 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …Caterina Ruggiero 5 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Download PDF DashboardsSummary: Download PDF Dashboards Content (please ensure you mask any confidential information): Hello experts, we would like to download a dashboard as pdf but it seems … -
Show Only Maximum Current Year Enrollment Coverage Start DateSummary: I have an OTBI Benefits report that should show only current year max enrollment coverage start date . The Enrollment Coverage Start Date field has the below co…JHaden3 37 views 4 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Create an Effective Date Parameter for OTBI ReportSummary: Hi. I am sorry if this question has been asked before. I am looking to add a Effective Date Parameter to an OTBI report so when the user goes to run the report,…Jose Guerra 2.1K views 20 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
I Combined two subject areas but two records coming with active status but only one activeSummary: Hi Team, We have Combined two Subject Areas but assignemnt status showing as active with two records both are active but diffrence is one is with termination da…AjayKumar Maddipati 45 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Do we have feasibility to get the employees without performance document attached in OTBI report?Summary: Do we have feasibility to get the employees without performance document attached in OTBI report? This should be work based on Prompt basis like review period, …
-
DFF - Character limitContent We currently have a flex field with a character limit of 160, it is proposed that this is increased to 1500. Will it be possible to still report in an OTBI analy…
-
BU prompt in OTBI report isn't working. Whatever BU is selected, data is being returned for all BUsSummary: I have created a report with both a graph and a pivot table designed to return a count of faculty members with different attributes. I need these counts to be b…David Pearson 26 views 2 comments 0 points Most recent by David Pearson Reporting and Analytics for HCM
-
Dashboard Prompt Not Working on Logical SQL AnalysisSummary Dashboard Prompt Not Working on Logical SQL AnalysisContent Hi experts, - I have created a report using Logical SQL. Please see attached. - I created a dashboard…Raymund Jerome 215 views 18 comments 0 points Most recent by Kaustubh Deshmukh Reporting and Analytics for HCM
-
Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWVSummary: Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWV Content (required): Exceeded Configured Maximum Number Of Allowed Output Promp…Swati U 512 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM Compensation/Payroll Element Entries History Real Time Excluding Inactive / Terminated EmployeesSummary: Payroll - Element Entries History Real Time does not appear to be returning data if the employees latest assignment is inactive (the employee is terminated). Co…bwdata 63 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a table which holds the certificate information within the security consoleSummary: Is there a table which holds the certificate information within the security console for users. I need to see what certificates employees have associated with t…
-
Report on Active/Inactive UsersWe have a list of users (not employees, these are users created in the security console; our implementation partner) and I want to report on these users and whether or n…Alex Cardenas 647 views 9 comments 1 point Most recent by Girish Bhatia Reporting and Analytics for HCM -
Email Notification Report for NudgesSummary: Email Notification Report for Nudges Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to get the list of email …Parag Hiremath 16 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need to pull in Seniority Date using SQL and add to an analysisSummary Adding Seniority Date to my Logical SQLContent Hi All, I hope someone is able to help me out. We currently have an Analysis that we were using to produce a repor…User_2025-02-04-08-51-08-912 838 views 3 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM -
Access run history & older report outputs of OTBI scheduled reportsHi! We have end users who sometimes request previous run versions of scheduled reports. Wondering if there is a way to access run history along with report data output o…Ameya_J 34 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to build an analysis report of all pay periods that exist to dateSummary: I'm trying to build an analysis in OTBI that brings me all of the pay period names and dates for all Consolidation Groups in a Legislative Data Group. This is t…sarah_1000 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Link Produce Costing Setup Details with Assignment DataSummary: I am trying to link data from the following two subject areas:- "Payroll - Payroll Costing Setup Details Real Time" "Workforce Management - Worker Assignment Re…Mark Stoker 7 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Headcount is not being populated in Work Measure tableSummary Some employees have rows for HEAD others don'tContent Hi There, Does anyone know why HEAD information is populating for some employees but it is not for others? … -
we joined two subject areas but when we apply single country it is woking fine but multiple not workThere was an error rendering this rich post.AjayKumar Maddipati 27 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 50 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to fetch attachments from OTBISummary: Hi Expert, Currently, I'm using "Recruiting - Recruiting Real Time" & "Recruiting - Recruiting Event Real Time" Analysis and want to see the attached file in my…Saher 163 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"…
-
Query to fetch 'Report Job Histories' data from 'Manage Job History'Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…jahanavi metta 107 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Dashboard prompt for effective date reporting possible?Summary: Hi all, I have added SET VARIABLE PARAM_EFFECTIVE_DATE = '@{P_DATE}{@{system.currentTime}[YYYY-MM-DD]}'; into the advanced tab under prefix for a OTBI analysis …Ian.Gooderham 177 views 8 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Recruiting Real Time: Application Questionnaire reports take several minutes to generateSummary: When trying to run a basic query from RRT Application Questionnaire, it takes several minutes to run the query. Does anyone have ideas on how to improve reporti… -
How to add custom paramter based on other custom parameter in Dashboard PromptHi Team, I need to create custom parameter with formula based on the value from the other custom parameter with formula. Category and Sub cateogry - both are from same f…Harish S 17 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How i can improve the running time for one report?Summary: Misdated Payroll Relationship timming out I used this formula: CASE WHEN "Payroll Assignment"."First Standard Earning Date" = MIN("Worker Payroll"."Payroll Star…ClaudiaManea 27 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM