Global HR
Discussion List
-
In OTBI, how to set the filters to fetch data between the last 5 years to the current year?I'd like to create an analysis to fetch employees hired from the last 5 years up to this year based on "Worker"."Enterprise Hire Date". How to set the filters within the…Welsey 121 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Table name/Report for Structure (Navigation Configuration)Summary : We require a report or table name that contains the configuration for the 'Navigation Structure.' This information will be necessary to ensure consistency in t…Bhupesh 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 31 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Position Costing with Incumbent ReportSummary: Does anyone have a report that includes both Position costing, with position number, and the position incumbent. We don't have the skills on the team to build a…Jenna Savage 154 views 9 comments 0 points Most recent by Jenna Savage Reporting and Analytics for HCM -
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. SowmyaSowmyaSk18 183 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to add threading database item to existing root data group?I have an extract with performance issue and the suggested resolution is to add a threading database item. Bit I could not find an edit button to modify the root data gr…
-
Report display incorrect in dashboardSummary Report output on dashboard shows fewer rows of data than expectedContent I'm having some irregularities when trying to run an OTBI Analysis embedded in a dashboa…E McDonald 54 views 9 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to hide unnecessary buttons from OTBI Dashboard?Summary Is it possible to hide unnecessary buttons from OTBI Dashboard?Content I designed an OTBI dashboard, which when I run shows OTBI Header buttons and search option…Dharmendra Shukla 79 views 10 comments 2 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Usability report by user across modules or applicationsHello Please, Is there a Dashboard or Report that can be run/access that can show the Usage Statistics per User across modules or applications that they have worked on. …Wale Odusanya 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Submitting Extract with Parameter Date for output file name not working as expected.Summary: Submitting Extract with Parameter + Date for output file name not working as expected. Please see attached for detail screenshots. It should have file name with…
-
Direct and indirect reports in dashboard promptHi There, We have designed a custom dashboard with is using the subject area Workforce Management - Checklist Real Time. We have a requirement to display direct and indi…MadanMohan 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Token for Rejection NotificationSummary: Does anyone know where/how to find out the definition of a token? For example, we are trying to figure out what “${CEConfigurationSiteName}” means. Also I see t…Antonio Washington 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Burst Report By Managers and Email to Individual ManagersSummary Burst Report By Managers and Email to Individual ManagersContent Hello everyone, I have a requirement where I want to create a BI Publisher report that groups em…Daniel McMillian 477 views 9 comments 0 points Most recent by Karthick_Sathasivam Reporting and Analytics for HCM
-
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 72 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following …
-
How should I define all parameters as multiple selection in sql report?Parameters are defined in this way in the SQL report I prepared.In this way, I can make more than one selection in the location with the parameters.But for example, when…Cansel Karasoy 41 views 12 comments 0 points Most recent by Stephan Steup - ITUP Reporting and Analytics for HCM -
Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 111 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM -
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 41 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use…Osama Qamar 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
auditing for document of records viewwe have a requirement to get auditing report for who are viewing the document of records. we are trying to get it from OTBI but data is not coming from those columns. ca…Dara Nagasai 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
What UE is effective date for marital change, gender change, name change located?Summary: We are not able to find Effective Date for the fields: Marital Status, Gender, Name changes or salary changes. We're able to find the field for these, just not … -
Does an Agent(OTBI) continue to run even though the user who set it up is inactive?Summary: Is there any way to find out the agents created by a user(Inactive now) in "MY Folder"? Also does an Agent continue to run even though the user who set it up is…Sushant95-Oracle 11 views 2 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM
-
how to edit the resignation workflow notification approve pop upwe have a requirement to edit the pop up message box asked to enter comments when an approver clicks on Approve or Reject in Resignation workflow notifications In the be…Dara Nagasai 61 views 1 comment 0 points Most recent by Mihaela Cojocariu-Oracle Human Capital Management
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…Ayoub AFRASS 23 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…Prudence K 118 views 11 comments 0 points Most recent by Malla Pratibha Reporting and Analytics for HCM -
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…Mansur Khalil 138 views 7 comments 0 points Most recent by User_ZICBC Reporting and Analytics for HCM -
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S…