Reports
Discussion List
-
Query or the table that contains financial catogory for manage value UISummary: Hello all, We have a report in which we need to pick the financial category code we put against an account in manage value UI.please advise! BR, Sushan Peiris C…Sushan Peiris 282 views 13 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Summary How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Content How to Translate the BI Publisher Catalog Report Name and param… -
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… -
Viewer Roles cannot view data in SmartViewSummary: Viewer roles seem to not able to retrieve data using SmartView - either by formulae or ad-hoc. Content (required): Viewer roles does not seem to be able to view…ThalNP 341 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 3.2K 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 31 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 81 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
General Ledger Transaction Listing ReportSummary Lists down all Journal Entries along with corresponding subledger detailsContent This is one single consolidated view of all the transactions in ERP. This report… -
EPM OOTB report listSummary: Report list Content (required): Hi, Is there a consolidated list available that provides EPM OOTB reports like other areas in a speadsheet? Thanks Version (incl…
-
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 12 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 1 view 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
-
TemplateSummary: Hi all, Problem statement: I created the attached template in RTF-> linked to the report -> export the output in pdf but now client wants to have the output in … -
Combine 2 Analysis Outputs in on AnalysisSummary: Content (required): I have requirement to report on the number of starters by user person type and leavers by user person type in the previous month and email t… -
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…Anita 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to use Crystal Reports with Oracle HCM data?Summary: Is it possible to use Crystal Reports with Oracle HCM data? Content (required): I have had many years of experience with Crystal Reports in multiple HCM systems…Donna Valentine 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How do I set an OTBI agent to only Email if there is data returned in analysis?Summary: How do I set an OTBI agent to only Email if there is data returned in analysis? Content (required): Hello I am trying to set up an agent but I only want to it t…Helen Thomas 21 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Ethnicity- Multi resulting in errorSummary: I am trying to decode the multiple option selected in the race condition used: COUNT(DISTINCT "Worker"."Employee Ethnicity Code" by "Worker"."Person Number") > …Anita 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
user with predefined Viewer role cannot access FRS reportsSummary: Hello everyone, I have seen in the past that Viewer could access reports if I remember correctly. Is this an expected behaviour from recent updates? The user in…
-
Reporting on real trends in headcount by hierarchy excluding impacts of reorganisationsSummary: We need to provide headcount trend data to our business leaders and managers for their respective organisation without the impact of reorganisations being visib…User_2025-03-07-20-15-16-297 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
RTF TemplateSummary: Hi Team, I am working on a report where the template used is RTF template. This report captures data both for pensioner and employee. Requirement is like if per…
-
OTBI Turnover Dashboard for Line ManagersSummary: I would like to provide a Turnover Dashboard for Line Managers in OTBI but the seeded / sample dashboards provided by Oracle are not returning data when logging…User_2025-03-07-20-15-16-297 151 views 13 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
Leavers not showing now on manager dashboardsSummary: Leavers show very small numbers or nothing Content (required): My dashboard reports have been working fine but now I'm getting reports from managers that they c…