Category 81
Discussion List
-
HeadCount OTBI reportSummary: Hi all I added these subject areas in my otbi reports:- Workforce Management – Worker Assignment Real-Time Compensation – Salary Details Real Time Workforce Man…Deepak Bhatt 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
TemplateSummary: Hi all, Problem statement: I created the attached template in RTF-> linked to the report -> export the output in pdf but now client wants to have the output in … -
DFFs no longer available in applicable Subject AreasSummary: Production Report Errors - DFFs no longer available in applicable Subject Areas Content (required): Has anyone had issues with DFFs in Analyses? Beginning the a… -
Combine 2 Analysis Outputs in on AnalysisSummary: Content (required): I have requirement to report on the number of starters by user person type and leavers by user person type in the previous month and email t… -
Need help to find the oracle table name of columns in Payroll Employee deduction report using BISummary: In the BI report, I have the requirement to add these Columns in my report Columns 1) Period 2) Pay Period Start Date 3) Pay Period End Date 4) Deduction Amount…Deepak Bhatt 32 views 7 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…Anita 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need help of running Element Entries - Real Time report for Workers Element entriesSummary: Hi Experts, We need to report on payroll elements for Employees. We have tried to use the subject area Payroll - Element Entries Real time. Whenever we are addi…Silpi 42 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Is it possible to use Crystal Reports with Oracle HCM data?Summary: Is it possible to use Crystal Reports with Oracle HCM data? Content (required): I have had many years of experience with Crystal Reports in multiple HCM systems…Donna Valentine 23 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How do I set an OTBI agent to only Email if there is data returned in analysis?Summary: How do I set an OTBI agent to only Email if there is data returned in analysis? Content (required): Hello I am trying to set up an agent but I only want to it t…Helen Thomas 21 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Ethnicity- Multi resulting in errorSummary: I am trying to decode the multiple option selected in the race condition used: COUNT(DISTINCT "Worker"."Employee Ethnicity Code" by "Worker"."Person Number") > …Anita 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Generate Employment Letter after approvalSummary: Employment letter can be generated using BI Reports but client wants certain letters to generated once manager/hr approves Content (required): Is it possible to…VivekHCM 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
LSQL with Prompts inputs not workingSummary: I've got a combined subject area LSQL which looks at 3 possible input prompt which can be blank or filled with values by end users. I'm passing the prompt input…Rohan Fernandes 21 views 2 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Reporting on real trends in headcount by hierarchy excluding impacts of reorganisationsSummary: We need to provide headcount trend data to our business leaders and managers for their respective organisation without the impact of reorganisations being visib…User_2025-03-07-20-15-16-297 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
RTF TemplateSummary: Hi Team, I am working on a report where the template used is RTF template. This report captures data both for pensioner and employee. Requirement is like if per…
-
OTBI Turnover Dashboard for Line ManagersSummary: I would like to provide a Turnover Dashboard for Line Managers in OTBI but the seeded / sample dashboards provided by Oracle are not returning data when logging…User_2025-03-07-20-15-16-297 137 views 13 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
Query to extract ExternalWorkerDataId by Start/End Date and Person NumberSummary: Hello experts, I should update external worker data. However, ExternalWorkerDataId information is not available in OTBI analysis. Is there a query available to …Valerio Curzi 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Error running OTBI AnalysisSummary: Getting error ' Incorrectly defined logical table source (for fact table Z - VO OBIA ETL) does not contain mapping for....' Content (required): I've had this sa…Susan Anderson 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Leavers not showing now on manager dashboardsSummary: Leavers show very small numbers or nothing Content (required): My dashboard reports have been working fine but now I'm getting reports from managers that they c… -
Talent Score - deep link in BIPSummary: Does anyone know if you can deep link from BIP to the Talent Score screen? I think it is here: My Team > Career and Performance path, page titled “Goals and Per…Andrew_Schmitz 11 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for HCM -
How to remove empty sub rows from a particular column in the OTBI report?Summary: I am getting the sub rows for employee self-rating and manager rating. I want to fetch the ratings for sections goals, competencies and overall summary. I have …
-
Job Qualification and Description for a profile from OTBISummary: How to get Job Qualification and Description for a profile from OTBI? I tried to find on Workforce Profiles - Model Profile Real Time but could not get it. Job …User_2025-02-12-02-30-59-547 32 views 4 comments 0 points Most recent by Sumathi Muthu Reporting and Analytics for HCM -
Links with BI Publisher when using With ClauseSummary: Data sets using the With Clause lose the ability to create links between datasets Content (required): I'm trying to leverage the powerful WITH clause in a bi pu… -
Added a report into OTBI Dashboard - Download is happening as two different PDFSummary: We have added a report as a section into Job Profile OTBI Dashboard, when i try to download the result into PDF, the report we have added is downloading as diff…Sumathi Muthu 34 views 6 comments 0 points Most recent by Sumathi Muthu Reporting and Analytics for HCM -
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 134 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Need help to build the sql logicSummary: Hi Team, I am working on a requirement for position incumbent. Here my code will get each positon with vacant positon details. And for each position one record …Mohan Murali 42 views 3 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Using Variables in Etext templateSummary: Hi Team, I was reviewing a oracle guide for etext template. For one of my requirement I am trying to use Variables in etext template. GetVar(var-name) ResetVar(…Mohan Murali 1.8K views 6 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Find column in OTBI reportSummary: Hi all, I have added these subject areas in my report:- Workforce Goals - Goal Plan Assignments Real-Time Workforce Goals - Goal Status Overview Real-Time Workf…Deepak Bhatt 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI export to excel and lost data.Summary: Content (required): Hello everyone, I wanted to ask you if you could provide us with more information or if it has also happened to you regarding the loss of da…Gerardo Peluso 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Logical SQL Dashboard Not Working After 22BSummary: Hi - we have a report that pulls payroll information and salary information. It is run weekly by our compensation team. It was working fine through last week an…Kyle Norris 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Line Manager can't see Time cards in OTBISummary: Content (required): Hi The Line Manager role can't access time card reports (standard Oracle Time Cards). The reports are standard and delivered by Oracle. The …Nicolas Vahman 44 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM