Reports
Discussion List
-
Risk/Impact columns pulls in one value and one blank value causing duplicate rows in OTBI?Summary: Subject Area: Workforce Profiles - Person Profile Real Time Columns: "- Risk of Loss"."Impact of Loss", "- Risk of Loss"."Risk of Loss" Content (required): Hi A…William_Johnson 51 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Copy and Modify the Seeded Recruit to Hire DashboardSummary: We want to make modifications to the analysis tied seeded Recruit To Hire Dashboard. I've read various posts and documentation on how to achieve this, but none …Alex Tellez 161 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP report queriesSummary: Hi Team, Can we have 2 filters in the BIP report : 1 that selects the legal entity or BU then 2 - only show the departments which is in that BU for selection. K…Sakthi Priya S 41 views 6 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Reports vs FRS ReportsSummary: Differences between Reports and FRS Reports Content (required): We are in the process of migrating our current FRS Reports to the new solution Reports. I see in…Casey Kempel 141 views 10 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close
-
Dynamic Regular Date Earned Formula RequiredSummary: Need a formula to get the last two regular dates earned to update each month. Content (required): I have a Payroll Net Pay Variance report which compares the Ne…
-
HR self-service reporting in Oracle HCMSummary: Content (required): Hello everyone, I wanted to ask about the possibility to have HR self-service reporting in Oracle HCM, i.e. the possibility for HR users to …Maria Xydopoulou 61 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Mass closure of pending HCM workflow transactions (approval transactions)Summary: Mass closure of pending HCM workflow transactions (approval transactions) Content (required): Hi Team, Greetings! Is there a way to perform Mass closure of pend…Parag Hiremath 61 views 3 comments 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Deeplinks in OTBI and BI ReportsContent Is there a way we can use the Deeplinks in the OTBI and BI reports dynamically. Suppose I have a column for 'Person Number' and I click on a particular person nu…Amrit 121 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Is there a standard report for Balance Adjustments?Summary: Specifically, we are looking for a way to report on failed Balance Adjustments. At year end, we frequently mass load Balance Adjustments. And always a few fail …Melissa Gettman 51 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Bursting Report outputSummary: Bursting Email Contains the Sql Query output in the Message Body. How to Remove the Sql Query Output line from the Message Body Content (required): Version (inc…MilanMohanty 81 views 9 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Parameter not working when embedding OTBI AnalysisSummary: Embedded an analysis on HCM page but it seems that the binding variable is not being received by the analysis because the report is not being filtered Content (…Jezreel Furagganan 61 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM
-
When opening "Reports" in EPBCS web, the hierarchy is flatHow do other users manage this, we have like 1000 member and users cannot remember all name, in HP it shows the hierarchy so it's easy to navigate and select member. Ple…User_2025-03-10-22-57-31-218 61 views 9 comments 0 points Most recent by Dave Roberts_-Oracle Planning
-
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…
-
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…Gene Garcia 2.2K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP
-
Unable to create a new Application Page Entry for a BI ReportSummary: Unable to create a new Application Page Entry for a BI Report Content (required): We are trying to create a page entry to open a BI Report. Used the Application…Bhargava Varma G 51 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Table name which stores start date and end date in individual compensation planSummary: Hi Everyone! I am looking for the table name which stores start date and end date in the individual compensation plan. I tried - cmp_plans_vl, cmp_components_vl…
-
Seeing Data Across Different EnvironmentsSummary: Viewing data across different environments inconsistent. Content (required): When I run a report, we created in Dev11, there some data that I don't see in our U… -
Seeded line manager dashboards for executive leadershipSummary Dashboards for executive leadershipContent We have made a copy the of seeded line manager dashboard and modified it to work with our system configuration and req…User_2025-02-10-08-27-16-805 106 views 12 comments 0 points Most recent by Deborah A Reporting and Analytics for HCM -
Can we extract import project errors using custom BIP report?Hi, We are using FBDI to import projects in Oracle PPM Cloud. As per our observation, projects interface table PJF_PROJECTS_ALL_XFACE is getting purged automatically onc… -
How can we limit access to reports residing in delivered (out of the box) folders?Summary: How can we limit access to reports residing in delivered folders? Most of the users have access to BI roles (Consumer/Author/Admin) inherited through other role…
-
How should I calculate the employee's seniority?Hi, I have a query where I calculate the seniority of the employee and I want to sort by the highest seniority. The query works like this if the 'Seniority Reference Dat…Cansel Karasoy 41 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Lease Accounting ERD diagramSummary: We want to create custom BIP reports based on Cloud Lease Accounting tables found here (https://docs.oracle.com/en/cloud/saas/financials/23b/oedmf/index.html). …
-
Audit Log for ReportsSummary: If there an audit log for all changes made to reports in Reports? Content (required): In FRS, although there was not an audit log, we could leverage the last up…Casey Kempel 71 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Does OTBI report follow Data Security enabled for usersSummary: Does OTBI subject areas enforce the Data Security Context values that have been assigned to users. For example, a user has been assigned one BU and One ledger, …
-
Hide data on charts from "Reports"Is there a way to hide data on charts from a Report. The below yellow highlighted box has numbers but it's overlapping and looks bad. is there a way to get rid of all da…User_2025-03-10-22-57-31-218 41 views 2 comments 0 points Most recent by User_2025-03-10-22-57-31-218 Planning
-
how do I define datesSummary: I am trying to fun an agent weekly and want to have it select a date range Content (required): the job will run every Friday morning and needs to include employ…
-
Open/filled position management reportingSummary Delivered Position Incumbents report returns terminated employeesContent Hello - There's a requirement to create a report of all current filled/open positions wi…