Category 81
Discussion List
-
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 39 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…HarishVummidi 57 views 1 comment 1 point Most recent by HarishVummidi 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 175 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 33 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 25 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
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 77 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 67 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 78 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 33 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 42 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 25 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 96 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 13 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
OTBI analysis column content does not wrap when added to dashboardSummary: OTBI analysis column content does not wrap when added to dashboard. Content (required): Standalone OTBI wraps text but when added on dashboard text is not wrapp…Adil Muhammad 22 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to scroll Subject Areas with UnionSummary: When trying to use the "Combine results based on union intersection and difference operations" I'm unable to scroll past the initial list of Subject Areas to th… -
Handling Invalid Dates in a CASE statement in OTBISummary: How do you replace 00--0 with an actual date in OTBI? Getting error with CASE statement below Content (required): My CASE statement is coming back with an error… -
How to get Active Bank Account DetailsHi Experts I am trying to write a query to get Active Bank Account Details for a given employee. I am not sure in which table and column this flag is stored. I checked "…Dharmendra Shukla 497 views 4 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
To avoid Oracle Repository external accessHi team, I need your precious support! Cause of notifying the candidate, we created a BI report adding a "link" to make the recipient able to download a .zip file. We us…tommasodicesare 33 views 0 comments 0 points Started by tommasodicesare Reporting and Analytics for HCM -
Need the field from the table to use the alternate email for internal cand to build the customBI repSummary: Need the field from the table to use the alternate email for internal candidate to build the custom BI report and i am not able to find this field in IRC_CANDID…