Reports
Discussion List
-
Sample OTBI Dashboards/Reports - RecruitingSummary: Content (required): Are there any recent shared sample packs of dashboards or reports related to ORC Recruiting? Version (include the version you are using, if …Toni Olivier 154 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hi there, I am unable to run a single report for a complete details of an employeeSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):_Sanjay_ 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T… -
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…ZenG 26 views 1 comment 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
when we using full name column, we are missing the middle name of employee any another column ?Summary: Hi Team, when we using full name column, we are missing the middle name of employee but when we try to using first name , middle name, last name but it is takin…AjayKumar Maddipati 32 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Active Profile QuerySummary: Looking for help on how to build a query that checks for active profiles within different environments Content (required): Hi all, I'm looking to see if anyone …
-
RTF Template spilt the output in different documentSummary RTF Template spilt the output in different documentContent Hi, I am using RTF Formating using Word Add-on(BI Publisher) We created a custom RTF temple that have …Awadhendra Tripathi 18 views 8 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Where is the rate field for hours worked?Summary: Content (required): I have a report that uses the subject area Payroll - Payroll Balances Real Time, but it does not have a pay rate field. Below is an example …
-
BI Dashboard filter causing score tiles to not showSummary: We have a dashboard built to summarize the scores of a questionnaire. When we filter, even though there is data, some of the tiles will randomly not show up. If…
-
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…C.R.Balaji 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…Abhimanyu Kumar27 21 views 2 comments 0 points Most recent by Abhimanyu Kumar27 Reporting and Analytics for HCM
-
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…Vasanthakumar Ravi 117 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
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…AjayKumar Maddipati 51 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
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…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
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…Riti Malhotra 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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… -
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. …
-
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…HROps17 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…AjayKumar Maddipati 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can hourly rates be reported on?Summary: Our workforce has both salaried and hourly associates and we have a requirement for an analysis to show hourly rates using the SA Compensation Salary Details Re…
-
BI publisher not working as expected after 22B upgradeSummary: We are facing issues with BI publisher delivery options after 22B upgrade Content (required): We are running BI publisher from Oracle SOA and delivery options a…
-
Query to Display the employee and the supervisor chain bottom upSummary: Does someone have a query for the employment and Supervisor/Manager hierarchy ? Content (required): Hello , I have very little experience in HCM tables, hence I…Cesar Saveedra 3K views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM
-
Analyzing Skills and Competencies asked on Job DescriptionsSummary: We are looking for a Reporting or a Tool to expedite the following request from our VP Talent. Content (required): Is there some way we can pull a bunch of job …Alvaro Couto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
May I know use of below to screen hots of archive and unarchive of reportsSummary: Hi Team, May I know use of below to screen hots of archive and unarchive of report catalogue. from archive we have two options that is Keep Permissions and Keep…AjayKumar Maddipati 32 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
when I open the PDF format output of Bi publisher report its not downloaded automaticallySummary: Hi Team, when I open the PDF format output of Bi publisher report its not downloaded automatically. any option to set the download the automatically when i open…AjayKumar Maddipati 75 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Job Agent Sending to Removed RecipientSummary: Job Agent Sending to Removed Recipient Content (required): I had an OTBI report job agent and needed to change the recipient list, however, after saving the new…
-
Narrow Chart Down to Top 10Summary: We are trying to create a bar graph of the top 10 jobs that termed for the year. Is there a way to only show the top 10 rather than all the jobs?Rebekah Gilday 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Add New Column Based on Days Between Two Dates ResultI'm using the Subject Area Workforce Management - Work Relationship Real Time. Below is a formula that calculates the number of days between Termination Notification Dat…
-
Termination Bar Chart by MonthSummary: We are trying to make a Bar Chart to show # of term by Calendar Month but the format of the month looks strange. Is there a way to list Calendar month with name…Rebekah Gilday 2 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Last Day of the Previous Month Active HeadcountSummary: SQL for Period Start Active Headcount minus 24 hours Content: We are looking for a SQL formula that takes the delivered measure Period Start Active Headcount mi…Rebekah Gilday 21 views 2 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM