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
-
Drill Down OTBI bar chart report is not working correctly using several columnsSummary: We have a master report which has the following columns: -Positioning Before, Grade Code, Gender, Number of eligible employees. I used a stacked vertical bar ch… -
The most data that we can get about an OTBI Agent that was shotSummary: Content (required): Hi there, i see that there are a few posts about getting detailed data about if OTBI agent shot successfully and getting more details. I saw… -
we ae getting multipule dublicate records in BI report with out any changeSummary: HI Team, we have absence reports but in recent we observed multiple dublicae records for each employee how can we sorted out this issue ? example: one employee … -
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin… -
Prompt for Assigned on Date and Completion Date are not filtered based on the security of user (OLC)Dears, I've created a prompt with two filters: YEAR(Learning Record Details.Assigned on Date) YEAR(Learning Record Details.Completion Date) I don't understand the reason… -
Need help with SQL query (OBIEE Dataset)Summary Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)Content Hi All, I am trying to build a report … -
How to disable user login whenever the user is deactivatedSummary: Content (required): Hi All, The requirement that when users leave the company and when email get deactivate in the company, then fusion application login also s…
-
Load the data into the custom content sectionSummary: Content (required): Hi Expert, We have created a custom content section ABC and there are some fields where we want to load the values in it. Please suggest if … -
OTBI Row to Columns Conversion (FA HCM Rel 9.2)Summary Can we convert rows into columns in Fusion OTBIContent Hi Experts, Please have a look at attached word document and png file s and advise -
Restrict Schedule Option In ReportsSummary: Restrict Schedule Option In Reports Content (required): Hi All, We want to restrict the schedule option in reports for specific set of role. Is there a way to r… -
Customer Statement Report using OTBI.Summary: I want to modify existing OTBI report for Customer Statement Report for which I have to fetch Commitment cost as Expenses under Expenditure Category. For which …
-
A query to find person id,role name and associated security profile in Fusion HCMSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Narayanan Subramaniam-Oracle 2.1K views 1 comment 0 points Most recent by Narayanan Subramaniam-Oracle
-
Need to fetch a report for assignment history and changed attributes ( OTBI Or OBIEE ).Need to get Assignment history , changed attributes and action code in assignment page. I need to show the values with Effective start date.Jebarsan Thangam John Durai Raj 715 views 1 comment 0 points Most recent by Julian Challenger-Oracle
-
Drill Down OTBI is not working correctly using Custom Column.Subject Area: Compensation - Workforce Compensation Real Time I have created a simple OTBI report Positioning with 2 columns: Grade Code Custom Segment7 (Which I renamed…
-
How to obtain the data in the report or table of the users who log in to the HCM Fusion CloudSummary: How to obtain the data in the report or table of the users who log in to the HCM Fusion Cloud Content (required): Hello, how are you friends from Oracle, I want…
-
Access to restricted data in BI reportSummary: We have a BIP report in /Custom/Human Capital Management/Reports, which is used by certain users. On May 31st one user reported that he/she is able to view data…
-
How do add export option to Dashboard UI reportContent Hi, I cannot find a way to make the option export in the UI dashboard available. of course through OBIEE this option is available, but after adding the report to… -
Getting Absence Reason in BIPSummary: I need to get the absence reason for a large number of absence in a BIP report. However, when trying to link the Absence Entry Reason ID to the Reason ID using …
-
How can I get only the latest results when reporting on the status of a certain training?Summary: I try to report on the status of a certain required learning to see who has not completed it yet. If the learning was deployed this year, but also the year befo…
-
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…
-
While running whole population in OTBI we are facing issue.Summary: Content (required): we are using Pivot table output in the OTBI report for 1 or 2 employee it's working fine when we are running whole population, we are gettin…
-
Unable to see the Goal Status for Goal plan reportSummary: Unable to see the Goal Status for the Goal Plan OTBI report Content (required): Employee has submitted the goals for approval, but the same is not reflecting in…
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca… -
How to report date/time stamp when a Candidate Label was added.Summary: Content (required): is there a way to report the date/time stamp when a label was added to recruiting>candidate>candidate - labels> label Name ? I see there is … -
Report to get the duplicate element entries in a given pay periodSummary: Report to get the duplicate element entries in a given pay period Content (required): Hi Team, Greetings! Is there an existing report to get the duplicate eleme…
-
Alerts Composer - Has anybody worked on creating custom Alerts in HCM using Alerts Composer ? We havSummary Alerts Composer - Has anybody worked on creating custom Alerts in HCM using Alerts Composer ? We have requirements to create custom alerts instead of OTBI notifi…
-
Mass Update messagesSummary: Content (required): What table stores the messages from Mass Update transactions? Version (include the version you are using, if applicable): Code Snippet (add …
-
Hide "Create Bookmark Link" LinkSummary: Dears we are trying to hide the link highlighted in screenshot attached but we dont understand how. OTBI is available to users within a dashboard, we already ch…
-
Using OTBI to fetch latest ACTIVE assignmentWe would like to use a filter which we can re-use to fetch the latest active assignment for a person. For 99% of our population, it works to do MAX("Worker"."Assignment … -
Invalid Number Error in fetching Basic Salary ComponentSummary: We are writing an oracle sql query to fetch different components in the salary for inactive employees. But it keeps showing below error on runtime. ORA-01722: i…