Reports
Discussion List
-
Track changes to Primary National Identifier (social)Summary: Track changes to social (Primary National Identifier) Content (required): Have a requirement to identify changes (within the last 30 days) to a person's Primary… -
Workflow Notification TranslationsSummary: Workflow Notification Translations Content (please ensure you mask any confidential information): Hi , When we customize seeded notification and make copy of it… -
Quick Action Employment Start DatesSummary: Report to identify details when Quick Action Employment Start Dates is used Content (required): Need a report that shows when a Hire Date is changed when using …JHaden3 41 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get previous experience of employee plus current company experience in OTBI or BISummary: Hi Team, we have requirement to get the previous experience of employee in OTBI is possible. In BI , we used (ff_user_column_instances_f fucif.value as experien…AjayKumar Maddipati 32 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Maintain Meta Model and IndexHi, We have a Maintain Meta Model and Index process in error in scheduled processes. This was scheduled by someone who is now a leaver, so may be the reason for the erro…Daniel.McDermott 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sample OTBI Report and Dashboard Workforce Compensation moduleSummary: Content (required): Hello experts, our customer want to see some delivered OTBI Analysis and Dashboards for workforce compensation module. I've tried to open th…Valerio Curzi 531 views 16 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Enumeration in FCCS reports and call up specific data from a single rowSummary: Enumeration in FCCS reports and call up specific data from a single row Content (required): Hello, I have two questions, with respect to the FCCS reports sectio…Anderson Florez 41 views 3 comments 0 points Most recent by Unknown Financial Consolidation and Close -
Vacant Positions in SQLSummary: Hi I have had a request through to list vacancies per Position Code/per CC. But instead of having one row per vacant position, it needs to have as many rows as … -
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report? -
Connect Oracle cloud HCM to MS power BI reportSummary: Connect Oracle cloud HCM to MS power BI report Content (please ensure you mask any confidential information): Hi, Is it possible to connect Oracle HCM data sour…Bhavna-Civeo 71 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Where are calculated measures housed in the catalog for OTBI ?I've created measures for different reports (not sure which ones), but want to re-use them. Where can I locate them in the catalog? -
Is there a way to see the last time a report was ran?Summary: I have a large amount of report, and some are no longer being used. I would like to delete the old reports that are no longer being used. Before I can do this, … -
Aggregate all notifications from Oracle HCM Cloud into single daily email/ report.Hi all, We have a requirement in which we are looking for a way to a aggregate all notifications from Oracle HCM Cloud into a single daily email or a report, sort of lik…Ioannis Adamou 61 views 2 comments 2 points Most recent by Ioannis Adamou Reporting and Analytics for HCM -
Waterfall Chart overlapping issueSummary: Waterfall Chart overlapping issue Content (required): X Axis values are not displaying properly I tried to put the Setting on the Chart as Fit to Both. dragged … -
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des…Anil Pillaresetty 303 views 21 comments 1 point Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages?Summary: How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages based on logged user. Content (required): We have a Dashboard; i…Ravindr-Oracle 123 views 5 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
Learning Ad hoc Access Group Deleted From UI are showing Active in BIP tablesSummary: I am fetching all the learning items along with access and access group assigned to them. Once I created access using Access tab under Learner tab I am able to …Kamini Kaushik-Oracle 31 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Reporting on Uptake of Course across OrganisationSummary: Requirement to work out the uptake of a course and show in graph form Content (required): Hello We have a course that has been created that we expect managers t…Helen Thomas 11 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM -
Number of days an employee works in the departmentHi, In our setup, an employee can work in different departments. For this, I need a SQL query that returns information on how many hours an employee works in a departmen…Cansel Karasoy 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Pull email for Eligibility Last Updated By field for Performance Document Eligibility subject area?Summary: Field + subject area: Content (required): Hi All, We are using the following subject area to pull information: We are pulling in this field from the subject are…William_Johnson 11 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Is it possible to change time zone on CURRENT_DATE SQL filter?Summary We have noticed that when we use CURRENT_DATE as a filter, the data is pulled using UTC time as the current date. Has anyone else run into this issue?Content Hi … -
"Failing to execute" report errorSummary: I get a "Failed to execute report due to an unexpected failure from the data source." error when running a report I was able to run previously. The report conta… -
Ability to report on permissions/access granted for reporting.Summary: Has anyone managed to /know how to report on the permissions assigned to a report/folder in BIP? Content (required): Hello Has anyone managed to /know how to re…Helen Thomas 21 views 8 comments 0 points Most recent by Gayathri K M-Oracle Reporting and Analytics for HCM