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
-
Help with "Guide me" ReportSummary: Hello, I am building a report that fetches information about Grade Ladder, Grade Name, Step Name, and Value. The query itself is not an issue. However, I need t… -
How i can improve the running time for one report?Summary: Misdated Payroll Relationship timming out I used this formula: CASE WHEN "Payroll Assignment"."First Standard Earning Date" = MIN("Worker Payroll"."Payroll Star… -
Table which stores the goal commentHi Team, I am working on BIP report to get the Goal details, I am using below tables for the report. HRG_GOALS HG HRG_GOAL_PLAN_GOALS HGPG HRG_GOAL_PLANS_VL HGPL HRT_REV…
-
How to Include the Weekends and Public Holidays in the OTBI dashboardSummary: How to Include the Weekends and Public Holidays in the OTBI dashboard to the below code snippet. Content (please ensure you mask any confidential information): …
-
How to add custom paramter based on other custom parameter in Dashboard PromptHi Team, I need to create custom parameter with formula based on the value from the other custom parameter with formula. Category and Sub cateogry - both are from same f…
-
BI SFTP connection no longer working due to Key Exchange Algorithm DeprecationSummary: One of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1 SSH Kexs on the target serve…
-
Performance Manager Not Appearing in AnalysisSummary: We are trying to create a report for our Performance Reviews that is able to show us an individuals Performance Review Status, Score, and other details. As part… -
Issue with employee's line manager compensation plan approval status SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query by filtering for an employee for testing purposes: se… -
BI table to retrieve Approval Status field in Workforce Compensation moduleSummary: Content (please ensure you mask any confidential information): Hello expert, do you know in which Compensation BI table is stored the highlighted value? Thanks …
-
SQL query to retrieve compensation plan status at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, I need to track for all employees the status of their line managers compensation p…
-
How to display the filters in a BI Report, in multiple rowsSummary: How to display the filters in a BI Report, in multiple rows Content (please ensure you mask any confidential information): Hi, we built a BI Report, entering se…
-
Recruiting Real Time: Application Questionnaire reports take several minutes to generateSummary: When trying to run a basic query from RRT Application Questionnaire, it takes several minutes to run the query. Does anyone have ideas on how to improve reporti… -
Dashboard prompt for effective date reporting possible?Summary: Hi all, I have added SET VARIABLE PARAM_EFFECTIVE_DATE = '@{P_DATE}{@{system.currentTime}[YYYY-MM-DD]}'; into the advanced tab under prefix for a OTBI analysis …
-
requires work schedule table which has effective from date as columnHi Team, We want to use work schedule effective start date to differentiate which day will be week off and working day of the employee in the report. Please suggest the …
-
How to trigger notifications to the Mobile Numbers instead of Email IdSummary: Hi Team, We know that the notifications will be triggered to Email IDs through bursting and the customer asks to trigger the notifications to the employee's mob…
-
Access run history & older report outputs of OTBI scheduled reportsHi! We have end users who sometimes request previous run versions of scheduled reports. Wondering if there is a way to access run history along with report data output o… -
Can I make an Academic Year 'Time' dimension in OTBI?Asking for a colleague Hi all, I need to show workforce trends over time by Academic Year e.g. 2023/24 = 1 September 2023-31 August 2024. I have successfully made time s… -
Performance Task Status Report: Getting two records per employeeHi Folks, We have requirement to fetch current document status of an employee , we are using Performance Document Task Real Time subject area, but still we are getting t…
-
Issue on value set retrieving custom field in person profileSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom value set retrieving a custom attribute in person profile. At …
-
How to schedule an agent to run only if new / upcoming terminations are enteredSummary: Hello, I'm working on a push report for our security operations team who wants to be notified of upcoming terminations entered into the system. Unsure how to pr…
-
bip query is very slowSummary: I have written a BIP query which runs fast in SQL Connect using one bind variable. When placing the query into a BIP report there are no issues but the query so…
-
Created a learning incident OTBI report but its keep on processingSummary: Hi All, I created a simple report to find out who has reported a learning incident but the report keeps on running and never giving results. Is there anything I… -
Importing Oracle JET Visualizations in OTBIWe have an ask from the Customer if we can import Oracle JET Visualizations in OTBI https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=home&demo… -
How to filter the employees basing on their Grade in a BIP ReportSummary: How to filter the employees basing on their Grade in a BIP Report Content (please ensure you mask any confidential information): Hi, we created a BI Report. Amo…
-
Cannot retrieve Manager IDSummary: Content (please ensure you mask any confidential information): Hello experts, I've created the attached value sets retrieving the employee Manager ID. If I laun…
-
Help on manager hierarchy fast formulaSummary: Content (please ensure you mask any confidential information): Hello experts, I need to replicate the line manager hierarchy in compensation plan. However, we s…
-
Query retrieving manager job nameSummary: Content (please ensure you mask any confidential information): Hello experts, how can I retrieve the line manager job name? I've used the following query but th…
-
Query to retrieve employee Job nameSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample SQL query retrieving the employee Job name visible in the ass…
-
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…
-
Unable to see all privileges in Security - Roles and Privileges Real Time SAWhen I am trying to fetch roles & their respective privileges from subject area(Security - Roles and Privileges Real Time). It is not fetching all the privileges. Can so…