Category 81
Discussion List
-
Is there a way in OTBI and/or BIP to automatically push a scheduled report to SharePoint?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Nigel Wiltshire-Oracle 58 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
which field stores value for Primary for national_identifiersSummary: which field stores value for Primary for national_identifiers Content (required): For National Identifiers in Front end,we can enter more than 1 National Identi… -
Is there a transaction table that stores currently ongoing transactions on the page in HCM?Summary: Previously we have hr_api_transactions table in Oracle EBS but now i am not able to find a table like this, Would you please help? Content (required): It is nee…Fraol Wondimu 12 views 2 comments 0 points Most recent by Fraol Wondimu Reporting and Analytics for HCM
-
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 23 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…
-
Filters on multiple SA are not workingSummary: We are trying to create a new OTBI analysis, where we have a requirement to pull both the Worker assignment details and the person VISA details. So we used Work…
-
What is the usage & how to use a View Object validation type in Value set?Summary: Content (required): Version (include the version you are using, if applicable): 21D Code Snippet (add any code snippets that support your topic, if applicable):Fraol Wondimu 12 views 1 comment 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM
-
How to implement a custom version of a standard BI ReportSummary: How to implement a custom version of a standard BI Report Content (required): Hi, I would like to edit a Standard Performance Notification (the report is the fo…Alberto Barile 3 views 4 comments 0 points Most recent by Paul Campanello Reporting and Analytics for HCM -
previous Phase/State - recruitmentSummary: Is there a way of creating a OTBI analysis to show current Phase/State and previous Phase/State Content (required): We would like to create a report which shows…Mitch_123456 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
on-going resignations report - reporting on approvalsHello, could somebody please tell me how to extract this information from Fusion HCM, either as an OTBI or a BIP report? The business requirements: - we are using the jo…Geraud Andreux 65 views 4 comments 0 points Most recent by Geraud Andreux Reporting and Analytics for HCM
-
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 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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.4K views 2 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Concat string values in OTBI/BI AnswersSummary: Concat string values in OTBI/BI Answers Content (required): Is there a possibility to have a function like listagg for strings in OTBI/BI Answers?Yves Chassein 438 views 4 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Learning Records Real Time Report cannot add Hire Date field without rendering an errorSummary: Content (required): Since the Learning Management - Learning Real Time Assignment Subject area has been deprecated, we've been directed to use 'Learning Records…Ivy__Valverde 12 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to apply Line Manager data security in BIP report running from OTBI dashboardSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Vijay Gorania 82 views 12 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
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 103 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 308 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 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ORC: Candidate EIT info Reporting via OTBI Subject AreasSummary: Can we extract ORC Candidate EIT info via OTBI Subject Areas? Content (required): Can we extract ORC Candidate EIT info via OTBI Subject Areas? What will be the…Bhaskar Konar 65 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Oracle HCM Cloud Mobile Apps usage reportSummary: Oracle HCM Cloud Mobile Apps usage report Content (required): Please we have a request from our Executive Management, we need a report that can show us how man… -
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 132 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 22 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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
-
Extracting String from a text field in OTBISummary: Hi all, I need to extract the last part of an email address so I can include the exceptions in a CASE statement. Content (required): What I need to do is extrac…
-
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
-
Display Instructor and virtual classroomSummary/Content: We are building up some reports in OTBI for learning. In these reports we want to have a more or less complete view on the learning item and its enrollm…Yves Chassein 22 views 1 comment 0 points Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM