BI Publisher
Discussion List
-
How to check/download the BI report output submitted by usersSummary: Content (required): This is from Support User perspective. If a user opens a report from BI Catalog, runs it, and downloads the output, then how can we check/do…Vinay Gharge 21 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Mismatch in ZX_LINES and Manage Tax Details in Invoice PageSummary: Hi All, We are trying to create a report to fetch invoices with tax point basis as "ACCOUNTING". When we try to open the invoice result in front end it shows th…Siva Kumar-Oracle 31 views 0 comments 0 points Started by Siva Kumar-Oracle Reporting and Analytics for ERP -
BI Publisher RTF Template AR Invoice : Grouping rowsContent I am required to create an AR Invoice report, where services are needed to be grouped based on what kind of service they are within a report. To be more clear, f…
-
SQL to query current BI Agents scheduled to e-mail / dashboard page etcSummary: I have written an sql query to extract all BIP reports currently scheduled, but want to do the equivalent with OTBI BI Agents - is it possible using sql and acc…User_2025-02-10-15-12-48-631 132 views 5 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Report Error: ORA-01438: value larger than specified precision allowed for this columnSummary: Hey, I am running a custom report in BI Enterprise and keep getting the error below. The report is failing for only a few circumstances and am able to run it fo…User_2025-02-10-17-54-21-557 91 views 3 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Dynamic Pivot column in BI PublisherSummary Need the column of a pivot table to be dynamic in BI PublisherContent We have a requirement to display GL balances by BU hierachy and period. As the users can ru…saravana maneeian subhramaniun 65 views 1 comment 2 points Most recent by User_7836 Reporting and Analytics for ERP
-
Bursting feature in BI PublisherSummary Burst contents to email body than attachmentContent Hi - I have a requirement to send Dunning letters in BIP but the contents should be in the email body rather …
-
Best Practices to load high volume dataSummary Best Practices to load high volume dataContent Hello All,We are working on a project in which we may get high volume data to be loaded through FBDI. Based on you…Lucky Sharma 52 views 3 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Oracle Fusion Financials - custom version of standard BI Publisher reportSummary Oracle Fusion Financials - custom version of standard BI Publisher reportContent I am following this guide; - https://docs.oracle.com/en/cloud/saas/financials/21…User_2025-02-10-15-12-48-631 38 views 6 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human CaSummary 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications'taskContent Hi Team…Rohit Kumar Singh 29 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 1.1K views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…Sushan Peiris 159 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…Sushan Peiris 341 views 3 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Post report Completion event for External SystemsSummary Post report Completion event for External SystemsContent Hi, There is a scenario wherein client needs an event once the report is completed successfully, an even…Kaushal Gathani 21 views 2 comments 1 point Most recent by User_3EZDP Reporting and Analytics for ERP
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to filter BI Report PARAMETER for COA Segment Values based on the security rules defined …Vinay Gharge 25 views 0 comments 1 point Most recent by Vinay Gharge Reporting and Analytics for ERP
-
Oracle ERP > Procurement> Self Service Receipts tables to query for a reportSummary Self Service Receipts tables to query for a reportContent Hello Community, I am new to the topic, and I am trying to generate a report on Oracle Fusion ERP based…Robinson Antunez 49 views 3 comments 0 points Most recent by Robinson Antunez Reporting and Analytics for ERP
-
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece…Mike Burnett 43 views 10 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Passing a Dashboard Variable to all BI reports on dashboardSummary Passing a Dashboard Variable to all BI reports on dashboardContent Hi All, I am preparing a dashboard to show multiple charts / reports embedded. I would like to…
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 23 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for ERP
-
Oracle Procurement withholding tax problem - sqlSummary Oracle Procurement withholding tax problem - sql - see no tax code at line location, but populated norec / rec tax at distribution levelContent Hi, this is a sql…User_2025-02-10-15-12-48-631 15 views 0 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Reporting and Analytics for ERP
-
How Can we import Gl Balances from legacy to Oracle Fusion?Summary How Can we import Gl Balances from legacy to Oracle Fusion?Content Hello All, Can you please let me know what are the ways to import GL account Opening Balances …
-
Source Safe - Oracle Fusion BIPSummary Source Safe - Oracle Fusion BIPContent Hi, Can you please guide me on how to and best tools for setting up Source Safe for Oracle Fusion BIP (ERP/HCM), as we wou…Rakesh Sreenivasa 26 views 0 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP
-
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…Sushan Peiris 38 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
What is the best way to identify whether the current Fusion instance is PROD or Non-PRODSummary What is the best way to identify whether the current Fusion instance is PROD or Non-PRODContent As we need to transfer BIP Reports to different FTP file servers …Umamaheswara Reddy Karri 41 views 9 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv…
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 47 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 361 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How can I Remove Create/Catalog for some usersSummary How can I Remove Create/Catalog for some usersContent How can I Remove Create/Catalog for some users, because I need buttons enable specific usersMurilo Damasceno 44 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.User_DDXB9 68 views 10 comments 2 points Most recent by Kevin Fehskens Reporting and Analytics for ERP
-
Passing comma seperated parameter values through SOAP requestSummary Passing comma seperated parameter values through SOAP requestContent I running a BI Publisher report through SOAP request. the BI Publisher data model contain th…Shlomo Elnekave 58 views 6 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP