Sample Reports
Discussion List
-
Drill down from OTBI adhoc reports to PPMDear All How can I extract the drilldown hyperlink from PPM to OTBI ? I need the page that show the project financial settings structure Regardsmickel rmeily 25 views 6 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI) -
we have two subject areas in ORC but unable to find Offer Extednded DateSummary: Hi Team, we have two subject areas recurting real time and recurting events real time we unable to find Offer Extednded Date -column how can we find that column…AjayKumar Maddipati 42 views 9 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI) -
we need every year annual review value in performance documentsSummary: Hi Team, We need every year annual review value in performance documents in OTBI in sunbject area of performance rating real time. EXample--FY2021 Employee Annu…AjayKumar Maddipati 14 views 1 comment 0 points Most recent by AjayKumar Maddipati 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 110 views 1 comment 9 points Most recent by HarishVummidi 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 21 views 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI)
-
How To Restrict Values In OTBI Dashboard Prompt Based On SecuritySummary:Want to Restrict Values in OTBI Dashboard Prompt based on Security Content (required):You have a role that has access to an OTBI Dashboard, and the data in the r…vjsalve 40 views 2 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 54 views 7 comments 0 points Most recent by Swapnil Kashid General Transactional Reporting (OTBI) -
we need subject area in career and peoformance for performance Connect ConversationsSummary: Hi Team, we need to track the career and peoformance>peoformance>connect conservation >Performance Document Name related columns in OTBI any one have any idea h…AjayKumar Maddipati 12 views 2 comments 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
duplicay coming for each employee due to each employee have showing multiple mangersSummary: Hi Team, In below screen shot we have taken employee name and manger name, but same employee has two line mangers coming that is the issue facing in the report.…AjayKumar Maddipati 43 views 14 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
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 2 views 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 239 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 14 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 48 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 13 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 26 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 29 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…Charan Kollipara 55 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…Fongang 55 views 6 comments 1 point Most recent by AshishERPCloud General Transactional Reporting (OTBI) -
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 …Charan Kollipara 54 views 6 comments 1 point Most recent by Charan Kollipara 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…AshishERPCloud 55 views 5 comments 1 point Most recent by AshishERPCloud 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 58 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 19 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 30 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 26 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 30 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 25 views 6 comments 0 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI)