OTBI
Discussion List
-
how to avoid multiple rows in OTBI ReportsSummary how to avoid multiple rows in OTBI ReportsContent Hi Team, we have a requirement to pull "Work E-mail" so i have written case statement with email type code as "…User_2025-02-04-07-00-18-658 111 views 12 comments 0 points Most recent by User_2025-02-04-18-22-33-673 Reporting and Analytics for HCM -
Report with two different As-Of-Dates to calculate Delta variationsSummary We need to pull two lines for employees, one referring to CURRENT_DATE and the other to the previous monthContent Hi All, we do need to calculate, for Payroll pr…User_2025-01-31-00-30-34-540 28 views 4 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Competencies OTBISummary Cannot view the competencies for position in OTBI reports while the values in the position profileContent Hi , Cannot view the competencies for position in OTBI …Rafik Beshara 71 views 1 comment 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Agent mail trigger issueContent Hi, I have created a agent. In 'Delivery Content' tab I have given content as 'Briefing Book' with PDF format , and also configured mail ids in Recipients' tab, … -
HR can't see all HR Action valuesSummary We have analysis and HR can't see all HR Action values.Content Hi All, In our analysis we see who left the company, why and dates, actions etc. In HR Action we h…User_2025-02-04-18-26-11-309 41 views 2 comments 0 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
HCM Cloud OTBI Workshop at Oracle ParisContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t…Julian Challenger-Oracle 48 views 6 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Global Transfer ReportingContent Hi all - we have come across an issue for reporting that we need your expertise on. Recently, we found that a Global Transfer action-action reason can be correct… -
Agent Deletion errorContent Hi I am getting below error while deleting the agent , please assist on this. ThanksUser_7836 18 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
OTBI Conditional Formating - Color Coding Not workingContent Hello everyone, I have created passport details report. This report contains field Passport Expiration Date. I would like to color cells where expiration date is… -
Prompt Filter - Date Format ChangeSummary We can't change filter's Date Format at promptContent Hi All, I added date filter with using Prompt for analysis. In Analysis, I can change date format as I want…User_2025-02-04-18-26-11-309 93 views 12 comments 2 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
As-of-Date Doesn't work anymoreSummary As of date variable in OTBI doesn't workContent Hi, Since the last release, the feature of putting variable in OTBI analysis for effective date doesn't work. The…
-
Identify ALPHABETS in STRINGS in OTBIContent Hi All, We have an report where we need to identify ALPHABETS from a values coming up in the report as a filter criteria. For examples, pick all the Account numb…Vibha Pandey - Oracle 33 views 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Custom BI Notification is failing to execute withSummary BI Agent fails to execute with error messages. its sending only 2 emails out of 6 recipientsContent Hi, We have imported the R13 Notification pack from Learnign … -
Payroll Check Details ReportSummary We have a requirement to pull out Payroll Check Details for an employeeContent Hi, Can anyone help me with a Sample query which will give Payroll Check Details (… -
OTBI Does Not Produce ResultsContent Hi All, I am just running a simple query to get the list of all employees. It's only showing my name, plus as soon as I one more column it does not produce any r…Neha_Takkar 49 views 5 comments 2 points Most recent by Ivy__Valverde Reporting and Analytics for HCM -
EIT - India Nomination InformationContent Hi All, We have a requirement from our business in India regarding their benefits program. We require to report on Extra Information - India Nomination Informati…User_KOLMZ 58 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
19B caused a number of BIP reports to now fail - HY000Content Hello, Following our upgrade to 19B at the weekend a number of custom reports are now no longer working that we had built. I wonder if any reporting experts woul… -
Report on courses and offerings available in the systemSummary Need a report to get an idea on the full catalogue availableContent Hi, We have loaded and are still loading a lot of training courses and offerings in HCM Fusio…User_2025-01-30-22-29-59-990 62 views 2 comments 0 points Most recent by User_2025-01-30-22-29-59-990 Taleo Learn
-
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud ThanksRebecca Smith-27468 78 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
'Column format - Suppress' do not work in OTBI Direct Database request reportSummary Suppress property in OTBIContent Hi All, I have created a direct database request report where I want to suppress a field 'Year' if the values are repeated. I us…SuryaMuralidharan 70 views 2 comments 0 points Most recent by SuryaMuralidharan Reporting and Analytics for HCM
-
Customizing Seeded Analyses from CatalogSummary Seeded analyses are using custom values that don't match our setupContent Hi Everyone, I understand that with R13 we can no longer modify or remove the seeded re… -
Choosing All options from filter at the TableSummary We have department filter at one Table. We can't choose All.Content Hi All, How can we choose All options from one filter at the table. It allows only declared d…User_2025-02-04-18-26-11-309 33 views 6 comments 1 point Most recent by Timothy Orrange Reporting and Analytics for HCM
-
Employees by Tenure and Age BandSummary Employees by Tenure and Age BandContent Hi I am looking for a report which has the Employees by Tenure and their Age band for the last 4 years. Could you please …Mansur Khalil 73 views 5 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
How to add default value for a particular column in OTBISummary How to add default value for a particular column in OTBIContent I have created a analysis in OTBI. And have added one date column in the Promt and trying to defa…User_2025-02-05-02-11-29-794 104 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to remove Grouping of data in OTBISummary How to remove Grouping of data in OTBIContent I have Created a report to fetch the absence Entries for a Person.And in the Prompt i am using Start date column. i…User_2025-02-05-02-11-29-794 128 views 5 comments 0 points Most recent by Mark Johnson Reporting and Analytics for HCM
-
Analysis of seeded HR dash boardContent Hi Team, Can any one know where to find the analysis of seeded HR dashboard ? We have checked all the folders in reports and analytics.User_4VVG2 74 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM