OTBI
Discussion List
-
Account Segments Report ExampleSummary Account Segments Report ExampleContent Hello all We need to develop a report about Account Segments. We made it by Query and it is bringing the correct informati…Pedro Teixeira 20 views 2 comments 0 points Most recent by Pedro Teixeira Reporting and Analytics for HCM -
Subledger Journals - OTBI Subject AreaContent Hi, In Subledger Journals OTBI subject area, Accounting period column does NOT show in ascending/descending order in prompts. Using the below SQL in the prompts …Vinod Kumar Mohanraj 56 views 1 comment 1 point Most recent by Gergana Radoutcheva-Oracle Subledger Accounting & Accounting Hub -
Compensation with manager with access 'limited'Content hello, I have a question, on a compensation plan, if a manager is not eligible to a compensation plan but he manage someone inside the compensation plan, he have…User_2025-01-25-01-33-46-269 63 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Missing Create Infolet tile iconSummary Missing Analytics tab and Create Infolet optionContent Hello, I am interested in creating an Infolet based on information that is present in Product Information …
-
Is there any standard report in AP with Fields (Vendor Name, Site, Opening Balance, Transaction, CloSummary Is there any standard report in AP with Fields (Vendor Name, Site, Opening Balance, Transaction, Closing Balance)?Content Is there any standard report in AP with… -
Adding days to the Date prompt in OTBISummary Adding days to the Date prompt in OTBIContent Hi Team, I have one requirement to add 6 days to the prompt date and fetch the value based on the new value. +6 or …SM-Oracle 162 views 1 comment 0 points Most recent by Mallikarjuna Maganti Reporting and Analytics for HCM
-
How to enable export functionality in ReportsSummary How to enable export functionality in ReportsContent Hello, We created reports using OTBI and have put them under 'My Dashboards' but we are wondering why we can…Tony Puentes 42 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Performance tile to show a 0 instead of no resultsContent Is it possible for a performance tile to show as a '0' if there are null counts instead of it showing a message saying 'no results'User_2025-02-06-11-18-47-896 45 views 7 comments 1 point Most recent by Rob F Reporting and Analytics for HCM
-
Want to extract Data from Report & analytics by writing SQL QuerySummary Want to extract Data from Report & analytics by writing SQL QueryContent I Want to extract Data from Report & analytics by writing SQL Query. Previously i use ex… -
Conditional Formatting in Pivot TableSummary Colour by Absence Type working in Table but not pivotContent Hi I'm trying to show a calendar for this month and next month. The number of days/hours shows corre… -
Report no longer workingSummary This report last worked before the April upgrade to 20BContent Hi, This report (see attached XML) no longer works - can anyone check why? There are no filters or…User_2025-02-05-22-44-35-842 23 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Query Data Model securitySummary Example of query or config to allow data models be displayed to all employees without them seeing whole company data.Content Hello all When a more robust report …Pedro Teixeira 39 views 6 comments 1 point Most recent by Pedro Teixeira Reporting and Analytics for HCM
-
How to get dynamic column names in the OTBI analysisSummary How to get dynamic column names in the OTBI analysisContent Hi, We have a requirement were we need to display the column names(labels) dynamically. THis report i…User_MC37Q 150 views 3 comments 3 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Is it possible to enable a dashboard as an InfoletSummary Is it possible to enable a dashboard as an InfoletContent We have a requirement to enable dashboard as a infolet. Tried to add dashboard as an infolet but not ge…User_XT9HW 139 views 2 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Dashboards - ObseleteSummary Dashboard - ObseleteContent Hi, Just want to know the Dashboards going to be obsolete in coming versions and Infolets will take precedence. Regards/Prasanth Vers…DineshApps 41 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Infolets - No ResultsSummary Infolets - No Results MessageContent Hi, We have created an infolet using OTBI report. Whenever there is no data for the report criteria system showing following…DineshApps 48 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Can this report be date drivenContent Hi I have created a report which shows the hierachy but what the team really needs is for it to be date driven so we can see the reporting lines for example a co…User_2025-02-06-11-18-47-896 25 views 3 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
CASE statement with IFSummary Need help with a CASE statement where it displays element input value if they have the element, else shows nullContent Hello, We have element set up like below t…User_2025-02-04-15-06-22-759 56 views 6 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Reporting on Rejected DORSummary Requirement to report on rejected DORContent Some of the DORs in our system pass through the Approval cycle. I have checked "Workforce Management - Documents of …User_2025-02-05-23-02-10-916 35 views 6 comments 1 point Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
Customization in Seeded Line Manager Dashboard for Absence pageContent Hi Experts, In the Seeded Line Manager Dashboard, the Absence page has an Absence for Today and Tomorrow analysis which displays absentees for Today and Tomorrow…Jaswant Prajapati 35 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Not able to view any result from Subject Area Workforce Learning - Learning Content Items Real TimeSummary Not able to view any result from Subject Area Workforce Learning - Learning Content Items Real TimeContent Hi Expert, are you able to get any result from subject… -
Report not showing own itemsSummary An report from timecards does not show own itemsContent We use time and labour to claim overtime as well as to record our flexi. With all our reports in OTBI, th…Dawn Cawston - CPS 44 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
OTBI Analysis - Invoices paid by date paidSummary Want to create an analysis which can be run by payment date of invoiceContent Hello, This is probably a very basic question but I wanted to create an analysis or…User_2025-02-04-19-45-49-438 360 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Split by genderContent Hi is there a way to split facts within subject areas by gender. i have tried using the filter but it returns all employees and i would like to create an attriti…User_2025-02-06-11-18-47-896 36 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM