Reports
Discussion List
-
Is there a way to restrict access in shared report foldersSummary: My colleague and I would like to be able to share reports with eachother but we don't want to others in the business being able to see or use them. Is there any… -
Default Expense Account in HCM Subject AreasContent The Default Expense Account is a key field for our client that is used for reporting and security management. They would like to report on it in OTBI so they can…User_2025-01-25-01-23-28-110 288 views 4 comments 0 points Most recent by Nishant007 Reporting and Analytics for HCM -
Is it possible get a output in text format from bip report oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 161 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo… -
Why does Terminated user access not revoked for reportsSummary: Hi, When we assign add User to any reports/report folder under permission, and that User get inactivated, this user access doesn't get revoked automatically. Do…Namrata_20 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI Report showing below error when we open through edit and result viewSummary: Hi Team, we have OTBI report but that report when we open through edit and in result view getting below error but when we open directly open button no error com…AjayKumar Maddipati 23 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d… -
How can we pull data of all staff employed between a financial year in OTBISummary: Date Range would be - 1 April 2023 - 31st March 2024 Content (please ensure you mask any confidential information): Version (include the version you are using, … -
How to align Prompt labelsI am trying to align the Date Between Prompt Labels as the ‘Please select dates’ and ‘Between’ labels not aligned at runtime. Prompt created based on Calendar date: the … -
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …AjayKumar Maddipati 91 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Data Archival & retention for HCM CloudSummary Data Archival & retention for HCM CloudContent we wanted to know you what would be recommended best strategy for Data Archival & retention for HCM Cloud & do we …Ranveer.Tiwari-Oracle 54 views 3 comments 3 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM -
Report agents are not working post 24B upgradeSummary: We did 24B upgrade on Saturday and several reports scheduled via agents were not delivered after the upgrade. Below are the observations so far; Some reports th…Ridma Karunanathan 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Due date not showing up for specific learning items in Workforce Learning - Learning ManagementI'm creating a custom report and I'm able to find all data. However, for some specific records the due date is not populated. I think this has to do with the fact that t…MaartenDIF 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Facing issue in Headcount by department hierarchySummary: My client wants to view the period end active headcount by level 2 and level 3 department hierarchy. I tried to achieve that using the below catalog attached bu…Shreya Datir 12 views 2 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM -
BI reports Permission Related QuerySummary "Application Roles" and "Users" : Is it AND or OR?Content Hi, We have a query related to permissions given to BI reports. When you navigate the BI reports folder…User_MC37Q 74 views 2 comments 0 points Most recent by Lakshmi Bai-112908 Reporting and Analytics for HCM -
Login Data from Identity Domain in Reporting and AnalyticsHello, Does anyone know if it's possible for login data from Identity Domain to be displayed somehow in HCM? I've tried the "User System Usage" OTBI subject area, and I'…Nick Dorfner 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab… -
How to bursting the BIP report and where we use the bursting conceptSummary: Hi Team, I'm still send the reports through schedule job only but we have butsting concept in BIP reports how can we send through bursting and where we can use …AjayKumar Maddipati 123 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
Looking for Last Contacted field for a candidate in Recruitment Module for reporting purposeSummary: Looking for Last Contacted field for a candidate in Recruitment Module for reporting purpose (Hiring à Candidate Search à Details à Key Highlights Content (requ… -
How to create a link with dynamic user IDSummary: Content (please ensure you mask any confidential information): We have a button inside the Goals page where the manager can give feedbacks to the employee in an… -
OTBI analysis - Bar graph in OTBI analysis for acquiring the headcount trend for the past years on mSummary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …Shreya Datir 53 views 15 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses … -
Workflow Transactions/Transaction Console Reporting (Rel 13)Content Hello, Just checking if anyone managed to create any Transaction Console related reports out of these two subject areas: 1) Human Capital Management - Transactio…SantoshKumarBhairi 897 views 11 comments 4 points Most recent by Samarpan Reporting and Analytics for HCM
-
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…Crisenese 24 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to return only the max ID grouped by selected column (SQL)?Summary: Content (please ensure you mask any confidential information): I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for usin…Giuseppe Cannova 21 views 4 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 594 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Inhibition of downloading a specific reportSummary: Hi all, we would like to know if it is possible to inhibit the ability to download a report. Also, it would be helpful to know whether this functionality can be…Alessandro Nesi 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How can we create drill down charts in Oracle BI Publisher (BIP) ReportsSummary: I want to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables. Not sure how to achi…Neha Bhatt 181 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Does anyone know how to restrict data in BIP report based on user who will run it?Summary: How to restrict data in BIP report based on user who will run it? Content (required): Hello I am running report in BIP regarding no performance goal plan. Can y…Hazel De Castro 555 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM