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
-
Column Properties InteractionSummary Primary Interaction = None but hyperlink still showing in the valueContent Hello, I have a report where I've set the "Primary Interaction" on the 'Value' to "Non… -
NACHA format filesSummary NACHA format filesContent Can we create NACHA format files using BI Publisher template builder in Cloud? Any documentation for creating the same will be helpful.… -
BI publisher template builderSummary Can we create fixed format files using BI publisher template builder?
-
Phone screens completedSummary Looking to add the number of phone screens completed to reportContent I have a current report that I am needing to add the number of phone screens that have been… -
Case When for date fieldsSummary Case when date is lesser than or equal to another date, THEN "on time", ELSE, "Not on time"Content I'm trying to build a Case statement that shows If one date is…
-
Is it Possible to Use an Alias for the Bursting Sender Info?Summary Is it Possible to Use an Alias for the Bursting Sender Info?Content We engaged a vendor to write some BI Publisher reports, which use bursting to send out emails… -
archive unarchive and oracle bi admin roleSummary archive unarchive and oracle bi admin roleContent Hi, in Oracle BI is it possible to get archive/unarchive functionality and not be an oracle bi admin? Our tech … -
Missing Folder in OBISummary Is there a way to recover missing folder in BI.Content We have a folder Analytic Library that is missing in our production environment. I can see it in our PTFDe… -
Dynamic Report layouts in BI PublisherSummary Dynamic Report layouts in BI PublisherContent We have a requirement from a client where from the prompts, if we select any attributes you report layout has to sh…
-
BI Mobile HD AppsSummary OTBI reports in BI Mobile AppContent We would like to view reports created in OTBI from within BI Mobile HD app. What steps need to be taken to have the OTBI cre…
-
create analysis from direct db querySummary how to created direct db queryContent Hi Is there a way to create an analysis from direct database query. I tried the option but cannot get it to work. is there …
-
Prompt Dashboard for cross subject areasSummary Prompt Dashboard for cross subject areasContent Hello, I have an analysis made by two subject areas (linked by an INNER JOIN) and the system puts "saw" alias in …
-
OTBI Action Link Not working for union report-Finance ModuleSummary OTBI Action Link Not working for union report-Finance ModuleContent Hi, I am using "Receivables - Transactions Real Time" and "Receivables - Receipts Details Rea…
-
Complex filters - grouping 3 filters togetherContent I want to create a complex filter which requires grouping 3 filters with another set of filters. I have played around clicking the AND / OR to get the combinatio…
-
Dashboard Custom Print and Export design in 12CSummary Any resources that give detailed instructions on how to design a custom print layout?Content Hello, I have stumbled across a 'Custom Print and Export Layouts' fe…
-
How To Add Descriptive Flexfield To Fusion Transactional Business Intelligence (OTBI)Content Hi, I have did these steps Sequentially 1-From Manage Descriptive Flexfields page i have checked the [BI Enabled] flag . 2-Deployed the Flexfield . 3- Run these …
-
OTBI Pivot Table TopN functionContent Hi, can someone provide some quidance on restricting pivot table results (and associated chart) to the Top 10 results based on Nationality by Person Count. Thank…
-
Working with Agents - OTBI - Help neededSummary I've setup an agent to deliver a report via E-mail... I tried everything but report is being delivered with no results\:Content Hi, I've setup an agent to delive…
-
Read Only Access to OBTI for usersSummary Read Only Access to OBTI for usersContent How can we restrict users not to change the reports layout in OTBI, currently they have teh access and they can have th… -
not able to divide two columns RTF TemplateContent we are trying to divide two columns but its not working.we are using the below code. DIV
-
Scheduling Agent with PromptSummary Scheduling Agent with PromptContent I have a report that has a facility filter prompt built into it. I've created several scheduling agents based on this report …
-
Decimals not appearing on excel export when run through agentSummary Decimals not appearing on excel export when run through agentContent I have some reports that I have created a scheduling agent to automatically run and email to… -
Contract Changes in HCM CloudSummary How to handle changes to contract using HCM CloudContent Hi, We are using HCM Cloud and one of our areas we are falling down on is changes to peoples contracts I…
-
Dashboard configurationSummary Recommendation for what to configure the width of a dashboardContent Hello, I am in the processing of building a dashboard and I am running into an issue with fo… -
OTBI sessionsSummary How do I differentiate OTBI sessionsContent I am wondering if like the HCM landing page background, we can color codde OTBI environment so I don't accidently mak… -
Oracle BI Publisher - Report on Report Job HistorySummary Find a way to acquire all Report Job History listed and extract all data to ExcelContent Hi, I used to be an Apps DBA\Technical application Support on R12 EBS ba… -
Dynamically place the custom logo in BIP reports in Fusion CloudSummary Dynamically place the custom logo in BIP reports in Fusion CloudContent Hi, We need to developed few custom reports as per the requirements. In this implementati…
-
Packages in BI publisherSummary Packages in BI publisherContent Dears , I am migrating some reports from EBS R12 into oracle cloud fusion . some of these reports SQL query contains standard pac…
-
mapping between EBS tables and oracle fusion cloud tablesSummary mapping between EBS tables and oracle fusion cloud tablesContent Hi Team , as the schema changed from EBS to oracle fusion cloud so Is there any document that ma…
-
Formatting Totals RowSummary Formatting Totals RowContent I have a report that I used the aggregation rule (totals row) to calculate the sum or average of the entire column upon running the …