Reports
Discussion List
-
DATEVALUE Function is not working properly in excel templateAfter using DATEVALUE Function column values are not matching with the actual column values. Please refer the screenshot Not sure what is the issue. Template : Thanks, M…minati_behera-Oracle 21 views 2 comments 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM -
% of Employees on Talent Review meeting w.r.t Succession PlanSummary: I am looking to calculate the % of employees on a Talent Review box those who are on Succession Plan. SO for example on the 9-Box matrix box- Future Star we hav…
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 21.10Summary: Learn about what’s new in the EPM Cloud Narrative Reporting and Reports 21.10 release. Content: Please refer to the October 2021 What’s New guide to understand … -
General Questions on Reports Data SecuritySummary: Content (required): Also, I need to know if a user has 2 Roles: 1. HR Specialist Custom Job Role assigned to 'View all people' data security profile 2. HR Analy…Walid Hamdy 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create a report that shows invoice data on day it was loaded?Summary: Hi everyone. I am curious if there is a way to create a report that allows me to collect data from an invoice on the day it was created. Such as Problem Type. I…User_2025-02-10-15-06-52-222 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
From where to get (table name) the value of Candidate Type When Applying field.Summary: From where to get the value of Candidate Type When Applying field.Content (required): Version (include the version you are using, if applicable): Code Snippet (…Awadhendra Tripathi 1.5K views 2 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
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 321 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 163 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…