OTBI
Discussion List
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 89 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can we create analysis to fetch terminated workers who HAVE NOT been rehired since their terminationSummary: Can we create analysis to fetch terminated workers who HAVE NOT been rehired since their termination Content (required): Using worker assignment real time busin… -
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks ThiruThiru Ch 308 views 16 comments 2 points Most recent by Venkataramana N Reporting and Analytics for HCM -
Sending Bursting pdf as an e-mail body instead of outputI have a notification work that I have prepared, the report returns table type employee data and absence detail.I can send this tabular report as a pdf output, but I wan…Cansel Karasoy 33 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the … -
AS-OF-DATE on Prompt - CURRENT_DATE_REP_OTBI-Session DateSummary: I am using CURRENT_DATE_REP_OTBI in the calendar prompt # As of date . The date is is not defaulting correctly. The session date defaults to 01-Nov-2021. While …
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…Parag Hiremath 880 views 16 comments 0 points Most recent by HarshithDarla Reporting and Analytics for HCM
-
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
We need to capture the Employee Acknowledgement Flag / Checkbox ResultsSummary: We need to capture the Employee Acknowledgement flag at the completion of a Performance Document, so it can be included in OTBI reports, and captured by Azure S…
-
Extract description of lookup in OTBISummary: Content (required): Hi everyone, we are having problems extracting the value of a dff configured for the JOB. Is it possible to extract the description of the r…Gerardo Peluso 1 view 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI Report is not giving results.Summary: Hi Everyone! Workforce management - Worker Assignment Event Real time I am using above subject area to create a report but when i click results, i am getting " …ShawShankk 2K views 9 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we schedule a OTBI report by password protecting the output?Summary Can we schedule a OTBI report by password protecting the output?Content Hi, We have a question: Can we schedule a OTBI report by password protecting the output? …User_MC37Q 62 views 8 comments 1 point Most recent by Kimberly Nguyen Reporting and Analytics for HCM -
Learning Report to Track Course CompletionSummary: We have been using Managing Learning Real Time subject area to build our report to track completion status for each course and offerings. However, that subject …Ratha Sun 121 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
How to use Use the BulkDataExportService web service introduced in 22ASummary: Documentation missing for OTBI Webserivce BulkDataExportService Content (required): Release 22A has a note: Use the BulkDataExportService web service from the a…rsi-mir 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Split rows in Succession Plan reportSummary: Hi Experts, I've created 7 DFFs on the Succession Plan candidate page. To report these I'm building an OTBI report using the "Workforce Succession Management - …S Shree 32 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there a way to combine this so that the team shows on one row?Summary: Is there a way to pull the team on one row instead of duplicating per territory role? Content (required): I am trying to create an analysis for sales. The terri…
-
How to change middle name field to just one character?Summary: When the middle name field is more than one character, is there a formula that can be used to only show the first character? For example middle name contains "W…
-
Pension and annual salary data in one reportSummary: Hi, We are trying to build a report which provides information on an employees pension and annual salary. The report is built combining subject areas. When comb…NusratB 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do we find out the date a leave of absence was approved?Summary How do we find out the date a leave of absence was approved?Content We are using the 'Workforce Management - Absence Real Time' subject area and using the 'Assig…
-
Assignment Start Date Explained?Summary: Could an Expert help me understand how when Adding Assignments to a person, the Assignment Start Date field works in the Workforce Mgmt Subject Areas? The issue…
-
How to pull correct Learning Assignment Status valuesSummary: Cannot determine the logic to pull the correct Status value that is displayed in Status column of Learning Assignment Page. The Table has two Status fields and …Vanessa Gepitulan 285 views 6 comments 0 points Most recent by Vanessa Gepitulan Reporting and Analytics for HCM
-
Extract the ID of a department (going active on 01 october) from FusionHello, In Fusion we have created a department that will become active on the 1st of October. For our integration with Taleo I need the Department ID of this department a…
-
Absence Headcount - Percentage of Employees on Leave by JobSummary: Divide count of employees by total number of employees Content (required): Hello experts, As the title suggests, I was trying to fetch the percentage of employe…
-
Workforce Compensation Plan delivered reports and dashboardsSummary: Content (required): Hello experts, are there any delivered OTBI analysis and dashboards for Workforce Compensation Plan module? If so, please could you share th…Valerio Curzi 4 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Pull all of one HR Action as long as another HR Action doesn't exist afterSummary: Long title after contemplating how to ask this...:) My analysis pulls all HR Actions that equal 'Termination.' What I need to do is exclude any worker who had a…
-
How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI.Summary: How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI. We are able to fetch data only for the field "Overall Summary Manager Rati…
-
Report shows no results for certain usersHello, We are facing an issue regarding the ability to view a report of the subject Area of Workforce Management - Checklist Real Time. Here is the report that we have c…Ioannis Adamou 29 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to I pull a report on departments that shows the hierarchy level ?Summary: I need an establishment report with position details. Content (required): We have recently migrated to Oracle Fusion and are still getting our heads around it b…Isabela Radivoi 178 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report - employees' action and action reasonHi all, we are having difficulty in exporting the Action Code/Name and Action Reason Code/Name for each employee. We can connect 'Person Number - Reason Code' but, canno…Lia P 274 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Assignment and Person Information for Whole Employee PopulationSummary: Hi - I have created a report that is supposed to pull in a combination of Assignment data, comp data, work relationship and person real time information (4 subj…Kyle Norris 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM