OTBI
Discussion List
-
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 103 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 -
Element Entry ReportSummary Element Entry ReportContent Hello Experts, Wondered if anyone could help with xml/sql that will help me pull out all the element entries against all employees (i…Ramson Maseko 348 views 3 comments 0 points Most recent by User_2025-01-28-05-11-13-165 Reporting and Analytics for HCM -
Totals for Amount fieldSummary How to subtotal a field that does work when using "Totals After"Content Hello Experts, I am trying to create a subtotal of a field called "Amount" from "Benefits…User_2025-01-29-23-59-58-976 51 views 6 comments 0 points Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM -
Using Distinct for OTBI reportsSummary We want to see only one result for specific areasContent Hi All, I have one report about absences and balances which belongs departments. We used Sum for some sp…User_2025-02-04-18-26-11-309 1.3K views 6 comments 1 point Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM -
Recreating HR dash boardContent Hi Team, Since the HR dash board willnot availabe after the latest patch, We are recreating it. We are facing following issue, 1. In one of the choice list "maxi…User_4VVG2 29 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to remove EDIT option from User in AnalysisSummary How to remove EDIT option from User in AnalysisContent Hi, How to remove EDIT option from User in Analysis. ThanksFarooq Syed, CPA, PMP, CISA, TOGAF 63 views 2 comments 1 point Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF Reporting and Analytics for ERP -
HCM - Business Intelligence: Using OTBI Hierarchies -- September 14, 2017, 9 a.m. PT - Submit QuestiContent Submit your questions for the HCM - Business Intelligence: Using OTBI Hierarchies session to have them answered during the live event. Post your questions by pos…Gail Langendorf-Oracle 101 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Delivered Analytics on Pay Equity InformationContent Hello again customer connect community! I'm looking for information regarding delivered analytics in cloud HCM OTBI or your experiences reporting on pay equity. …User_2025-01-22-19-43-38-766 45 views 8 comments 0 points Most recent by Lauren Owen Reporting and Analytics for HCM -
OTBI Agent not sending some of the recipients emailsSummary OTBI Agent not sending some of the recipients emailsContent Hello, One of the recipients mails in agent - is not being sent , ALL other mails are sent . what cou…Revital Mefano 144 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Manager Assignment vs Worker Assignment in OTBISummary Manager Assignment StatusContent Hi Team, I know there are a few Manager's information fields available in OTBI but I could not find Manager Assignment Status, f…Alvaro Couto 66 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Top Manager field not populatedSummary Some employees are missing a Top Manager so they don't appear on reportContent Does anyone know how the Top Manager field gets assigned? I pulled it into a repor…User_2025-01-28-20-43-56-568 37 views 6 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM -
Loan 401K Accrued BalanceSummary Trying to find where the Loan 401K accrued amount is stored in OracleContent Hi, We have a number of 401K Loans and due to the way we process thru our vendor we …Raz Baboorian 56 views 1 comment 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Incentive compensation - Recovery Amounts DashboardSummary 19D release feature - Participant Recovery Amounts Dashboard & reports on Performance and Earnings Summary Subject AreaContent Business Use Case: Attainment Rank…Harshavardhan Konathala 18 views 0 comments 0 points Most recent by Harshavardhan Konathala Reporting and Analytics for SCM