Reports
Discussion List
-
How are users interacting with systemSummary: Content (required): Hello We would like to know how our users are interacting with our system. The ASE_USER_LOGIN_INFO table shows the date of the last login, b…Helen Thomas 43 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Oracle Fusion HCM Extract getting fails when we select Delivery Type as FTPSummary: Hi, Delivery option getting failed when we select delivery type as "FTP" along with bursting in BI data model. if I select Delivery type as "None" extract getti…
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 61 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Tables relating to NotificationsSummary Question to assist in building a BI Publisher report on Time Card notificationsContent I need to create a BI Publisher report on notifications for time card appr… -
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 51 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Need function condition to exclude any character other than numbers and alphabets for address in BISummary: Need function condition to exclude any character other than numbers and alphabets for address in BI Content (required): Address should not have any characters o…
-
Understanding Actual Termination Date and Per_Periods_Of_ServiceSummary: Looking for SQL to pull in an accurate termination date given a point in time. And if that point in time is BEFORE the termination, then the business is wanting…SeanWesche 1.2K views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to generate EEO-4 report in HCM?Summary: Generate EEO-4 report as per federal requirements Content (required): What are the set steps required to generate EEO-4 report from HCM? Version (include the ve…Akhil Pillai 277 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Tile visual errors when The Table Visual is not added to ViewSummary: Hi, can anyone please help with the error message that appears when Table visual is removed from the view leaving the Tile visual in view. Content (required): T…
-
Is it Possible to remove Dashboard creation option from the RoleSummary: Is it Possible to remove Dashboard creation option from the Role Version (include the version you are using, if applicable): 22DHarish Vummidi 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…User_2025-02-12-00-53-03-661 171 views 2 comments 0 points Most recent by Monika_Dubey Reporting and Analytics for HCM -
how to remove these BI reports shared over app within SaaSSummary: We currently have our talent reports exposed within SaaS as an app per the below screenshot. We would like them to be disabled/hidden/delete from the UI. Can so…Deepak Rojanala 32 views 2 comments 0 points Most recent by Deepak Rojanala Reporting and Analytics for HCM -
Unable to see xls export option for BIP report after 22DSummary: Unable to see xls export option for BIP report after 22D Content (required): Hi , we are unable to see xls export option for BIP report after 22D and xlsx gives…PriyankaM 32 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Need A Dynamic way of setting Date Parameters to begin with the 01st AprilSummary: Hi, I need to schedule an OTBI report that looks at changes made to a salary from the 01st April to the last day of the previous month. For example the report s…
-
Organization logo not showing up when exported (MHTML format)Summary: Organization logo not showing up when exported (MHTML format) Content (required): Hi , We have added organization logo in RTF header, and it shows up correctly …
-
An OTBI report in Workforce Management-Work Relationship subject area doesn't work for some rolesSummary: We have an OTBI Report with 4 columns, all under Workforce Management - Work Relationship Real Time category (Display Name, Person Number, Worker Payroll Name, …Justin Hurley 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I add the manager information of the employees to the Analysis report?I want to add the managers of the employees such as 'head,c-suite,sr.head' to the report I prepared from the analysis report. When I get this information from the "Matri…Cansel Karasoy 42 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Termination report for multiple work relationshipsSummary: I need a true termination report for when someone leaves an organization with multiple legal employers, and they have multiple work relationships. I know there …Jessica D 62 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard with BI report linkContent Dear All, I have a requirement to create a dashboard with the direct links of BIP reports. Whenever user clicks on the link, it should directly generate the repo…User_2025-02-06-14-37-05-233 115 views 9 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
Unable to resolve " ORA-01427: single-row subquery returns more than one row"Summary: Hi Experts, When I open a BI report, I am getting, "ORA-01427: single-row subquery returns more than one row" Error. I checked each subquery and all subquery re…ShawShankk 844 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 295 views 2 comments 1 point Most recent by Valeriy Gorbunov Reporting and Analytics for HCM -
Address Validation report for USSummary: Hi, Do you have sample address validation report for US? Thanks, Content (required): Version (include the version you are using, if applicable): Code Snippet (a…
-
Worker dropping off report if null value in one columnWe're using the Workerforce Management - Worker Assignment Realtime and Workforce Management - Areas of Responsibility subject areas for the report I've attached below. … -
Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom…
-
How can I use parameters that work independently from each other on a single dashboard screen?Hi, I have multiple reports that I use on the dashboard screen and my 2 reports have promts. And from these separate promts there are common ones. I want to use the sepa…Cansel Karasoy 32 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Skills OTBI reportSummary: Dear Experts, Please could anyone help how to extract the OTBI report to find how many employees updated the Skills in the Oracle? Kindly help with the subject …Rajeshkumar_Sekar06 33 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we …Darren Nelson 289 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
I am working on one of the change only extract but I am not getting OLD values for few recordsSummary: I am working on one of the change only extract but I am not getting OLD values for few records Content (required): I am working on one of the change only with p…