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
-
Hiding Output TAB in Schedule Page of ReportSummary: Hiding Output TAB in Schedule Page of Report Content (required): Can we hide via Personalization or Role Duties and Privileges restriction hide the Output TAB i… -
Need to schedule a BI Publisher report to run on interval of 15 daysSummary: Need to schedule a BI Publisher report to run on interval of 15 days. Content (required): Version (include the version you are using, if applicable): Code Snipp… -
Include/Exclude column based on the ParameterSummary: We have requirement to Include/Exclude the column based on the parameter Content (required): We have a requirement to hide a column in the report output based o… -
Population Counts - Year over YearSummary: I am looking to create an analysis, which will be connected to a dashboard, to report population counts year over year. I have included an example below: August…
-
Only issue with one person number of the querySummary: HI Team, for below working fine but coming to one person number not getting the data. below error coming error:Data_das Could u please assist on this.@Mandeep G… -
Need to get the latest Salary fromSummary: I need to get the latest salary for all employees who have left. Content (required): I am using the Compensation - Salary History Details Real Time subject area…
-
Age calculation on As-Of-DateSummary We need to build a report which shows the age of Worker on As-Of-DateContent We need to build a report with As-Of-Date variable so that it would also calculate t…
-
Table Prompts Repeating ValuesSummary: Pivot table and data table are linked with a channel so the table will update depending on where in the pivot table the user clicks. However the table prompts a…
-
How to fetch the contract end date of a future contract extension using OTBI?Summary: Hi All, We have a requirement to fetch the Contract End Dates of contract extensions that have a start date in the future. OTBI only seems to fetch the Contract… -
How to get multiple value from table in Array format in Oracle BISummary: How can get Multiple value for the same data in Array format in one single row Content (required): Get the value in Array format in oracle need sql query Versio…
-
How to change date format in 30-06-2022 to 30-June-2022Summary: Hi Team, we have developed date as of now 30-06-2022 but business wants this format 30-June-2022. to_char(CURRENT_DATE,'DD-MM-YYYY'), -- 30-06-2022 May I know t…
-
Scheduling Dashboard with BIP ReportSummary: Content (required): I am trying to schedule a dashboard which contains a tab with a BIP Report. When I schedule or export the dashboard, all other tabs (that co…
-
Filter to pull employees with anniversaries in the following monthSummary We need to build a report that is emailed monthly and pulls any employees that have service anniversaries in the following monthContent We need to create a repor… -
Unable to fetch the data for Calculation card in HCM Payroll Employee Deduction BI reportSummary: Hi all I am not able to get these data from the backend for Element Name, Value, Effective Start date inside the Calculation Card : Benefit and Pension in HCM. … -
How do I create an analysis that pulls most of the fields on the Element summary screen?Summary: When creating an analysis, the analysis either drops records or stops returning any records after adding certain fields that may not contain any data. I am curr… -
How to create a report for worker and theirs Individual CompensationSummary: Im trying to create a report to follow individual compensations for workers, but using the subject area i couldnt create any report, when combine the worker fou… -
Saved/Draft Rating Manager evaluationIs it possible to report on manager evaluation(saved) without employee submitting the rating? I am trying to create a report to pull manager evaluation with any status. …
-
Need to remove one measure column's grand total value in OTBISummary Need to remove one measure column's grand total value in OTBIContent We have Grand total value for two measure columns in OTBI Report. We need grand total value …
-
Report to show where Referral payment due on completion of Probation periodSummary: We are trying to build a report which alerts us to employees who have now reached the end of their probation period and were referred by an employee during recr…
-
Adding additional information from add absence pageWe added a few input boxes on the add absence page, how can we see them in OTBI? Do we really need to develop custom BIP models for things this simple?
-
How do take End of the Month Prompt in OTBI?I am trying to fetching the count of Legal employers , total cost based on the categories and required prompt is end of the month as per selection should come count of L…
-
Request for a report on employee utilization of Oracle HCMSummary: I am looking to understand how the system is being used by the employees in my company. Content (required): I would like to be able to report on who is using th…
-
how to find the dff in headcount otbi reportSummary: I am unable to find the DFF called 'Worker's Comp Code' under the subject area Workforce Management:- Worker Assignment Real-time So , Can anyone help me how to…
-
Duplicate Data Issue : HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVOSummary: We have enabled BICC extract for HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVO for default column list, the extract data file has duplicate… -
Table/Views required which contains all the created data model ,report/analysis in the instanceSummary: Hi, I need table/view name which contains all the data model, report, analysis information created in the system and all the fields which are being used by that… -
Unable to get DFF and EFF fields in OTBI in Worker AssignmentSummary: Content (required): We are unable to get the following fields highlighted below in OTBI Subject Area "Workforce Management - Worker Assignment Event Real Time":…
-
Unable to get inactive or future dated employees in OTBISummary: Content (required): We are using the subject area "Workforce Management - Worker Assignment Event Real Time" and we are unable to get inactive or future dated e…
-
Duplicate Data Issue : HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.RptAbsTimeEntryPVOSummary: We have enabled BICC extract for HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.RptAbsTimeEntryPVO for default column list, the extract data file has duplicate d…
-
we have requirement of how extract person history detailsSummary: Hi Team, we need to create the report on history details of person like surname before marriage and after marriage , etc of person history details Content (requ…
-
How to report the completion date for Journey questionnaires and or tasks?Summary: Is there a way to report on the specific completion date for when a journey questionnaire or general task is completed? Right now, I have noticed a completion d…