Category 81
Discussion List
-
Arrears report with Current Deduction And Total ArrearsSummary: Hi, I am trying to create a report that will show current deduction taken for Med, Dental, Vision Arrears along with how much the total is and if the full amoun… -
How to link custom button in homepage to BI ReportSummary: Content (required): Hello experts, I've created a custom button in homepage under My Client Groups tab. This button should be linked to a custom BI Report saved… -
How do you get the effective date based on the action reason value?Summary: I want to get the parental leave start date which is the effective start date based on the action reason = 'On parental leave' Content (required): I have the co…Ed Sevilleja 32 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need a list of all the BPM Approval Workflows from oracle fusionSummary: Content (required): Do we have any report or query or any front end screen which exports the list of all the BPM Approval Workflows from Oracle Fusion? Version …Vinay Gharge 460 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great…Bonnie Lafferty 282 views 2 comments 0 points Most recent by Bonnie Lafferty Reporting and Analytics for HCM -
Report is not giving any outputSummary: We have configured Employee Questionnaire and Manager Questionnaire and created performance template to use only these 2 questionnaires. 1st step is employee to…User_2025-07-18-06-45-42-477 33 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Issue with Report Edit for Bursting QuerySummary: Issue with Report Edit for Bursting Query Content (required): Hi All Greetings! This is an issue as observed when we tried to open the data model- When we try t…Parag Hiremath 62 views 11 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Need inputs to fetch the "Third Parties" (My client groups-->Third Parties) informationSummary: Need inputs to fetch the "Third Parties" (My client groups-->Third Parties) information Content (required): We need to know table name/OTBI subject area to fetc…
-
Find list of requisitions that has internal employees in the Best Candidates.Summary: We have a requirement to find out requisitions that has internal employees in the Best Candidates list. Please share if there is any BI query that I can use to … -
Could not able to search BI Consumer in PermissionSummary: Hi Experts, I have removed the BI Consumer role from a folder and when I try to add back the BI Consumer role, I could not able to search in "Add Application Ro…Harish Vummidi 51 views 1 comment 1 point Most recent by Harish Vummidi Reporting and Analytics for HCM -
BIP jobs are getting stuckSummary: BIP jobs are getting stuck Content (required): Hi Team, Greetings! We have been observing that multiple BIP jobs ( manual or scheduled) are getting stuck and re…Parag Hiremath 157 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Data is not coming in an otbi report once ldg is added.Summary: Content (required): In an custom otbi report, data is not coming once ldg is added to that. Version (include the version you are using, if applicable): Code Sni…Swati Rana 31 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Report Error - PGA limit (MB) exceededSummary: Report Error - PGA limit (MB) exceeded Content (required): Hi Team, Greetings! We have been getting the error as per the attached file for the report in Product…Parag Hiremath 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI error when running reportSummary: Hi all, Is anyone able to help me understand why this error message is being displayed when a HR user tries to run this report showing details of a particular e…
-
Failed to log into BI Publisher: invalid username or passwordSummary: Failed to log into BI Publisher: invalid username or password Content (required): Hello experts, we have done the P2T in oracle HCM, but after it, the connectio…
-
Security is not working in otbi dashboardSummary: Content (required): A custom role is able to see all the data regardless of their security. Is any privilege or security policy missing? Version (include the ve…Swati Rana 72 views 5 comments 0 points Most recent by Mayur Kaushik Reporting and Analytics for HCM
-
we need annual accural and carry over columns in biSummary: Hi Team, we looking above two columns from BI reports . any one can help me on. Thanks, Ajay Content (required): Version (include the version you are using, if …AjayKumar Maddipati 62 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBISummary: Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBI Content (required): Version (include the version you are us…Swati U 74 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
DFF Not showing in some HCM NotificationSummary: Hello, We've been customizing some HCM (NewHire, AddAssignment ...) approval notifications to add additional DFF. Our issue is that some DFF appear and some don…Guillaume SAVALL 65 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
How to fetch the manager and assignment for a userSummary: Hi Experts I'm looking to create a BIP report in Fusion cloud where I can pass the users email address and fetch the manager email address and assignment detail…
-
OTBI analysis not returning results in Spanish even though it does in EnglishSummary: I built an OTBI analysis to show results of performance documents, specifically the manager ratings. I have found that the reports is not returning results when… -
TERMINATION EMPLOYEES DATA NOT FETCHING POST 2018 IN OTBI REPORTSummary: With the help of OTBI tried to create report containing Person number, Name, Job code, Job Name, Grade Code, Grade Name, Termination data and Salary Basis, wher…Kavya Veluri-Oracle 31 views 2 comments 0 points Most recent by Kavya Veluri-Oracle Reporting and Analytics for HCM
-
Prompt does not work in dashboard for different analysis using different subject areasSummary: Content (required): I have a Dashboard with the following analysis (tabs) called: 1. Requisitions (SA:Recruiting Real Time) 2. Applications (SA:Recruiting Real …Maria Xydopoulou 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Changing Fetch First 250001 Rows Only to another valueSummary: How do you change the Fetch First 250001 Rows Only to another value or remove it entirely. Content (required): I need to remove the Fetch First 250001 Rows Only…
-
Reporting Sales within HCM OTBISummary: Content (required): I have a requirement that is asking to report Sales by Organization, but also housing infomation that you would find In workforce management…Yamalia Roberts 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to get the OldValue and NewValue by using per_bipntf_utilitySummary: Unable to get the OldValue and NewValue if any change on the Employeement level by using per_bipntf_utility Content (required): We did few changes on the Emplom…
-
Layer filters?Summary: Looking to be able to layer filters. An example would be that I want to only pull department names that start with a specific sequence of numbers AND have/don't…Jessica D 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Ethnicity values question in Recruiting Subject AreaSummary: Asking for assistance in understanding the difference between 2 Ethnicity fields Content (required): Hello. Can anyone advise on the difference between the 2 fi… -
OTBI - Calculate Tenure using Presentation VariableSummary: I need show Tenure calculation by subtracting the Work Relation Start Date of a person from the Date passed by the user against the presentation variable (Promp…Harpreet Shergill Oracle 93 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Publisher AverageHI, I need support to calc an average in this table rtf. I need to see in the red circle the average of 3 and 2 (the blue box). How do it? In zip I've attached rtf and x…gdegenna 12 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM