Reports
Discussion List
-
Could please help me on to find FTE cloumn in OTBI subject areaSummary: Hi Team, We need FTE column in OTBI report, I have taken worker assignment real time but I can't find out FTE column. Any help me on . PFA. Content (required): …AjayKumar Maddipati 37 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 22 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 73 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM
-
SQL for Environmental health and safetySummary: Team, Does anyone have the sample environmental health and safety BI report (SQL). Please share Content (required): SQL for Environmental health and safety SQL … -
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 76 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Table name to get Element CategorySummary Table name to get Element CategoryContent Hi Team, Can someone help me with the table name to get the "Element Category", i was able to get this information inOT…User_2025-02-04-07-00-18-658 373 views 12 comments 0 points Most recent by Veerachari Reporting and Analytics for HCM -
Absence category and absence types under this category query.I need a SQL query that returns information about the absence category and the absence types connected to this category. I would be grateful for the query you can share …Cansel Karasoy 252 views 11 comments 0 points Most recent by Cansel Karasoy 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 30 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
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 852 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 …
-
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 2 views 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 1.8K 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 60 views 8 comments 1 point Most recent by Kimberly Nguyen 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…
-
query to get current logged in user_id in BI publisher reportSummary query to get current logged in user_id in BI publisher reportContent Hi Experts, how to get current logged in user_id in BI publisher report. Thanks, PradvinPradvin Prabhakar 4.8K views 7 comments 2 points Most recent by MastekLtd Reporting and Analytics for HCM
-
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…
-
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s…
-
How to fetch learning community access group details?Hi everyone, I have a requirement to fetch the learning community access group details like, Community Access Group Name, Community Access Group Learner Count and Commun…Prashanth Sangram-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta 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…
-
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 280 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…
-
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…
-
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 154 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath…Nisha_Hegde 12 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
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…
-
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 260 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 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to build OTBI report to show have 0 incumbents for active positions ?Summary: Content (required): Need to build OTBI report to show have 0 incumbents for active positions along with Position HC Version (include the version you are using, …Nikhila 22 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM