Category 81
Discussion List
-
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 17 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 200 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 10 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 489 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 12 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 211 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Chetana Pawar 22 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 21 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 12 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 25 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 86 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 268 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 22 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 33 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
BI Report Catalog window (Data Model ) to be made Read OnlySummary: Please refer attachement. I need to make the BIP reports query read only in BIP Content (please ensure you mask any confidential information): Version (include …Preeti Khondre 12 views 2 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, NivyaNivya Mathire 41 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Add new entity using Manage Attachment entitiesIs it possible to add a new entity using 'Manage Attachment entities' task and make the attachments available for one of the standard Objects? I tried adding for one the…SatyendraSingh Dangi-Oracle 42 views 3 comments 0 points Most recent by SatyendraSingh Dangi-Oracle Reporting and Analytics for HCM
-
Tables with employee cost center, manager, assignment, and job title historySummary: We need to write a query to report on employee cost center, manager, assignment, and job title history. So far we're not finding the data we need in the tables …nmdp-andrew 518 views 3 comments 2 points Most recent by nmdp-andrew Reporting and Analytics for HCM