Reports
Discussion List
-
How to Add Sort Order to Table or GraphContent This document explains how to •Add a ‘sort order’ column to an OTBI report•Add the ‘sort order’ column to Table or Graph view•Hide the ‘sort order’ column on a P…User720640-Oracle 113 views 5 comments 10 points Most recent by Tsubasa Kokubu-Oracle Reporting and Analytics for HCM -
SOX and Smart ViewSummary SOX is asking how they can know Smart View data is accurate and completeContent Hello, Our SOX team is asking how they can know that Smart View data is accurate,…Luisa Stock 27 views 1 comment 1 point Most recent by Cezar - Fusion Oracle Support-Oracle Reporting and Analytics for ERP -
Unable to access Management Report in derived Navigation Flow via User (Role) LoginSummary: Hi, I am working on a planning project where we are supposed to have two navigation flows (NF) one for Power users and one for users. We are deriving the Naviga… -
CBCR automation configuration issueSummary: Could not configure CBCR automation to populate data in CBCR report Content (required): Our TRCS gets data from FCCS. We tried following approach with Oracle su…User_2025-02-11-20-21-37-906 11 views 1 comment 0 points Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax) -
OTBI and pulling yesterdaySummary: Hi All, I must admit I am pretty bad with dates in OTBI. I am attempting to build a report that will pull something entered the day before. Content (required): …User_2025-02-10-15-06-52-222 111 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Restrict OTBI report data(using subject area) to logged in userSummary How to restrict OTBI report data(using subject area) to logged in user. Currently it shows all data. Data access given at Business Unit level for the role.Conten… -
Fetching single latest row per person in logical SQLSummary Fetching single latest row per person in logical SQLContent Hi Team, I need to fetch Top row for a person and am using assignment real time subject area.. But, i…SM-Oracle 96 views 9 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM -
Security Slowing Down ReportsContent Hi all - We have a security role, Global Reporting, that allows me to create, edit, run reports and see all data. We give this role out to our report developers …Prudence K 48 views 6 comments 0 points Most recent by Shant Sarkissian_NES Reporting and Analytics for HCM -
CBCR automation configuration issueSummary: Could not configure CBCR automation to populate data in CBCR report Content (required): Our TRCS gets data from FCCS. We tried following approach with Oracle su…User_2025-02-11-20-21-37-906 1 view 2 comments 0 points Most recent by User_2025-02-11-20-21-37-906 Tax Reporting (Direct Tax)
-
Latest Assignment Row in OTBISummary: How to get the latest assignment row in OTBI Report Content (required): I am looking to develop a OTBI report to fetch the latest effective row in assignment. C…Manoj B. Cheruvathoor 323 views 4 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM
-
OTBI Report to identify the populationSummary: Our client has asked that I share a report that identifies the population. Is there anyone who knows how I'll be able to do it? Could you please send me a sampl…Hazel De Castro 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit FRS report usage in PBCS?Summary: Audit FRS report usage in PBCS? Content (required): Is there any means to get a last run date by report name in PBCS for the FRS reports? Version (include the v…
-
Does BI Consumer role has data access to reports?Summary: Content (required): Does BI Consumer role has data access to reports? If a user has BI consumer role, he can access reports, but how to control reports data sec…
-
OTBI report to Fetch Details of learning items assigned based on learning user groupsSummary: Hi Team, I am working on one OTBI report requirement - to fetch the details of learning course completion eg. learning item name, course completion date e.tc. T…Kamini Kaushik-Oracle 161 views 0 comments 1 point Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
OTBI Report filter using Date of BirthSummary: Unable to filter data based on a specific DOB Content (required): Hi All I have a requirement to filter contingent workers whose DOB is equivalent to 01/06/1960…Ridma Karunanathan 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue with project task hierarchy on BIP reportSummary: The same report is displaying the task hierarchy differently in test and prod environments Content (required): The same report, migrated from one environment to… -
Additional Criteria Dropping out International EmployeesSummary: I have a report built that is supposed to show everyone that is Active as of a certain date along with their job information and some personal information (phon…Kyle Norris 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Phone Number Format in OTBI outputSummary: We created an agent to send employee data from HCM to Service Now twice daily. This includes phone number. However, the requirement is to not include the countr… -
How to control data security on the catalog reports for a custom HR specialist role?Summary: Content (required): What controls catalog reports data access? Should a custom 'Human Resource Analyst' be assigned to a security criteria? If I add access to a…Mostafaaa 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting on FCCS cube in EPBCSSummary: Hi all, Is it possible to draw up a report (or rather a grid in a report) in EPBCS with FCCS as the selected data source? I know it is possible to do so in Narr…
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 31 views 2 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM