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
-
Enabling HCM seeded Infolets in R11Summary We are in R11 and trying to enable Infolets by creating a Sandbox > Structures > Set system options and enable InfoletsContent We are in R11 and trying to enable… -
Passing values from the UI to parameters in a BI Publisher reportSummary Looking for a method of passing values shown in the UI to parameters in a BI Publisher reportContent I have a requirement to filter a BI Publisher report based o… -
How to make hyper link in one of the column values in BIP reportSummary: I have to establish link between MEANING Column values to the respective bip report . Thanks For Your Help!! Ravindra
-
Has anyone successfully implemented secure list views? Do you recommend them?Summary: I’m eager to learn of other users' experience in implementing Secure List Views, particularly from anyone who has implemented them to any significant scale. The… -
How to improve the performance of OTBI dashboards and reportContent Hi, We have created a custom dashboard. And few reports are taking long time to respond. Can someone tell me how can I improve the performance of Dashboards and … -
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; … -
BIP| How to link two data sets/source using outer join.Content Hi, I am working in a report where I have two different data sets A and B . There is a column which is common in both the data sets. I can link both sets using t… -
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so… -
showing data based on the selected candidate in analysis added to offer screenSummary: We have analysis added to offer screen and we want to get data based on selected candidate so we need binding variable to take candidate number from the screen …
-
Retrieve payroll elements amount increasesSummary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve the payroll element amount increases? For salary basis,… -
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't… -
Create an OTBI analysis based on Personal Details Quick actionSummary: We have created a new DFF field in Biographical info tab in the Personal Details Quick action page. Content (please ensure you mask any confidential information…
-
Do we have option to have multiple sheet in OTBI extractSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Offer ID not showing up on Recruiting Real Time Subject AreaSummary: Offers created under a requisition, but Offer IDs not showing up on the backend Recruiting Real Time subject area. Content (required): For a particular requisit…User_2025-07-18-13-29-11-469 63 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
We have OnBoarding_15Days_Report but timeout error coming on below querySummary: Hi Team, we have OnBoarding_15Days_Report its runing ok but few days onwords we getting error is timed out error, we apply one year durationand even schedule al… -
Fetching column for employee Feedback(in PD) whether it is completed/bypassed in OTBI reportsSummary: I have a requirement to add one column in OTBI report to fetch the status of employee feedback if is completed or bypassed. Can we use SQL query to fetch the de…
-
Reporting on Eligible for Pretax Age Catch-Up Contributions FieldSummary: Looking to include the column Eligible for Pretax Age Catch-Up Contributions in a payroll report to pull all data assigned to a person's Reporting Information c… -
MAX functions for payroll element effective start dateSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the most recent effective start date for a payroll element loade…
-
In Salary report one employee showing two records, difference is one is old salary second new salarySummary: HI Team, In Salary report one employee showing two records, only difference is one is old salary and second one new salary , how can we get latest record (New s…
-
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai…
-
Org levels missing from the OTBI report for the inactive treeWe recently did our restructures and created a new version of the tree. The old version end on 2-Jul and the new version starts from the 3-Jul. Now the Org tree has leve… -
Oracle BI Tables to retrieve last payroll element entries amount and last dateSummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables collect data related to payroll element entry last amount and last…
-
Goal Details BI Report including Employee Submission Status and Manager Approval Status fields.Hi Team, I have the requirement to create a BI report for the Goals details of the employees including the Employee submission status and Manager approval status fields.…
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe… -
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform…
-
How post a copy of the burst output to the UCM/content server so a web service can get the fileSummary: We have a burst report which goes to workers when they terminate that we would like to archive to our doc management system. In order to do so we need to post a… -
Issue with Logical SQLSummary: Hi, I was working with a Report which will provide various employee emails like home email and business email addresses along with few other assignment details.… -
How to customize BICC to control data that can be accessed by BI teamSummary: Hi All, We plan to use BICC for pulling data out of HCM but our HR team is concerned on the data access front. We feel like the BI team will have access to sens…
-
Enhanced Analysis with parameters changesSummary: Created a Reports and Analytics Analysis which others users can run. Then I made modifications to the Analysis, saved it and now the others can still only run t…
-
HCM Subject Area QueryHello Experts, Just need a quick suggestion from you - We have a requirement from business where we have to create a custom roles for Auditor - I have created a custom d…