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
-
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 … -
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g… -
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 1.8K 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 507 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…
-
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
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…
-
Can we hide a specific sheet in the excel output for some users?Content (required): We have an excel report which contains 2 tabs where 1st sheet contains the data dump and 2nd sheet is the actual report which is based on the 1st she… -
Total Actual Effort in Learning by DepartmentSummary: I am trying to write an OTBI analysis where we are able to pull in the total headcount of a department, the total actual effort hours of learning for that depar…
-
OTBI - How to get all workers who are hired, and transferred to the target department in 30 days?Summary: OTBI - How to get all workers who are hired, and transferred to the target department in 30 days? Content (required): Hi experts, Could you point me in the righ… -
Hiding Out of The Box Reports - (Human Capital Management)Is it at all possible to hide the folder that contains the out of the box reports (Human Capital Management)? I can see we can remove the 'BI Consumer Role' from our rep…
-
OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbentsSummary: OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbents Content (required): Hello, I'm building a data quality dashboard and would like to ask …