Reports
Discussion List
-
Hidden fields in OTBISummary Need to find fields selected as 'Hide' as system default in column propertiesContent We have recently had an issue where one of our users has hidden a couple fie… -
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 53 views 6 comments 1 point Most recent by Charan Kollipara General Transactional Reporting (OTBI) -
SQL to Query Report Library - OTBI CatalogSummary Looking for SQL or tables to report a list of all reports, properties and folder locationContent Does anyone have a SQL or know the tables that would contain the… -
List of AgentsSummary List of Agents in "My Folders"Content Hi Team, Does anyone know how to list a list of Agents that were created by users and saved in their "My Folders"? I believ…Alvaro Couto 27 views 11 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Include report parameter in bursting output?Content I'm using bursting to control the filename/delivery of a report run as a part of a flow. I'm not actually splitting the data up, so I'm just using the Split/Deli…Andrew Dhabolt 17 views 1 comment 1 point Most recent by Sandeep S. Chauhan-Oracle 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…
-
BIP Excel templateSummary ER for Excel XLSX versionContent Hi Everyone, Does anyone know the ER# - even better with ETA, regarding having XLSX for Excel Templates in BI Publisher reports …Alvaro Couto 52 views 2 comments 2 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
What is catalog folder Extension?Summary Does anyone know the purpose of the empty shared folder Extension in the catalog?Content The folder is empty. A duty role exists for it, BI_EXT_REPORTING_DUTY, b… -
Deferred Termination field in OTBISummary looking on how to determine a deferred terminationContent Hello, I have been asked to create a report showing the associates with a deferred termination. When th…Kevin Lee Choon 30 views 3 comments 2 points Most recent by prjohnson General Transactional Reporting (OTBI)
-
Help with Formula: most recent offerSummary I need help creating a formula to pull in the most recent offerContent I'm pulling together a list of YTD offers. I am finding records where the candidate has ac…Rosenerie Castillo 32 views 7 comments 2 points Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI) -
Lost Functionality in OTBI after PB 10.17Summary After taking PB 10.17, we saw that icons did not work in OTBI.Content We test after every monthly patch. What we found was that, after 10.17, we could no longer …Aaron Hager-17476 30 views 1 comment 1 point Most recent by Matthew Carothers-Johnson General Transactional Reporting (OTBI)
-
ORA-03113: end-of-file on communication channel error - Please HelpContent Hi All, In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are faci…User_KOLMZ 16 views 3 comments 3 points Most recent by Aman Jain-Oracle General Transactional Reporting (OTBI) -
Link OTBI Summary Report to BIP Detail ReportContent Hi all - we have a request to link report A to report B. Report A will be like a summary report - name, manager, person #, job title. Report B will have signific…Prudence K 59 views 5 comments 0 points Most recent by Prudence K General Transactional Reporting (OTBI) -
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 54 views 5 comments 1 point Most recent by AshishERPCloud General Transactional Reporting (OTBI) -
Reports Run CountContent Is there a way to find out how many times a report was run and who ran it? Like we may have 10 reports and want to find out which is the report that is used the …Neha_Takkar 23 views 2 comments 2 points Most recent by Julian Challenger-Oracle General Transactional Reporting (OTBI) -
Custom BI Webcat Reporting DutySummary Trying to hide seeded reporting folders and understand the updated options within 19DContent We are keen to have the option to hide seeded folders from users. Ch…Sian S 42 views 5 comments 2 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI)
-
BI Publisher CSV files or Reading from Content Server sourceSummary Reading files on the Content Server in BI PublisherContent Hello, I'm trying to create a report in BI Publisher that will read an external file as a data source.…Rob F 43 views 4 comments 0 points Most recent by user12182418 General Transactional Reporting (OTBI) -
OTBI Customer SurveyContent Oracle BI development is planning OTBI feature improvements. To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting …User720640-Oracle 19 views 0 comments 6 points Started by User720640-Oracle General Transactional Reporting (OTBI) -
Custom Sort - BIP PivotContent Hi - I have a pivot table I am using through BIP and I need to apply a custom sort to it. I added an Order By to the DM, but it's not applying that to the pivot,…Prudence K 21 views 1 comment 2 points Most recent by Julian Challenger-Oracle 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 64 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)
-
Trailing Spaces in OBIEESummary formatting questionContent Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish. I have a report where I need to cre…Joy Hanneman-161050 17 views 2 comments 1 point Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Require report output in A4 page layout.Summary Require report output in A4 page layout.Content We have report output format as PFD. We want report output in A4 page layout ,how we can achieve this in oracle f…Shashi_IST 19 views 1 comment 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
PDF output in IEContent Hi, We have created a custom report and rtf output. And the format is defaulted to PDF. When we are generating the output, Mozilla and chrome is giving the exact…Nivya Mathire 19 views 2 comments 0 points Most recent by Nivya Mathire General Transactional Reporting (OTBI) -
Setting relative dates in a filter for an OTBI AnalysisSummary In an OTBI Analysis is there a way to add into a relative date range into a filter?Content I need an Analysis with a filter to pick up dates within the last week…Tim Welsh 255 views 17 comments 3 points Most recent by Kamran Butt-161785 General Transactional Reporting (OTBI) -
BIP Failing With Error: oracle.xdo.servlet.data.DataException: Could not apply digital signatureSummary BIP Failing With Error: oracle.xdo.servlet.data.DataException: Could not apply digital signatureContent Hi, We have a requirement is to add digital signature to …User_MC37Q 32 views 1 comment 3 points Most recent by MandeepKGupta General Transactional Reporting (OTBI) -
Force Performance Tiles to show 0 versus No ResultsSummary Force Performance Tiles to show 0 versus No ResultsContent Is there a way to force a Performance Tile to show 0 versus the No Results message?Andy French 20 views 1 comment 0 points Most recent by Ankush Rode General Transactional Reporting (OTBI) -
Get privilege to issue logical SQL in OTBISummary As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log …Nathan CCC 23 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
Oracle report development methodologySummary Looking to see if there is a suggested report development methodology for use across Oracle reporting toolsContent Using HCM & ERP and wondering if there is a re…Christine Pritchard 40 views 4 comments 4 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
R13.19C Introducing OTBI Metadata Independent Mode Using BI Cloud Connector (BICC)Summary Opt in to use the OTBI Metadata Independent Extract Mode in BICC introduced in R13.19C.Content What is the Change? Starting in Release 13.19C, BICC will no longe…Rohan Lobo-Oracle 715 views 5 comments 7 points Most recent by Rohan Lobo-Oracle General Transactional Reporting (OTBI)