General Transactional Reporting (OTBI)
Discussion List
-
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 … -
Can we have a Date Type Parameter as a Presentation Variable ?Summary Date Type Parameter as Presentation Variable in Fusion OTBI Reports?Content HI Friends, Any idea how can we get the above requirement ? -
BI Report Output Formatting Options based on Security RolesContent Hi, I understand it is possible to specify the report output options at the time of report design, however I wanted to ask if we can do a conditional login on th…
-
Remove line feed from OTBI ReportSummary Remove line feed from OTBI ReportContent Hi all Is there any way to remove line feed and carriage return from text columns in OTBI report? I tried to define a ne…
-
Exceeded configured maximum number of allowed input recordsSummary Error message received when running reportContent Hi, could someone explain why I get the attached error? Many thanks, Antony.