Sample Reports
Discussion List
-
Absence Balances ReportHello, We have been tasked to develop a report against the Absence records to find out the employee balances for each pay period. Can anyone please advise the subject ar…Harry Oracle 2 views 1 comment 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI) -
Users are unable to create new Analysis Reports in the Transactional Business Intelligence windowSummary: Content (required): Users are not able to see any option in the "New" tab in Transactional Business Intelligence window to create OTBI reports (Analysis/Data Mo…Dian Minshan 1 view 4 comments 0 points Most recent by Dian Minshan General Transactional Reporting (OTBI) -
Hints and Tips - How to Control the Colours in a GraphSummary Explanation of how to drive the colours in your graphs by the values being displayedContent This is part of a series of sample reports created by Oracle BI and H…Caroline Gladwin-Oracle 236 views 4 comments 8 points Most recent by Tamer El-Tonsy - FudgeLearn UK General Transactional Reporting (OTBI) -
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite… -
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEEContent Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Objec…edpalomo 12 views 2 comments 0 points Most recent by edpalomo General Transactional Reporting (OTBI)
-
BI Publisher Excel TemplateContent Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how …Kunal Daya-76859 47 views 2 comments 2 points Most recent by _IshanAgarwal General Transactional Reporting (OTBI)
-
Wrap Text in MHTML formatSummary Wrap Text in MHTML formatContent Hi All, While selecting mhtml as a default template, i am not able to wrap text few columns such as description column. User wan…VAIDIA 12 views 1 comment 1 point Most recent by SantoshKumarB General Transactional Reporting (OTBI)
-
Custom PO Print - Text Attachment Content on BI Publisher ReportSummary We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Docu…Rahul L 25 views 2 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
BIP compress output prior deliverySummary Compress output prior deliveryContent To divide the large data set in multiple data set in OTBI we have option to use bursting. By using bursting we have written…Niketa Ashwini 22 views 9 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
Scheduled Report JobsSummary Deails of Scheduled Report JobsContent Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI or…User_3Y94S 54 views 8 comments 1 point Most recent by Akshay Aiyer General Transactional Reporting (OTBI)
-
List of OTBI inefficient ReportsSummary looking for was to monitor OTBI reports performance and Frequency of useContent Hi All, I am looking for ways to monitor the performance of OTBI Reports in fussi… -
Report for scheduled ProcessSummary Required Report to pull details of Scheduled ProcessesContent Hi Experts, I would like to know is there any seeded report or query available to pull the details …User_3Y94S 54 views 6 comments 1 point Most recent by User_3Y94S General Transactional Reporting (OTBI)
-
Report on SocialSummary Need to create a report on Application SocialContent Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select fr…
-
Is Multiple Data Sets Creation supported for BI BurstingSummary Multiple Data Sets in BI BurstingContent This is with reference to Oracle Fusion HCM Applications Say we want to have a report which would hold Person Details as…AshishHCM 54 views 5 comments 1 point Most recent by AshishHCM General Transactional Reporting (OTBI) -
Need inputs to find who created/deleted the folder in Reports and AnalyticsContent Hi All, We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report? We need …Visu 24 views 4 comments 0 points Most recent by Tugce Kucukoner-144150 General Transactional Reporting (OTBI)
-
The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary The tool 'OracleBIOffice.exe' is not available after R12 upgradeContent We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Workspa…User_AEMC1 18 views 2 comments 3 points Most recent by user650055 General Transactional Reporting (OTBI) -
Customer hierarchy using BI Analysis (or OTBI)Content Hi All, I need to build a customer hierarchy report using BI Analysis (or OTBI). It should display Party Name, Party Usage and Primary Address. Can anyone help m…Rinku Gautam 28 views 6 comments 2 points Most recent by adelsorbo-Oracle General Transactional Reporting (OTBI)
-
BI Publisher - Adding Pivots with specific formatting on Head Count ReportsSummary Approach to use/add Pivots based on some Head count Reports built using BI PublisherContent Hi All, We have requirement to generate Pivot tables/Charts (Pie/Bar …Kalyan Amaravathi 25 views 0 comments 1 point Started by Kalyan Amaravathi General Transactional Reporting (OTBI)
-
Moving Print and Export OptionsSummary Can we move print or export options at top from bottom?Content Hi All, We have reports at Dashboard and we want to move Print and Export options at top from bott…Burakcan Sencan 23 views 1 comment 2 points Most recent by Julian Challenger-Oracle General Transactional Reporting (OTBI)
-
To Extract Order Header and Line details using OTBISummary looking for Sample query that works to get Header and line details of available orders using OTBIContent Hi, Can someone please provide me working sample query f…Shalindra Singh 26 views 0 comments 1 point Started by Shalindra Singh General Transactional Reporting (OTBI)
-
Hide "Reports Job" under New Menu in Analytics pageSummary How to hide "Reports Job" under New Menu in Analytics pageContent Hello, I am trying to hide "Reports Job" under New in analytics page (highlighted in the screen…Swamy-7253 24 views 6 comments 0 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI)
-
Provide Link to Candidate Job Submission in OBIEE ReportSummary I am looking for a way to include a link to a candidate's job submission within the TEE OBIEE tool.Content Is there a way to include a link to a candidate's job …Chris Shaver - HEB 15 views 4 comments 0 points Most recent by Chris Shaver - HEB General Transactional Reporting (OTBI) -
How to create a custom read online role to allow users to self serve reports that are segregatedContent Hi All I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segrega…Doron de Jong-57089 26 views 0 comments 0 points Started by Doron de Jong-57089 General Transactional Reporting (OTBI)
-
Purchase requistion Status analysisSummary Analysis for Purchase Requistions statusContent Hi, I need to developed OTBI analysis for Purchase Requisition with below information: PR number PR Amount Create…Farooq Syed , PMP 29 views 3 comments 2 points Most recent by Vijaya Kumar-70229 General Transactional Reporting (OTBI) -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 98 views 0 comments 9 points Started by User720640-Oracle General Transactional Reporting (OTBI) -
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 20 views 0 comments 1 point Started by Nirmal Kumar L General Transactional Reporting (OTBI)
-
Candidate Drop off ReportSummary a report that gives details on when a candidate drops off at an application and doesn't complete/submitContent We have been working on building a candidate drop …Iqra Khan 19 views 2 comments 0 points Most recent by Iqra Khan General Transactional Reporting (OTBI)
-
Different report in same Excel file with differents sheetSummary Different report in same Excel file with differents sheetContent Hi Experts, I created 3 new reports as per our customer requirements. But they need all the repo…Nirmal Kumar L 34 views 3 comments 0 points Most recent by Nirmal Kumar L General Transactional Reporting (OTBI)
-
How to get roles assigned to BI ReportsSummary How to get the roles assigned to BI ReportsContent HiI need to a quick way (SQL or BI report) to get the roles assigned to reports (we have about 200 of them). I…
-
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sqlContent Hi, Anyone know how to fetch the manager name for the terminated employees? For …Nirmal Kumar L 43 views 1 comment 0 points Most recent by Nirmal Kumar L General Transactional Reporting (OTBI)