OTBI
Discussion List
-
Removing blanks from questionnaire reportingSummary: I have created a questionnaire with some questions having a response type of Rating and some with Answers. When I bring the fields Response Answer and Response … -
How do I suppress trailing zeros in my RTF template for comp statementSummary: How do I suppress trailing zeros in my RTF template for comp statement Content (required): I have tried both ’999.999999’ and ’D999999’. If a number has 6 decim…TerryM01 57 views 2 comments 0 points Most recent by Indra Sardana-Oracle Reporting and Analytics for HCM -
Values appearing in alternate lines when exported to excelSummary How to have just one line of valuesContent Hi, The Risk of Loss and Impact of Loss fields are not aligned on a single line of data, instead there is a NULL inclu…User_2025-02-05-22-44-35-842 40 views 4 comments 2 points Most recent by William_Johnson Reporting and Analytics for HCM -
Allocated Checklist Status Code in Workforce Management - Checklist Real TimeSummary: Hi All, Is anyone aware of what/where information in this column would pull from in the system? What would value "WAI" represent? Subject Area: Workforce Manage…William_Johnson 61 views 4 comments 1 point Most recent by William_Johnson Reporting and Analytics for HCM -
SQL prefix for 'As of' Date getting ADFS errorContent Hello, I have a sql prefix set as SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}'; I'm all of a sudden getting this error: State: HY000. Code: 77031. [nQSError…Susan Anderson 56 views 2 comments 0 points Most recent by Harpreet Shergill Oracle Reporting and Analytics for HCM -
Division showing blank for Performance task status real time subject area in OTBISummary: Org tree columns showing blank value in OTBI due to new org tree version Content (required): We have activated our new tree version from 1st jan 2023, since the…
-
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th…JHaden3 108 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Filter for Numeric using MAXSummary: Thinking of the approach how to apply Filter in OTBI to get the Max value of column where column is only numbers. Content (required): Data on DFF column is Varc…
-
Report showing previous month (starters, leavers)Summary: Is there a way to filter results for only a previous month - for example all new hires, terminations - regardless of the date the report is run? Content (requir…Gary Miller-39965 180 views 4 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Need to display complete History related Employeement changes for the previous and current valuesSummary: Need to display complete History related Employeement changes for the previous and current values Content (required): We need to display complete history employ…
-
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 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 36 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Gross Pay - Previous Week and YTDSummary Would like to be able to report out on the previous weeks' gross pay along with the year to date balanceContent Currently we have two reports. One to pull the pr…Kyle Norris 151 views 6 comments 0 points Most recent by Deekshith Kalluri 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 529 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 309 views 2 comments 0 points Most recent by Bonnie Lafferty 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 64 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…
-
Active assignment - Prompt between datesSummary OTBI - Active Assignment by dates promptContent Hi, I want to create a report that will show us employees which were active between dates. The end user will choo…Yaniv 123 views 13 comments 0 points Most recent by Harpreet Shergill Oracle Reporting and Analytics for HCM
-
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 62 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 186 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 36 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 27 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… -
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 77 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 38 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 45 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 27 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM