BI Publisher
Discussion List
-
BI Query to get Difference between Dates in numeric formatSummary We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.Content Here are more details - We need to calculate th… -
Disable Delete Option in Report FolderSummary Disable Delete Option in Report FolderContent Hello please help me for how to Disable Delete Option in Report Folder . Thanks MahgoubMahgoub S.Mohamed 80 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for ERP -
"Insert text item" field is extending up to end of frameSummary "Insert text item" field is extending up to end of frameContent Hi I created a BI Report in Cloud. In the heading section of the report, need to display the para…Rama Pedamallu-193980 32 views 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP
-
BIP Report: How can I make default output to open in ExcelSummary BIP Report: How can I make default output to open in ExcelContent Hi Gurus, I am new to reporting.. I have just created a BIP report and I want the default outpu…
-
Multiple selection for Enterprise Scheduler JobContent Hello, Is it possible to do a multiple selection for a parameter in Enterprise Scheduler Job ? We don't have seen option to do this, and we can't write like this…
-
EFF in Fusion ERPSummary EFF in Fusion ERPContent Hi All, What are EFF Flexfields in Fusion Financials and how to access them from OTBI subject areas and their tables. ThanksAmarnath Govindu 99 views 7 comments 1 point Most recent by Zlatko Alvir-Oracle Reporting and Analytics for ERP
-
HZ Classification ReferenceContent Hi Team, I'm looking for Classification Orginal System Referenc, If I join OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS and OWNER_TABLE_ID from HZ_ORIG_SYS_REFERENCES…
-
Is there a way to pass parameters to an Infolet?Summary Need to convert a report that passes a parameter into an infolet so I can easily share it with many users that are not familiar with running BI Publisher reports…Fede SD 142 views 9 comments 0 points Most recent by User_2025-01-22-19-56-59-022 Reporting and Analytics for ERP -
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…Mohak Kirtane 41 views 0 comments 0 points Most recent by Mohak Kirtane Reporting and Analytics for ERP
-
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…Nageshwaran1 968 views 3 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
OTBI Dashboard Prompts are not visible in Google Chrome BrowserSummary OTBI Dashboard Prompts are not visible in Google Chrome BrowserContent Hi All, When we open OTBI dashboards in google chrome ( Version: 80.0.3987.149), the dashb…Siva Kumar-Oracle 42 views 4 comments 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for ERP -
How to add one day to the PaymentDate in XSL Template?Summary Need to add one day to the PaymentDateContent I am trying to customize XSL Stylesheet (HTML/XML/Text) tempalte, My requirement is add one day to the payment date…OraFusionworld 57 views 0 comments 2 points Most recent by OraFusionworld Reporting and Analytics for ERP
-
Supplier address withholding tax tableSummary Supplier address withholding tax tableContent Hi, Which view contain the Withholding Tax Exemptions details and how to connect it with POZ_SUPPLIER_ADDRESS_V vie…Shlomo Elnekave 56 views 8 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
What is the limitation for BIP output to SFTPSummary What is the limitation for BIP output to SFTPContent Hi Team, What is the file size limitation to send the BIP output file from BIP server to SFTP. Thanks in Adv…ArunKumarDammalli 162 views 1 comment 1 point Most recent by Médéric Chauvin Reporting and Analytics for ERP
-
How to send BIP output to SFTP in Zip formetSummary How to send BIP output to SFTP in Zip formetContent Hi Team, We have a requirement to Send the BIP report output in ZIP to SFTP. is there any way to achive this?…ArunKumarDammalli 70 views 1 comment 3 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Calculation Between two Presentation Analysis ReportSummary Calculation Between two Presentation Analysis ReportContent Hello i have two analysis report in BI Publisher one for Revenue and other for Cost of good sold i ne…Mahgoub S.Mohamed 32 views 7 comments 0 points Most recent by Mahgoub S.Mohamed Reporting and Analytics for ERP
-
BI Publisher - looking for project status tableContent Hi, Does anyone know where I can find a table that holds the history data for a Project Change status? On the front end the popup appears on our Manage Financial…
-
Misaligned columns and lines in reportSummary When published in Excel, reports lines and columns are misalignedContent Hello everyone, Sorry if this topic was already created before (I didn't find it), but I…User_2025-03-28-01-07-13-341 43 views 8 comments 2 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 82 views 2 comments 1 point Most recent by User_2025-02-04-13-08-33-519 Reporting and Analytics for ERP -
Subledger job inquiry for up to date reportingSummary Subledger job inquiry for up to date reportingContent We are just starting to develop reports in BI/OTBI Oracle Fusion as a newer client. We've previously only m…User_2025-02-04-18-03-15-131 39 views 3 comments 1 point Most recent by User_2025-02-04-18-03-15-131 Reporting and Analytics for ERP
-
How to extract all project parties via a report?Summary Looking for a way to extract all project parties information via an analytics or bi publisher report.Content In the Project Financial Management web page, throug…J.C. AUF 69 views 1 comment 0 points Most recent by Meredith Bickell Reporting and Analytics for ERP -
Scheduling Cash to GL Recon BI Publisher ReportSummary Has anyone had any success with scheduling the Cash to GL Reconciliation BI Publisher Report?Content We have a request from business users to schedule this repor…
-
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…User_2025-02-04-18-47-46-124 99 views 3 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
rtf template - summarize column within groupSummary rtf template - summarize column within groupContent Hi, I created simple table ( see attached files ) and i want the column values to be presented on one row. wh…Shlomo Elnekave 39 views 5 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP
-
Carriage Return in scheduled jobSummary Manual run of report has no Carriage return - scheduled run of job does - Tab delimited file.Content Hi all, Has anyone seen this behavior and overcome it? we ar…User_2025-02-04-12-06-59-807 24 views 5 comments 0 points Most recent by Patricia Gonzalez Reporting and Analytics for ERP
-
Drill down GL to subledgerSummary Drill down GL to subledgerContent Hi all, Is there any standard OTBI reports to drill from GL to subledger like AP and AR? or not possible customize is the work …User_2025-02-04-05-26-22-197 144 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197 Reporting and Analytics for ERP
-
Lookup Details from Subject AreaSummary Custom Lookup Details from Subject AreaContent Is it possible to fetch any custom lookup information from any Subject Area? The use case is like below: An analys…
-
Positive Pay Template ConfigurationSummary I'm looking for detailed instructions for how to break down and configure a positive pay template.Content By and large I'm looking for a guide for setting up a P…David Rabalais 42 views 7 comments 0 points Most recent by Glen Ryen Reporting and Analytics for ERP -
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…User_2025-02-05-07-37-39-271 46 views 10 comments 2 points Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP
-
BIP PO rtf Template archive querySummary Displaying the Line Level Notes to Supplier in the PO Template in BIPContent Hi, I have a requirement to display "Notes to Supplier" field on to PO rtf Template …User_2025-02-05-10-39-37-202 38 views 8 comments 1 point Most recent by User_2025-02-05-10-39-37-202 Reporting and Analytics for ERP