Category 81
Discussion List
-
Grouping and sum the RUN values of balances using XSLTSummary: Grouping and sum the RUN values of balances using XSLT Content (required): I have a below requirement to group by and sum the RUN values for each balance under …Deekshith Kalluri 32 views 0 comments 0 points Started by Deekshith Kalluri Reporting and Analytics for HCM -
ORC: Tracking all the End Dates for a RequisitionSummary: Hi, Can we track & report all the end dates for a requisition if Hiring Manger changes the End Date of the Requisition? Any help with details like Tables, Repor…Bhaskar Konar 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Requisitions per Department ReportSummary: Content (required): Hello Guys, We would create a report that show the number of requisitions for Departments and that it also have the functionality to explain…Giuseppe Iacono 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BIP Report - Department HierarchySummary: Hello, can I create a SQL for department hierarchy out of this sample pattern? Does it work in Oracle BI Publisher? with Org ( id,idparent, name, level , Path) …Hazel De Castro 31 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Please, which subject areas can i use to build a report on personal information data.Summary: We want to build a report on personal information data. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co…David Sakeye 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 491 views 5 comments 0 points Most recent by Evan Rathod Reporting and Analytics for HCM -
How to create Pivot table in RTF with Text values?Summary: Hello Experts, Is it possible to create a Pivot table in RTF with Text values? If yes, kindly share the details. Regards, Abhishek Premchandra Content (required…Abhishek Premchandra-Oracle 31 views 4 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM
-
Waived Benefits fields in OTBISummary: I have a report that HR has requested to add if the have waived their benefits elections. Is their a field/ subject area that will store this information? I'm c…RJ Blankenship 21 views 3 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
OTBI-Report-Workforce Management - Person Real Time-Roles RequieredSummary: OTBI-Report-Workforce Management - Person Real Time-Roles Requiered to get employee information Content (required): Hello I need to get some employee and manage…Cesar Saveedra 1 view 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to habilitate 'My Reporting' tab in HCM Cloud?Summary: Greetings, I have the Hr Specialist role in HCM Cloud but it seems I lack some configuration to use 'My Reporting' tab, when I search in the simulator Navigator…Saily De Jesus 31 views 4 comments 0 points Most recent by Saily De Jesus Reporting and Analytics for HCM
-
Blank line at the end of etext template output fileSummary: I'm trying to fetch the data from cloud in .txt file format by using ETEXT template. A blank line is noticed towards the end of the file always which is not exp…Meenakshi K 191 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Subject Area for Payslip Summary,HoursSummary: Can you please suggest if we have any subject area to get the below info Content (required): Version (include the version you are using, if applicable): Code Sn…pratyushak 11 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Submit a flow - When there is no privilege added to the custom roleSummary: Hi Team, We are facing an issue related to our custom payroll role. We have built a custom payroll role to perform a few payroll administrative works. This cust…Silpi 74 views 1 comment 0 points Most recent by Kathan Bhatt-Oracle Payroll and Global Payroll Interface (GPI) -
Unarchive ErrorSummary: I am unable to unarchive the BIP report to BIP and getting the below error. Tried in different browsers by clearing the cache, but still the same issue. Content…Satyanarayana M-Oracle 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Individual Compensation ReportSummary: We are using individual compensation plans to process additional overtime for the employee with defined approvals but approvers wanted to see analytics before t…Santhosh Kumar 52 views 7 comments 0 points Most recent by Santhosh Kumar Reporting and Analytics for HCM
-
Talent Review Prior and Latest N-Box AnalysisSummary: I am trying to capture the 2021 n-box and 2022 n-box of employees on Talent Review to find out if anyone has a change in the n-box. I created analysis but when …
-
Two Employee Rows Created only one shows Gender but not dual AssignmentSummary: Content (required): We are running an "All Employees" report and there appeared to be an anomaly on a single employee where it returned two rows of identical da…CB Trett 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 41 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 21 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 51 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 11 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 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…
-
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 11 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 1 view 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 41 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 61 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 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM