Category 81
Discussion List
-
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 876 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…
-
BI Publisher reports now timing out (previously working)Summary: I have two BIP reports that were created several years ago that are now timing out. They began failing around the beginning of September 2023. Content (required…
-
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 4 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to capture an end date on Individual Compensation element?Summary: How to capture an end date on Individual Compensation element? Content (required): I am trying to award compensation to an employee in the form of a sign on bon… -
Can anyone help adding position No and Name to my SQL Query?Summary: I need to add the Position number and position name to the SQL Query Content (required): Hi everyone, Could anyone help me to add the position number and positi…Isabela Radivoi 108 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 2K views 9 comments 0 points Most recent by Raghavan p-Oracle 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 126 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…
-
Impact on DBI's when we move from Seniority date V2 to V3Summary: We are planning to move to V3 version of seniority dates functionality. We are in V2 and since we can still access V1 we are using DBI' referring V1 Table (Per_…User_2025-07-18-06-45-42-477 159 views 3 comments 0 points Most recent by Unknown Human Capital Management
-
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…
-
How do I sun total absence duration by employee?Summary: I want to get the total days lost for each employee. Content (required): Does anyone know how to sum in a table report that looks at the rows of data for each e…Isabela Radivoi 21 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
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
-
What HCM table can I use to get the future Line Manager?Summary: I'm checking if I can use the BIP Bursting feature to send details which includes tasks to the worker's future LM once the transfer is approved. The client want…
-
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 22 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Which tables store the Weekly Working Hours data?Summary: Which tables store the Weekly Working Hours data? Version (include the version you are using, if applicable): 23BLuke.Findex 62 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Where can the admin find a saved transaction (departments in this case)?Summary: Where can we find a saved transaction? Content (required): Dear experts, we started creating departments with Manage Departments in FSM and as we missed some de…Oana C 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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…
-
Oracle BI Tables for compensation plan columnsSummary: Content (required): Hello experts, do you know which Oracle HCM BI Tables store compensation plan user-defined columns (custom numeric and text column); Compone…Valerio Curzi 23 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 287 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 2 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…
-
BIP email's font appear diffrent within gmail than outlookSummary: Customized email's fonts appears diffrent Content (required): I'm designing a BIP template with the kind of rtf format. I'm designing one of the journeys OOB re…Peleg Puzaylov-Oracle 22 views 5 comments 0 points Most recent by Peleg Puzaylov-Oracle Reporting and Analytics for HCM
-
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 201 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 11 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM