Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
General Transactional Reporting (OTBI)
Discussion List
-
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 …
-
Attend The Premier Oracle Technology Conference—ODTUG Kscope20Summary Your ODTUG Kscope20 conference pass includes access to over 300+ technical sessions, all-day symposiums, lunch and learn panels with Oracle experts, and hands-on…
-
How to override NULL values with existing valuesSummary How to override null value with values from another column in OBIEE AnalysisContent When building an analysis in OBIEE, what would be the code to enter into the …
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…
-
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…
-
Suspended job reportSummary Suspended job reportContent Hi, I have a question about using a BIP job report: I have a job report that is scheduled to be sent every night if the day before so…
-
Building BOM using analysisSummary How to build a hierarchical BOM analysis showing on-hand quantity and item cost all for components in all levelsContent In OBIEE, pre-built analysis "BOM" and "W…
-
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…
-
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…
-
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 …
-
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…
-
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…
-
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…
-
Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?Summary Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?Content Hi Experts, I hope that most of you who have worked on an On-Premise syste…
-
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 …
-
Sharing OTBI AnalysesSummary Need guidance on how to share OTBI templates with other internal usersContent Hi all! I am new to Fusion and OTBI. I have searched Oracle Support and the Library…
-
BI Publisher, First Time Setup, Report ServerSummary I cannot find a clear guide to where I get the report server URL.Content The URL I tried it with is: https://podurl.fa.us2.oraclecloud.com:9704/xmlpserver/ I've …
-
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…
-
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.…
-
Java.sql.SQLException: Invalid column indexSummary Errors out with the mesaageContent Hello There, We are using Oracle Financials Cloud and BI Publisher. I have a simple WITH Clause sql construct. On execution it…
-
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 …
-
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,…
-
Excel report is grey and no data is visibleSummary When generating an Excel with BI Publisher the file is grey and no data is visible.Content After generating an Excel file with the BI Publisher the sheet is grey…
-
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 …
-
Convert Date FieldSummary Convert from MM/DD/YYYY to YYYY-QxContent Hello, I have a date field I want to convert. I want to convert that from MM/DD/YYY to "YYYY-Qx". Any thoughts on how t…
-
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…
-
Data Model ParametersSummary Data Model ParametersContent I am building a data model for an RTF letter using ‘Oracle BI EE’ as the Data Source. The data model requires parameters but when I …
-
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…
-
BI Cloud Connector support custom offerings for extract?Content Looking into using the BI Cloud Connector(BICC) for extraction of data sets for integration with our E-Business Suite custom product. The BI Cloud Connector offe…
-
Future Dated ActivitiesSummary Show me only the Opportunities that don't have a future dated activity addedContent Hello, I'm struggling to think through how to do this. Here is the business p…