Category 81
Discussion List
-
One report containing all assignment, elements and work schedule assignment changesSummary: The organisation requires a combined report containing history of all assignment record, element entries and work schedule assignment changes. Content (required…User_2025-01-29-23-50-34-285 48 views 0 comments 0 points Started by User_2025-01-29-23-50-34-285 Reporting and Analytics for HCM -
'Payroll - Element Entries Real Time' subject area does not display any data for Line ManagersSummary: I have built a OTBI Report using ‘Payroll - Element Entries Real Time’ subject area for line Managers to see who has Skills Allowance. I have deployed this repo…Vijay Gorania 37 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 59 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 17 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 28 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 18 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 9 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 50 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 47 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.5K 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 439 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 17 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 121 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 117 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 324 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 16 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 78 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 167 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 24 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 14 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 34 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM