OBIEE
Discussion List
-
How to reduce execution timeHi, I have developed a report to fetch the Beginning balance and Monthly balance based on the source & category. So I have written two SQL statements with Union clauses.…Madhu A 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How to fetch audit logs for custom reports in analyticsHi All, Can we generate audit logs for the custom reports which are created in reports and analytics. Like, can we get the data of a custom report which we have created,…Nalsoft Pvt Ltd 21 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
-
Inconsistent report bahavior with error ORA-56733: logical I/O limit exceeded - call abortedHello, We have a BIP report which is a customized version of the Account Analysis report. In this report, we have added sub-queries to have the reconiciliation details i…Kristelle 225 views 5 comments 2 points Most recent by Abhilash K - Deloitte USI Reporting & Analytics for Fusion Service
-
Unable to get WCC server[servername] SecurityGroups DetailsThere is an existing scheduled report job that uploads the csv report to CS. When I check it gets the error "Unable to get WCC server[servername] SecurityGroups Details"…ChrisSSS 51 views 1 comment 0 points Most recent by ChrisSSS Reporting & Analytics for Fusion Service
-
Load Data from FAH(fusion Accounting Hub) to FAW, need more details?Summary: Data load from Fusion Accounting Hub(FAH -Fusion Applications) to FAW(Fusion Analytics warehouse) Content (please ensure you mask any confidential information):…NsanthoshK 41 views 2 comments 0 points Most recent by NsanthoshK Reporting & Analytics for Fusion Service
-
Legal Disclaimer check box field under the External Career Site cannot be obtained from the reportThe Legal Disclaimer or Privacy Statement column under the Recruiting Career Site cannot be obtained from the BIP and OTBI report. We would like to ask for your help bec…
-
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d…kalyan gade 483 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting & Analytics for Fusion Service
-
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.Mohammad Borghol 73 views 3 comments 0 points Most recent by Muhammad Asif R Reporting & Analytics for Fusion Service
-
How to print space between currency symbol and priceHi, I have added the below formula in the rtf template to display the price along with the price currency code. Formula: Output $50 UNIT_PRICE & INVOICE_CURRENCY_CODE d…AVN 11 views 1 comment 0 points Most recent by mai fukumura-support-Oracle Reporting & Analytics for Fusion Service
-
How to add new table extract in BICCSummary: Hi Experts, We noticed some tables are missing in BICC console and below table is an example. May i know if there is a way to extract the missing tables using B…Sudheer YN 41 views 7 comments 1 point Most recent by Sudheer YN Reporting & Analytics for Fusion Service
-
Checklist LetterWe have configured a letter through checklist task and same will be store in DOR after acknowledging, employee has to generate the letter then acknowledge it then the le…Satyam Roy 21 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Cannot find table in Oracle BIP that stores the Organization (Department) of usersHi all, In order to complete a movement Request report, I am required to include the Department of the user that created the movement request. I have not yet been able t…Mariyam129 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Is there way we can get the "Import Asset and Assignments Process" import errors detailswhen we run the "Import Asset and Assignments Process" to import the Capital assets the load interface file import success and errored at import job and we are trying to…Saadiq 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Fusion Application is not providing any data for Document of RecordsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Rohan Fernando 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How to add a specific offering to BIACM extract in Fusion?Hello all, I am unable to locate and add the below data store. FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrRcvEventsExtractPVO Can you please help? ThanksEarth place 1 view 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
BIP report parameter is not working as expectedSummary: Hi All, For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it …AKV27 13 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
Oracle BI Catalog ReorganizationWe are planning a reorganisation of the Oracle BI Catalog folder structures and will much appreciate knowing about any standard processes or best practices that are in p…ks1075 11 views 2 comments 1 point Most recent by Clare Murtagh Reporting & Analytics for Fusion Service
-
how to display latest message in reportSummary: We are building a Service Request Dashboard , in that want to display the messages also. When we combine the SR subject Area and SR Messages Subject are , it is…Anusha716 21 views 1 comment 0 points Most recent by Clare Murtagh Reporting & Analytics for Fusion Service
-
How to generate ESS Job output in multiple formatsHi, We have a requirement to send the output to the customer. We are able to send the output in PDF format without any issue. However; customer is looking for both PDF &…Madhu A 81 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
-
Not able to print columns in the rtf templateHi, I am trying to customize one of the seeded reports to add additional columns. I have added additional columns in the data model by creating a new group and establish…Madhu A 11 views 2 comments 0 points Most recent by Madhu A Reporting & Analytics for Fusion Service
-
BI report Webservice Data ModelWe are using web service Private Data source in Data Model, to call Oracle Integration cloud Web service. Please confirm will this feature be deprecated in future or wil…Vignesh Thangavel 2 views 2 comments 0 points Most recent by Vignesh Thangavel BI Publisher Learning Center
-
SQL to get employees and their dependents enrolled in a benefit planLooking for "SQL to get employees and their dependents enrolled in a benefit plan" to build BIP Report.B S Rafatullah-Oracle 147 views 2 comments 0 points Most recent by Unknown Reporting & Analytics for Fusion Service -
Bi Publisher CSV output IssueSummary: Bi Publisher CSV Output Issue displaying all the fields in the output Content (required): Requirement is to display all the fields from the data model output of…kalyan gade 51 views 4 comments 0 points Most recent by kalyan gade Reporting & Analytics for Fusion Service
-
Questions on BICCSummary: Questions on BICC Content (required): Hello Experts - We are planning to pull some of the entities from Oracle ERP Cloud to our external DW tables for reporting…Sanin Antony T 81 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting & Analytics for Fusion Service -
Omni Channel - Events ReportSummary: Omni Channel - Events Report Content (required): 1. Omni Service Request and Queue Assignment performance Tile This report would help SR admin to know what is t…Venkataraman Ramakrishnan-Oracle 31 views 0 comments 0 points Started by Venkataraman Ramakrishnan-Oracle Reporting & Analytics for Fusion Service
-
Sample Daily Digest for Agents - Unassigned and My Open TicketsSummary Daily digest report ready for subscribable agent to inform agent of open tickets currently assigned to them or unassigned but in their queueContent Our agents wo…Josh Vincent 60 views 2 comments 1 point Most recent by Josh Vincent Reporting & Analytics for Fusion Service -
Application table for standard coverage under subscription managementSummary Need to query coverage details under subscription management using data modelContent Subscription Management -> Standard Coverage - > (Template details) what is …ViswanathaReddyKetireddy 45 views 1 comment 0 points Most recent by Justin Anderson-Oracle Reporting & Analytics for Fusion Service
-
BIP BurstingSummary BIP BurstingContent Hi, I have a requirement to send report output to different owners with the email attribute in the table. Here is what I did, 1. Create a BIP…Adam Liu 106 views 2 comments 3 points Most recent by User_KM4LK Reporting & Analytics for Fusion Service