OTBI
Discussion List
-
Need Header even No Data returns on BI Publisher output (CSV)Summary Header is not coming in BI report when No Data returns (CSV)Content In My BI Report, I am passing date as a parameter. When No Data Returns for date parameter, H…User_6U8NQ 362 views 7 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for HCM -
How can I report on a specific pay element in OTBI?Summary: I need to be able to include a specific pay element but OTBI excludes anyone who doesn't have this Content (please ensure you mask any confidential information)… -
We have Job Application - Progression"."Current Phase" but it showing only phase like New onlySummary: Hi Team, Below subject area we rae using to know the Job Application - Progression"."Current Phase it showing of New or another phase but we need days in Phase …AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Newly created prompt by one user not seen for other userWe wanted all BUs to be by default selected when LM Dashboard is opened up. So we modified the existing prompt by removing the filter of selecting the topmost BU. When c…
-
Unable to get the Enterprise Seniority Date Person level in OTBISummary: Hi all, I am not able to find the field related to Enterprise Seniority Date Person Level in OTBI using the subject area Workforce Management – Worker Assignmen…Deepak Bhatt 936 views 38 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Filter null values on a DashboardSummary: Hi, I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example. If I use…Guido Masciello 12 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Scheduled absences not showing in Absence OTBI ReportSummary: Hi All, Scheduled absences ("Workforce Management - Accrual Real Time"."Front-Loaded Plan"."Scheduled Absences") not pulling any data in my OTBI report. Could a…Sai Krishna Chelikani 31 views 2 comments 0 points Most recent by Sailajad Reporting and Analytics for HCM
-
How to find Legal Full Name in OTBISummary: Hi Team, we have Legal Full Name column in person details page but unable to find out in person real time ad worker real time. Please help me any one . Thanks, …AjayKumar Maddipati 11 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Headcount value 0 for some employeesSummary: I was comparing the headcount (the built-in fact) against the employee detail row wise data and the counts did not match. I noticed that some employees had the …Swapna Govind 45 views 3 comments 0 points Most recent by Swapna Govind Reporting and Analytics for HCM
-
Element Entries Reports No Results on OTBISummary The specified criteria didn't result in any data ErrorContent Hello. I'm trying to report element entries on OTBI using the "payroll - element enteries history r…BenZionP 305 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaSummary Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaContent Hi Expert, Not able get information in "Workforce Succ…User_2025-02-05-01-04-36-989 37 views 4 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
Drill down in OTBI Dashboard does not work correctlySummary: Drill down in OTBI Dashboard does not work correctly Content (please ensure you mask any confidential information): Hi, we created a Dashboard based on a OTBI R…Barile Alberto 23 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
HR own position data not appearing for HR rolesSummary: Position Report is showing positions to the HR teams but its not showing their data Content (please ensure you mask any confidential information): I have a posi…
-
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 24 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
How can we add Date Prompt to DB prompt without using column from Subject areasSummary: We need to add a Dashboard prompt for Start Date and End Date. These two fields are just a Date parameter. We dont want to use any OTBI analysis column. How can…Abhishek Jois 31 views 6 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM
-
what does below hint mean?Summary: SET VARIABLE OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_complex_view_merging'',''false'') GATHER_PLAN_STATIS…Pritha 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 785 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…Joanne Chung 471 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 104 views 3 comments 0 points Most recent by Josel Pleyto Reporting and Analytics for HCM
-
Birthday reportSummary Birthday report worked exampleContent Hi there I have a requirement to create a birthday report, that can run two weeks before the employee birthday month. This …User_2025-02-04-15-07-59-505 459 views 22 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include…Swapnil Kashid 53 views 6 comments 0 points Most recent by Iann hick Reporting and Analytics for HCM -
Historical report on positions held by active and inactive employee within a date rangeSummary: Looking for a historical report on positions held by active and inactive employee within a date range Content (please ensure you mask any confidential informati…M.Naing 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Matrix manager dimension in worker assignment real time subject areaHello Team, I have used attributes in matrix manager dimension of "Workforce Management - Worker Assignment Real Time" subject area to get all direct and indirect report…VMahesh 33 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Talent Review Rating HistoryHello, I need to pull a historical record of Talent Review ratings. I know it's possible to pull Performance Document rating history, but I'm specifically being asked fo…Nick Dorfner 51 views 5 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Dashboard on Development Area: hrr_tmpl_metric_configSummary: Goodmorning, we're fancing a problema with the Talent Review Matrix in the Dashboard Standard The matrix is empty: analyzing the query from the log, we've seen …AM HRE 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Female turnover rates of DashboardI'd like to ask that if I select the Female as the Gender, how is the female turnover rates calculated? Is the denominator of the ratio in relation to all employees or o…Chen, Reyna 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM