Category 81
Discussion List
-
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha… -
Which column in OTBI will display if employee is also a manager, We need this in Learning ManagementWhich coloumn in OTBI will display if employee is also a manager, We need this in Learning Managment OTBI reportsabhilashanand 11 views 3 comments 0 points Most recent by abhilashanand Reporting and Analytics for HCM
-
How to know from front end which field is available in which back end table in oracle fusion cloudSummary: Creating a Report on Apprenticeship. Content (please ensure you mask any confidential information): Need to find data in the Oracle tables for Apprenticeship. H…Pradnya_Pampatwar 482 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
how to get Expected date of joining in orc from which tableIn orc how to get Expected date of joining of candidates.Vinay Prasad 82 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
How do I convert salaries currency to euro in BI Publisher report?Summary: How do I convert salaries currency to euro in BI Publisher report? Content (required): Hello, My client requires that the salaries in a custom BI Publisher repo…Alice Gouzy 15 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Documentation on Scheduling OTBI ReportsSummary: Hi! My company is currently implementing Oracle HCM. Is there an oracle manual/guide which goes over all aspects (tabs) of scheduling reports through OTBI sched…Ameya_J 187 views 1 comment 0 points Most recent by John Hung-Oracle Reporting and Analytics for HCM -
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to put filter on Phone Line Type and also include employees without the type in OTBI?Summary: Hi All, I am fetching employee's data through OTBI where I also want to fetch the employee's Home Mobile Phone data only. After I apply the filter to Phone Line…Robinson Ng 31 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is there a way to pull Executive Manager Name on a Terminated employee record?Summary: Trying to run a report by our executive manager's to see how much turnover each manager has had. Appears that Manager details are dropped from an employees reco…CGardner01 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Average Salary per HourSummary: We have an OTBI analysis with each department headcount and I need to get the average salary rate per hour in another column. Content (please ensure you mask an…Ayesha Iroshani 9 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Analysis multiplying fields ‘FTE & Salary’ – How to resolve?Summary: I am writing an analysis from three subject areas were multiple columns have expressions, when I add an expression which is including the Manager Flag from Work…Scott_Turner_ 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
change sql query timeoutSummary: Content (required): Hi team, we need to increase sql query timeout. We saw from some service requests (https://support.oracle.com/epmos/faces/DocumentDisplay?_a…Claudia Schiff 469 views 4 comments 0 points Most recent by Rebecca Hawker Reporting and Analytics for HCM -
Oracle Compatible Tamil FontSummary: I have a Letter development which need to compile with Tamil Font. For that I have using Using NirmalUI font and it works fine with word format and rtf format. …Dhajani Perera 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
How to get BIP Scheduled Report To Update 'As of Date' When RunSummary: Hello, I'm having issues with a BIP scheduled report not updating the 'As Of Date' prompt when it's scheduled to run/send to the user. I have the report schedul…
-
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_…
-
Human Capital Management - Transaction Administration Real Time - Assignee person is missingSummary: Hi, I am trying to create analysis to show all pending approval transactions using Human Capital Management - Transaction Administration Real Time, but I am una…Reem Ezzat 197 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Chetana Pawar 21 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
unpivot dataSummary: Move rows to columns Content (please ensure you mask any confidential information): I am looking to unpivot the data and move Input Value Name and Displayed Inp…Julia Kiszelewska1234 24 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manage Legal Reporting Unit Registrations ReportSummary: Manage Legal Reporting Unit Registrations Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I se…Parag Hiremath 1 view 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Columns as stagesSummary: im trying to find a way if possible to wrap a whole column in an arrow pointing right. I have multiple stages and want to flow from stage1 to stage5. The two wa…
-
Manage Legal Reporting Unit HCM Information ReportSummary: Manage Legal Reporting Unit HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I …Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Medical Examination Data OTBI report display problemHello, With a specific role created role of Medical examination I have a problem displaying the report while connecting as a nurse in my organization. At first there was… -
OTBI Analyses not showing Worker DataSummary: The User cannot see all fields in a report although all columns used are attributes from one Subject Area. The columns the user cannot see are Worker related co…Sa_De_Or 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
90 Day New Hire TurnoverSummary: Trying to properly capture 90 day new hire turnover. Looking back 90 days from the day the report is run (today). Content (please ensure you mask any confidenti…CGardner01 81 views 19 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Original Hire Date Changed for Pending Worker vs. EmployeeSummary: Our original hire date was historically based on the work relationship start date. However, after the implementation of ORC it is now the effective date of the …Chad Morris 252 views 7 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM -
Audit ReportSummary: We did enable the audit for the PER_PHONES table. This reports on future phone number change history. We included date prompts. I updated the phone of the user …Stela Martins-Oracle 21 views 2 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Finding Records with Trailing Space in OTBISummary: Finding records that have a trailing space in OTBI Content (required): We have file transfers that fail when a trailing space is on the end of Address Line 1. I…
-
Custom HCM Role AuditSummary: How to get Audit report for Custom HCM Role Content (please ensure you mask any confidential information): I want to know that who made changes to the data secu…ArunSolanki18 1 view 1 comment 0 points Most recent by John Thuringer-Oracle Reporting and Analytics for HCM
-
Hide Disable Actions Menu in BI Publisher Report or Hide Export and Schedule buttonSummary: I want to hide Action menu in BI Publisher Report or want to hide Export and Schedule button. Only need online view. Is there any way to do this ? Version (incl…
-
Analysis done using Security Roles and Privileges real time does not show all privilegesSummary: Created a custom OTBI analysis to get custom role inherited roles and privileges, compared against exports directly from Security Console. There are plenty of m…DiegoCastanon 31 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM