BI Publisher
Discussion List
-
OTBI Dashboard - Drilldown FunctionalitySummary OTBI Dashboard - Drilldown FunctionalityContent Can anyone provide me with guidance on the exact URL that should be used with OTBI dashboard to drill down from O…Stacee Patterson 160 views 2 comments 0 points Most recent by Angela.Ahrens Reporting and Analytics for ERP -
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…John Mulvihill 37 views 1 comment 0 points Most recent by Vishnu Singireddy-69744 Reporting and Analytics for ERP
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy -
Cost Center DescriptionSummary Link from GL_CODE_COMBINATIONS table to Cost Center DescriptionContent Using BI Publisher I need to get from the GL_CODE_COMBINATIONS Table to a Table which cont…
-
GST Report for SingaporeSummary Anyone has built GST report for Sinagpore country?Content Anyone has built GST report for Singapore where output is bifurcated as per the tax rate and tax type c…
-
BIP Report Output To Content ServerSummary Need to burst BIP Report Output to Content ServerContent Hi As per the oracle doc, I need to add a content server by navigating to Administrator--> Manage BIP --… -
Filtering Issue on Data ModelSummary The results of the data model are not being filteredContent we are trying to create a simple data model with a variable. But the data is not being filtered as pe…
-
How to extract Registration Number on OTBI?Content Hi I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'Firs… -
Fusion POD name in rtf template -- AP Check PrintingSummary How to get Fusion POD name in rtf template -- AP Check PrintingContent Is it possible to refer the fusion pod name in check template. We would like to watermark …Saravanan Thirunavukkarasu-26616 81 views 3 comments 1 point Most recent by Jairo Reporting and Analytics for ERP
-
eText Header RecordSummary I need to create a header record in an fixed position eText Template.Content I need to create a header record in an fixed position eText Template. Which contains…
-
How to hide the reports icon from the vertical bar on the performance documentContent Hi, We have created a couple of dashboards using performance real time subject areas. Have personalized the home page to provide the link for these dashboards. T…
-
ERP - LAG / AGING reportSummary I need to create a LAG / Aging report and was hoping there's a report I could use as a starter.Content Not sure how the forums work as it's my first time here. A…
-
Release 11 Data Lineage Guide for FSCM (Financials, Projects, Supply Chain)Summary The Data Lineage Guide provides a mapping of the BI Subject Area columns to source data base tables and columns. It also has the View Object (VO) names for each …
-
Using My Oracle Support (MOS) site as an OTBI Knowledge ResourceSummary Using 'search' box on MOS as additional resource to seek Reporting and Analytics answers/find documentsContent Many a time the issue you are encountering would a…
-
Customize a Trial Balance Report predefined by OracleSummary Add a new column with the Client description which their balances are included in the same account.Content Hello all, I don't know if there is an 'easy' way to c…
-
BI Publisher Reports - Default Email AddressSummary I would like to change the Current default email address which currently is bipublisher-report@oracle.comContent When running BI Publisher reports and selecting …Angelo Cretella 51 views 4 comments 0 points Most recent by User_1B10X Reporting and Analytics for ERP -
Get the Code and Meaning from FND_LOOKUP_VALUES_TL for OTBI ReportingSummary Get the Code and Meaning from FND_LOOKUP_VALUES_TL for OTBI ReportingContent Hi All, We are trying to build an OTBI Analysis for Bank Transaction Codes. The Subj…Murali Gangidi 50 views 0 comments 2 points Most recent by Murali Gangidi Reporting and Analytics for ERP
-
MddsException when trying to consume a WebService from Oracle Cloud BISummary MddsException when trying to consume a custom WebService from Oracle Cloud BIContent I have problem when trying to consume a WS I deployed on my Oracle WebLogic …Jean Donaires 30 views 0 comments 0 points Most recent by Jean Donaires Reporting and Analytics for ERP -
How to hide the VIEW IMAGE Button in AR invoice screen in FusionSummary How to hide the VIEW IMAGE Button in AR invoice screen in FusionContent Hi Team, Is there a possibility to hide the VIEW IMAGE Button in AR invoice screen in Fus…User_1B10X 133 views 6 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
Subject Area in Account Paybles to get information for OTBI from AP_PAYMENT_TEMPLATES tableSummary Subject Area in Account Paybles to get information for OTBI from AP_PAYMENT_TEMPLATES tableContent Hi All, I need to pull the Template Name and Template Descript…Murali Gangidi 42 views 4 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
SUBSTRING based on non-numeric character in the expression (OTBI Analysis)Summary SUBSTRING based on non-numeric character in the expression for OTBI ReportContent Hi All, I have a requirement in OTBI Report, to get the 20 characters after the…Murali Gangidi 282 views 4 comments 0 points Most recent by Murali Gangidi Reporting and Analytics for ERP
-
Self Service Reporting -- Home PageSummary Want to explore the option of self service reporting for the business user.Content Hi All, I want to explore the option of self service reporting for the busines…Amarnath Govindu 70 views 2 comments 0 points Most recent by Amarnath Govindu Reporting and Analytics for ERP
-
Unarchive error message: Error saving security accountSummary Error saving security accountContent When I Try to Unarchive a catalog in BI publisher, I'm getting the error message "Error saving security account" -
How to Calculate MTD and YTD in Oracle BI Analysis ReportsSummary How to Calculate MTD and YTD in Oracle BI Analysis Reports using Project Costing Actual Costs Real Time and Project Control Budgets Real TimeContent Hi, I am try…Avesh Ganodwala-57885 241 views 2 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
Add Account Parmeter to Custom BI Puslisher ReportContent Hi Friends, I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create paramet…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…
-
How to rename the Worksheet name from Sheet1 to ?Summary Sheet1 to Content Good People, We are using the guided template for the BIP report and exporting it to Excel. When its exported the File Name appears correctly w…Soumya Prakash Parhi 163 views 2 comments 3 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Difference Between using /analytics and /xmlpserver?Summary What are the major differences in using OBIEE and BI Publisher?Content Had an issue recently wherein a folder was hidden and it was preventing me from customizin…Juan Miguel Isip-94819 331 views 5 comments 0 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
German Characters are displayed as Junk.Summary German Characters are displayed as Junk.Content Hi All, We do have a Custom BIP Report to send the extract to External System. When we submitted the report manua…Uvaraja-Oracle 38 views 0 comments 0 points Most recent by Uvaraja-Oracle Reporting and Analytics for ERP
-
Hide Operator (is LIKE (pattern match)) from dashboard promptSummary How to hide operator (is LIKE (pattern match)) appearing on Dashboard PromptContent Hi Experts, I have a requirement in my report to just show the heading and hi…