Reports
Discussion List
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 7K views 17 comments 2 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Dashboard prompt dependentSummary: Creation of a Dashboard prompt with Job Family, Job Function and Job Profile field dependent from each other. Content (please ensure you mask any confidential i… -
Issue in adding Ethnicity Column.Summary: Hi All, I have an OTBI report that tends to fetch all the performance details of an employee, we are trying to add ethnicity column in the report with formula: …Sushant95-Oracle 11 views 0 comments 0 points Started by Sushant95-Oracle Reporting and Analytics for HCM
-
Need inputs to handle NULL values in OTBISummary: Need inputs to handle NULL values in OTBI Content (required): In case if an employee doesn't have Visa permit record then we are getting value as 00--0 in the O…
-
OTBI Report - Advanced Query - presentation variable is null, how to handle?Summary: In OTBI Report, I have used Advanced Query to combine multiple subject areas. As a parameter I'm using presentation variable. If the presentation variable is pa…
-
Add record ‘creation date’ in an otbi reportSummary: I would like to add the event 'record creation date' in an OTBI report I am developing, using the 'workforce management - worker assignment event real time' sub…Paul Morrissey 11 views 4 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM
-
Reports on Generative AI Usage and AuditsSummary: Reports to get data on Generative AI Usages and feedback. We are implementing Gen AI for feedback generation but need reports to understand GenAI feedback and U…
-
Person Management>HCM Group Override - Cannot find this field in Reports and Analytics.Summary: Trying to build a report that includes the values of the field "HCM Group Override" in Person Mangement in Oracle Fusion. I cannot find this field, and I've loo…xpiredmilk 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Presentation variable in Column Filter possible?Summary: Hello all, Not sure if this is possible - I would like to use a variable inside a column filter, for example for YTD Actual I have filtered on scenario Actual H…Ian.Gooderham 21 views 7 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
How to use Choose and when condition in fusion hcm bip rtf templateSummary How to use Choose and when condition in fusion hcm bip rtf templateContent Hi Team, We have created BIP Report to send notifications based on legal employer wise…User_2025-02-01-06-07-07-886 94 views 8 comments 0 points Most recent by Neha Aishwarya Reporting and Analytics for HCM -
sql query to get resignation approval statusSummary: Hello , I need to add column "pending with " in BIP if Resignation is pending for approval with Line Manager then "pending with "column should display "pending …
-
Help! Need to increase Font SizeHi We are working on our Line Manager Dashboard. We would like to add a custom tab in the dashboard. The tab would be all text as we want to add key definitions for some… -
Can we display alpha numeric values in Pivot table?Summary: Can we display alpha numeric values in Pivot table? Content (please ensure you mask any confidential information): We have a requirement to fetch the UDT (User …
-
No language pack but still errors coming in Hungarian LanguageWe have language pack installed but Hungarian language is not enabled. But still our users are receiving errors in Hungarian language Nincs eredimeny - No Results Found
-
Count of All Performance Goals is not showing properlySummary: Hello, can you pls check my filters below. The Count of All Performance Goals is not showing properly so I added the Goal Status filter but still not showing up…
-
Does anyone know formula for Turnover% in Line Manager DashboardDoes anyone know formula for Turnover% in Line Manager Dashboard ? or do we need to edit the report, check the query and find it out ourselves. There is literally no doc…
-
How to Hide Row in BI Publisher Using Conditional RegionSummary: Hi Expert, I'm trying to hide a row based on a simple condition. We have three rows in the offer letter, and the condition is that if the attribute value is nul…
-
Historical Location Data Workforce Learning - Learning Records Real TimeSummary: Content (please ensure you mask any confidential information): We have started to move our reports to the Workforce Learning - Learning Records Real Time as the…Jeremy CSC 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Transaction console approvals reportThe user is asking for a BI report that shows all the approvals for a transaction in HCM, right now I'm able to find the current and historical approvals but I can't fin…RODOLFO GARCIA SOTELO 23 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How we can password protected a bursting BIP report?Summary I want to burst person Information and i want the output file should be password protected with person DOB(MM-DD-YYYY). How we can achieve this using burstingCon…Ashish Mangal 754 views 9 comments 0 points Most recent by Bhanuja Batra-Oracle Reporting and Analytics for HCM
-
How to bring HCM UDT Columns into Fusion OTBI subject areaSummary: Need to access the UDT columns (HCM) in OTBI standard subject area's instead of using the "Payroll - User Defined Tables Real Time" as a separate subject area. …
-
How to identify who made changes to the DFFs we used in our OTBI reports?Summary: There are few OTBI reports in Dev env which resulted in error because of missing DFFs. we got the DFFs back by running the schedule process. but we want to know…Hitachi ServiceDesk 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to filter a column?Summary: Hello, I need help on how could I filter to show only the last row. Thank you in advance! Content (please ensure you mask any confidential information): Version…
-
How to write a query to get accurate "when is the employee start date?" from the OfferSummary: Hi Team, We are trying to add value for "When is the employee start date?" in one of ours Offer accepted report. However when the employee start date is changin…
-
Multiple Templates - BI Publisher BurstingSummary Multiple Templates - BI Publisher BurstingContent Hi Experts I have a BI bursting report where we need to send an attachment as well as the bursting email notifi…Mansur Khalil 200 views 7 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES TableSummary: Use of PAYROLL_CHG_FLAG in ANC_PER_ABSENCE_ENTRIES Table Content (required): Hi All, Can anyone please let me know the use of the column PAYROLL_CHG_FLAG in ANC…
-
DFFs missing from few OTBI Subject areasWe have Multiple OTBI reports in which the DFF columns are missing from the subject areas. after running the “Import Oracle Fusion Data Extensions for Transactional Busi…Hitachi ServiceDesk 14 views 4 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With…
-
How to embed/display the DOR attachments/images (blob data) in BIP reportWe have a requirement where employees signature needs to be captured in BIP template/report. So we are thinking of loading the employee signatures as an image via DOR ag…
-
Need API for User module name , Module key and module type under manage value setsSummary: Hi Team, We need a API to get User module name , Module key and module type under create value set as shown in below screenshot. Content (please ensure you mask…