Reports
Discussion List
-
HCM Extract| Balance ValueSummary: Hi, I need to fetch balance value for dimension YTD. I created the balance group and HCM extract(Followed the attached PDF). But it is not working as expected. … -
Need Report for Number of times hire-date changed and all hired dates changed(in one field)Content Hello , We need the report of, Number of times hire-date changed and all hired dates changed(in one field). Is it possible in BIP? If yes, pls share me the sampl…Janardhana Kondaveeti 37 views 7 comments 0 points Most recent by Charanpal Singh Reporting and Analytics for HCM -
How to build a HCM extract to generate HDL files.Summary: As per the business requirement, I need to build a HCM extract to generate the CalculationCard.dat file. I need to build an extract which can give me balances y…
-
BIP Report to pull only terminated employeeContent how can we pull only terminated employees who does not have any active record as of sysdate -30 Example: Employee terminated as of yesterday and rehired as of to…Kavya Sreenivasulu 144 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Time Stamp Diff based on User Entered Date ValueSummary: Time Stamp Difference function calculating with user prompted date value Content (required): I am using the following function to calculate years of service. I'…Jennifer Wiggs 32 views 8 comments 0 points Most recent by Jennifer Wiggs Reporting and Analytics for HCM
-
Extract should have two Parameters 1. Expense End Date 2. Payroll NameSummary: Need input on how to add parameters in HCM extract. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s…Arti P 3 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Reporting and Analytics for HCM
-
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Documentation or Use Cases for putting reports on pages that use parametersSummary: Displaying reports on various pages that require page filters Content (required): We have successfully been able to add OTBI analysis to pages and filter on the…Karen Costakes 22 views 2 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform…Santhosh Bachu 54 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Resource Alert: Waitlist Exit AlertSummary: Hi All, I am working on a resource alert(alert composer) to achieve those learner details whose offering status change from waitlist status to some other learn …Arti P 32 views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…Scott Paulin 12 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would…Revital Mefano 21 views 2 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…Anton Rzhanov 73 views 8 comments 0 points Most recent by Anton Rzhanov Reporting and Analytics for HCM
-
EEO and VETS Reporting Set upSummary: Hi All, I am trying to run the delivered EEO and VETS reports from My Client Groups> Payroll> Submit a Flow area . But nothing is appearing in the LE dropdown a…Gaurav Rath- PGC 25 views 3 comments 0 points Most recent by Gaurav Rath- PGC Reporting and Analytics for HCM -
Attendance Register Report for LearnSummary Attendance Register Report for LearnContent Does anyone have an Attendance Register Report for Learn? To list delegates within a specific ILT Offering / Activity…Ruzwan Akram 73 views 2 comments 0 points Most recent by Esther Hess Reporting and Analytics for HCM
-
Using Session Variable can be used in BIP report to restrict data based on the user who will run it?Summary: Is Using Session Variable can be used in BIP report to restrict data based on the user who will run it? Content (required): Hello, I am running a BIP report reg…Hazel De Castro 39 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
How can we fetch "Non-Union Benefit Eligibility Dates" in OTBI ?Summary: From the attached screenshot we can fetch all the fields under Extra Information in Workforce Management - Person Real Time subject area except Non-Union Benefi…AaronJai 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need a BI Publisher Add-In Supported by MS Office 365Summary Need a BI Publisher Add-In Supported by MS Office 365Content Hi, We need a BI Publisher Add-In Supported by MS Office 365. Please provide a link to download the … -
BI publisher not workingSummary Unable to use BI publisher in ExcelContent Hi folks! I need to modify a Excel Template for a Oracle Cloud report. It seems that my BI publisher is not working pr…
-
How do I schedule a Job, So that a Job starts when earlier scheduled Job is completed.Summary: Schedule a Job for 10 sets of Employees so that each job set starts before earlier Job completes Content (required): I need to schedule a Job for 10 sets of emp…Anjan Polimera 13 views 1 comment 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM
-
Table for Pension Scheme name stored at PAE at UK calculation CardSummary Table for Pension Scheme name stored at PAE at UK calculation CardContent Hi Experts, I am try to pull the Active Qualifying Scheme for employee stored at PAE UK…
-
OTBI Previous Job History/Records Without Logical SQL or Custom-SQL/BIP - Possible?Summary History records of a personContent Hello, Can anyone please help me with the below scenario? I would like to get previous job changes/history (and few additional… -
Is there a way to display the values selected in the Prompt on the DashboardSummary Is there a way to display the values selected in the Prompt on the DashboardContent I created a dashboard, which contains the prompt and result area. as shown in… -
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
How to get a details of Clock Entries missing for 3 days or more (OTL Module)Hello all (Report Description: The list of employees who have missing clock entries for 3 days or more should appear in the custom report) can anyone please tell me wher…
-
Organization Audit ReportSummary BIP Audit Query to tract the mutations happened with respect to Departments.Content Hi All, We have a BIP requirement to tract down the mutations that are happen…User_2025-02-10-16-28-01-402 48 views 4 comments 1 point Most recent by Karen Costakes Reporting and Analytics for HCM -
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec…gguittini 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pass an employee ID parameter from an analysis to a Skills pageSummary: We want to have an OTBI analysis table of employee information with a link per person that takes the viewer to the Skills and Qualifications page with the emplo…User_2025-02-05-22-55-58-511 43 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM
-
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 426 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM