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
-
Looking for a YTD payroll reportSummary: I need to create a report showing YTD payroll. Content (required): Report needs to contain employee demographic detail along with current pay rate, YTD earnings… -
Which Subject Area to use for Assignment EITSummary: Which Subject Area to use for Assignment EIT Content (required): I cannot see any subject area field showing "Assignment EIT Information EFF: Assignment Extra I…
-
Simple sample report: persons processed during a payroll flowSummary: This BI report lists person number and person name for payroll flows in which person records would have been processed. We had a requirement to be able to dump …
-
Error in SQL created by SQL AssemblerSummary: I get the following error Error generating view. Error getting cursor in GenerateHead in a SQL statement created by SQL Assembler Content (required): I get the … -
Hyperlinking BI Publisher reports in a DashboardContent Hello, We have a requirement to create a dashboard which will list all the reports available for certain user popluation. As per screenshot you can see that we m… -
Rtf template special character errorSummary: Content (required): Hello everybody, I was having a problem concerning the extraction of certain data to insert in an rtf template in word. In particular, extra…
-
Employee Commute DistanceSummary: We need a way to calculate and report on Employee Commute distance to support our Environmental, Social and Governance reporting. In our legacy data warehouse w… -
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…
-
How to format the date field from time dimensionSummary: How to format the date field from time dimension Content (required): I have column Calendar Month from Time dimension it is showing the output as 2022101.0 for … -
OTBI Date promptContent I have noticed that when I have multiple date prompts (based on 2 column values) it is using 'AND' condition as the default behavior. How can we change it to 'OR…
-
12 Month Trailing Trend Chart of AttritionSummary: We're looking for this specific report. Content (required): Unsure of whether there are metrics accessible via OTBI that could be used to create this report Ver…
-
Can't see 'Administration' Tab in Catalog?Summary: Content (required): Can't see 'Administration' Tab in Catalog after the last update? any feedback? note: the user has all related (HR Analyst, Admin Roles, and …
-
Positions Filled in less than # daysSummary: Need to track positions filled that took less than/more than 60 days to fill. Content (required): I need to find a way to not only track the # of positions fill…
-
BI Publisher report formattingSummary: I have a BIP report that I need to export (to FTP eventually) to CSV format but I cannot get the formatting to stay. Content (required): The BIP report needs to…
-
NI thresholds - How to report in OTBISummary: Please can someone confirm if it is possible to report on NI thresholds using OTBI. Alternatively, which table in BIP can we derive the NI thresholds from Conte…
-
Attrition analysis/ dashboardSummary: Hello, I am looking for the valid attrition analysis that will calculate attrition on FTE employees, and perform by time periods, like month or quarter. Thank y… -
Error When open Dashboard by a certain user!Summary: Content (required): I received this error when opening a custom dashboard, noting that the user has access to the report and its Subject Areas The report can be…
-
Locate Job Requisition Submissions Questionnaire ResponsesSummary: Hi all, I am attempting to write a BI report that will show an applicants response to a specific question asked during the job application submission. Can you p… -
Analysis Female Successors for Critical RolesSummary: I am trying to work out #critical roles: used distinct (Plan Business Unit)- Correctly getting the count #atleast 1 female successor on these critical roles # c…
-
Identifying/Removing Duplicate rowsSummary: I am creating a report that is trying to highlight any blanks or erroneous data in our active workforce. It requires combining the following subject areas: Work…
-
How to display different email address types in separate columnsSummary: We have a requirement to display separate columns for work email address and home email address, one row of data per employee. Content (required): From reading … -
How can I query uploaded learning content?Summary: Is there an easy way in BIP to query learning content title and file name? In my particular case they have been batch uploaded via REST API, but I don't think t…
-
Ask for table name - who answered the questionnaire, the questions and answersSummary: Ask for table name - who answered the questionnaire, the questions and answers Content (required): Table name for Questionnaire related have found the following… -
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…
-
ORA-01841: (full) year must be between -4713 and +9999, and not be 0Summary: Encountering an error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 when trying to pull a value from the element's input value. Data type…
-
Number of Candidate Pool Members metric doesn't match with the value showed in UISummary: Content (required): Hello, We would create a simple analysis that extract the Number of Candidate Pool Members inside the different pools. We create the analysi… -
How to report on initial absence start date while maintaining current absence start/end date columnsSummary: Hi All, I have a requirement to report on the initial start date of consecutive absences, while also showing the start date and end date of the current absence.…User_2025-02-11-06-38-03-841 25 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Table name for retrieving representative information assigned to an employee based on AORSummary: I need to write a BI publisher report where I need to fetch the representatives assigned to an employee based on AOR as shown in the screenshot below .Here we c…
-
BI Publisher Desktop for BIP 11.1.1.9.0 not working with MS Office-365 & WIN-10Summary: Hello Experts, Can you please guide me if you have faced the similar issue while installing BI Publisher Desktop for BIP 11.1.1.9.0 which not working with MS Of… -
How Time Dimension works?Summary Report with snapshots by end of monthsContent Hi Everyone, I am struggling to build an OTBI analysis that creates a monthly Head Count report. I am using "Workfo…