Reports
Discussion List
-
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 626 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058 Reporting and Analytics for ERP -
Table name and column for Cost ExpenditureTypeSummary Table name and column for Cost ExpenditureTypeContent Dear Champs, I am looking to find the amount of each expenditure type I wanted to check if ACCT_BURDENED_CO… -
RTF Template : Hide Row based on SUM() after complex RegroupingSummary Has anyone tried to Hide a row after regrouping the data and the conditions should be based on the SUM() of a column obtained after groupingContent The XML data …Balachander G-Oracle 58 views 1 comment 0 points Most recent by Amrit Reporting and Analytics for ERP
-
Ability to enable Percentage of total on a line graphSummary Ability to enable Percentage of total on a line graphContent I am building a line graph and would like to set the data markers as a % of the total value instead …User_2025-02-10-08-27-16-805 14 views 9 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Not-for-Profit Statement of ActivitiesSummary Seeking sample Statement of ActivitiesContent Statement of Activities quantifying revenue and expenses of our not-for-profit entity for a reporting period. The n…User_2025-02-11-03-09-13-126 19 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP
-
Normal "Planner" Users seems to have Power User rightsContent Hi all, It seems that all normal "Planner" users are able to see all reports in EPBCS, when they navigate to explore repository they don't have access to the sam…
-
Termination Report using Workforce Management - Work Relationship Real TimeSummary Termination Report using Workforce Management - Work Relationship Real TimeContent Hello - we have been using the archived report attached for a while now, but i…Shanna Oppenheim 59 views 17 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard - HeadcountSummary Female ManagersContent Hi All, Looking to Female Managers metric I can see the following logic: IFNULL(((FILTER(FILTER("Worker Assignment"."Head Count" USING (DE…Alvaro Couto 58 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
20D Known issue with OSHA Reporting?Summary 20D Known issue with OSHA Reporting?Content Is there a known issue with the "Environment Health and Safety - Incidents Real Time" Subject Area? Adding these colu…Andrew_Schmitz 33 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Missing Photo AuditSummary Is there a field tied to the Photo for an employee in HCM?Content Does anyone know if there is a field to pull into a BI Analysis that would tell me if someone d…User_2025-01-28-20-43-56-568 89 views 10 comments 3 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Number of Subordinates ReportSummary To show how many subordinates the person hasContent Hi All, I'm not sure if anyone is able to but I have been trying to figure a way to count how many subordinat…Eric.C 47 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can I report on top 5 reasons for short term sicknessSummary Want to adapt the seeded report to show absence reasons for duration limitContent Hi How can I show the top 5 reasons for an absence of less than 28 days duratio…LynneLBL 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard - HeadcountSummary Part Time logicContent Hi All, I've created a custom version of the Line Manager Dashboard in order to fix a few metrics. One of them is the Part Time metric ava…Alvaro Couto 56 views 2 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM
-
OTBI GL Subject Area : 'General Ledger - Journal Real Time'Summary OTBI GL Subject Area : 'General Ledger - Journal Real Time'Content We are developing Analysis reports relating to Cloud General Ledger in Oracle Transaction Busi…Swaroop Mitta 162 views 2 comments 1 point Most recent by Renuka Nuguru-Oracle Reporting and Analytics for ERP
-
Unable to Provide Logon Credentials to Schedule a BatchSummary While providing logon credentials, the screen never accepts them and just keeps looping the pop up menuContent I'm attempting to schedule several reports I'll ne…John H-2955 28 views 1 comment 0 points Most recent by John H-2955 Profitability and Cost Management -
Report for Scheduled jobs and AgentsSummary Report for Scheduled Jobs and AgentsContent Hi All, I went through the topics but couldn't find an answer to the question about a report being created that shows…User_2025-02-04-08-51-08-912 44 views 1 comment 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
OTBI Reports MigrationSummary OTBI Reports Migration StrategyContent Hi, Do we have any DevOps approach in migrating OTBI Reports like catalog,datamodel and template from one environment to t…Sujan Gutha 88 views 17 comments 0 points Most recent by amy hardtke Reporting and Analytics for ERP -
How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query … -
Embedding Dashboard on context UIContent Dear All, I have embedded dashboard on Hiring page by creating another tab as shown in attached screenshot. I don't want to show all the catalog options with das…User_2025-02-06-14-37-05-233 67 views 8 comments 0 points Most recent by User_2025-01-30-00-32-10-452 Reporting and Analytics for HCM
-
20C-Format does not match with date when scheduling BIPSummary 20C-Format does not match with date when scheduling BIPContent We're getting the attached when users go to schedule any BIP that has a date prompt. They can clic…User_2025-02-04-16-58-40-850 44 views 6 comments 3 points Most recent by Prudence K Reporting and Analytics for HCM
-
Financial Reporting Studio linked to Vision DatabaseSummary Financial Reporting Studio linked to Vision DatabaseContent I originally created the Vision Application for Planning. This was then removed. I have then created …
-
Embeded Action Link in DashboardSummary I am quite new to the use of Action links and I was wondering if somebody meight be able to help?Content Hi, I am currently trying to understand the new "Service…Mitch_123456 21 views 3 comments 0 points Most recent by Mitch_123456 Reporting and Analytics for HCM
-
Hire actions and termination actions at the same rowSummary Can't unified the hire reason and the termination reason to a one recordContent Hi, We want to create terminations report. In this report we want to include thei…
-
Can I rename the person level 1.00 in Assignment List when referring to this in a prompt?Summary The person level is 1.00. Can this be renamed as a reference in the prompt to Direct Reports?Content Hi Is this possible to rename the 1.00 person level to Direc…LynneLBL 16 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Formula for Sum of aggregate salary change percent by person number?Content Hi Everyone, I am trying to determine the best way to write a formula to show the sum of salary change percent by person number. For example, I have an employee …User_2025-02-07-16-42-37-187 66 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What is the best way to calculate Balancing Allowance or Balancing Charge (i.e. Net book value of asSummary What is the best way to calculate Balancing Allowance or Balancing Charge (i.e. Net book value of asset (TWDV) less Sales proceeds) in TRCSContent Hi, I would li…Pradeep Kumar-230381 42 views 2 comments 0 points Most recent by Pradeep Kumar-230381 Tax Reporting (Direct Tax)
-
Employees with Cumulative Salary Increase of >20% over a fiscal year reportSummary Employees with Cumulative Salary Increase of >20% over a fiscal year report for audit purposesContent Hi Oracle Team, We were just asked by our audit team to pro…User_2025-02-07-16-42-37-187 21 views 3 comments 0 points Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM
-
Best practice to pass parameters to BIP reports in the URLContent Hi, we need to embed a button in the performance document page in order to print a custom version of the performance document. We did the following: we created a…Alberto Boccato 64 views 5 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM