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
-
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, https://us.v-cdn.net/6…
-
We have long service award OTBI Report but need to show in performance tile viewThere was an error rendering this rich post. -
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 …
-
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…
-
How to pull only one field for Person Legislative Information > CountrySummary: I am attempting to pull an employee file that includes which country an employee lives in. I am using the subject area "Workforce Management - Person Real Time"…
-
Repeating RowsSummary: I am creating a report that will show job requisitions, the candidates who applied along with their education and previous employment information. Due to multip… -
SQL with statement window function errorHello! I am trying to run a window function to rank the rows in order to remove any duplicates (code below). I am getting the error "ORA-00923: FROM keyword not found wh…
-
We have OTBI report but need to convert to Dasboard how can I develop ?Summary: Hi Team, We have OTBI report but need to convert to Dasboard how can I develop . Any one help me on I'm new to dashboards ? Thanks, Ajay Content (please ensure …
-
for-each OTBIHello everyone, I have the following problem: I have a report that is grouped by several groups and subgroups. I need to be able to total the columns for each subgroup a…