Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Why Application Composer is not available for HCMSummary Why Application Composer is not available for HCMContent Why Application Composer is not available for HCM and it is only available for Sales
-
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…
-
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…
-
Busting OTBI Myths - Using different security in OTBI to HCM CloudContent Myth: OTBI doesn't allow me to access different data to HCM Cloud Occasionally you need to allow a user to report on more or less data than they have access to i…
-
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…
-
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…
-
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…
-
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…
-
date presentation variableSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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. …
-
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…
-
-
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…
-
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…
-
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 …
-
Active Qualifying Scheme Name showing id rather than name in Payroll - Calculation cards Real TimeContent We have been starting to build a report using Payroll - Calculation cards Real Time looking at the pension auto enrollment card, however when we bring in the fie…
-
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…
-
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…
-
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 …
-
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 …
-
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…
-
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…
-
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 …
-
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, Nivya