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
-
Workforce Performance - Performance Task Status Real Time showing incorrect assignment informationSummary: The Workforce Performance - Performance Task Status Real Time subject area seems to be displaying incorrect assignment information for employees that have had t… -
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…
-
query to identify the processed and unprocessed payroll transactions for BI reportsVersion (include the version you are using, if applicable): for version "Oracle Fusion Cloud Applications24A (11.13.24.01.0)".
-
REQUISITION_POSTED State Code Giving Strange ResultsHello, I have a need to find the most recent date a requisition was posted and unposted. For compliance purposes, we need to ensure our jobs are being posted for a minim… -
How to edit and disable delivery option of Oracle HCM Fusion HCM Extract in 24BWe would like to disable the delivery option of HCM Extract and edit one of the Data group filter in 24B. As we do not have Advance edit option enable. -
How to see from front end or fetch data through query for schedule information of hcm extractSummary: How can we see from front end or fetch data through query for schedule information of hcm extract like the schedule date, frequency etc.
-
Migration of Fast Formula, Lookup, UDT in bulk from one instance to another.I am migrating Fast Formula, Lookups, UDTS from one instance to another in bulk, what we need to select under deployment method while creating task, please suggest?
-
SQL query for linking between life event and benefits plansSummary: Need sql query or back end table for the linking of add life event(BEN_LER_F) and benefits plans(BEN_PL_F) Content (please ensure you mask any confidential info…
-
Oracle Recruiting Internal and External Selected Canidates - OTBI ReportSummary: We have requirement to show selected internal and external candidates in an OTBI report. Please advise. Please provide a sample report. Content (please ensure y…
-
-
Identify Hire Dates that are any date in the Next WeekSummary: I have an OTBI report using subject area Workforce Management - Work Relationship Real Time. On the Advanced tab, I have already entered the prefix SET VARIABLE…
-
Moved: OTBI Dashboard - Integrate BIP Report and Date Dashboard PromptThis discussion has been moved. -
No Results custom message not updatedSummary: No Results custom message not updated. Design Sample: Parameter selected: Absence Type parameter selected = Purchase Day. No Results message expected to be prin…
-
Add New Pay Rate and Old Pay Rate to existing reportSummary: I've been working on making an adjustment to a report (linked below) to add columns for current pay rate and old pay rate. Right now, the sql in the report is r…
-
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name … -
INFORMATION_TYPE is not unique IN PER_JOB_EXTRA_INFO_F table for same job title.Summary: Integration is failing due to sql not returning data for INFORMATION_TYPE ='EIT'. In BIP report INFORMATION_TYPE is coded 'BMC Grade Details' How the INFORMATIO…
-
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not working for Recruiting - Recruiting RealtimeSummary: For my OTBI analysis, I applied the prefix mentioned in the documentation for the Recruiting - Recruiting Real Time subject area https://docs.oracle.com/en/clou… -
Unable to view job history of custom reports in Oracle FusionSummary: I have BI Author, BI Consumber, and BI Administrator Roles assigned to my profile. I'm trying to view Report Job History for a Customized version of the Receipt… -
Query to get department from PAY_COSTS tableSummary: Need to link the department to the PAY_COSTS table. How can I link the department (organization_id) to the PAY_COSTS table through other tables? Content (please…
-
When pulling fields from two subject areas, it often breaks and returns 0 resultsSummary: When trying to create an Analysis from two subject areas it doesn't work. Example: Workforce Management - Person Real Time I have the following fields: Address …
-
OTBI delimit data from 1 column into multiple columnsSummary: We have a report requirement where we want to delimit output from 1 column into multiple columns based on '/' delimiter Content (please ensure you mask any conf… -
Cross Subject Area join between Checklist and Helpdesk Request SummarySummary: There are Checklists created for certain Helpdesk Service requests. We need the data from both checklist and helpdesk on an OTBI Analysis **** Dashboard. Is it …
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th… -
Add custom logo in a Workflow NotificationHi, I customize the RTF of CmpWkstApproval Notification. I add an image in the RTF, the image is visible when i run the report but the image is not visible when the noti…
-
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…
-
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve… -
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, I got to know that its…
-
We have long service award OTBI Report but need to show in performance tile viewSummary: Hi team, we have long service award OTBI Report but need to show in performance tile view chart by if we click the 5 years then need to show 5 years completed c… -
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
Logic to calcuate LOP days including the public holidays and weeklyoffsHi , I able to find of the absent days of employee for a month. Now i need help in deriving the logic to include weekly off and holiday if these days falls in between 2 …