BI Publisher
Discussion List
-
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 32 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 39 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 362 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 -
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 -
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 73 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Curiosity Question_Excel BI Templates NamingContent Good morning! I wanted to reach out to see if anyone has run into the error below when trying to preview data in an Excel template. I am running Excel M365 and a…User_2025-02-10-17-54-21-557 17 views 0 comments 0 points Most recent by User_2025-02-10-17-54-21-557 Reporting and Analytics for ERP
-
Accounts Receivables Month end closing in Cloud 20 ASummary Accounts Receivables Month end closing in Cloud 20 AContent We want to close AR month end closing in Cloud 20A. I developed a query from AR tables withe invoice …Rama Pedamallu-193980 63 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Use subject area tile missing for create reportContent Hello, Financial Analyst and Accounts Payable Manager do not have the excel or Use Subject Matter tiles when creating reports. Am I missing a role, as the implem…
-
Release 21BSummary xsl template for ACHContent Hi All, Did anyone worked on the Payables payment process with ACH template with xsl type in 21b.? need inputs on how to develop ACH …
-
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …Sushan Peiris 1.1K views 3 comments 3 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for ERP
-
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…Sushan Peiris 1.9K views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…User_5F4G3 503 views 10 comments 0 points Most recent by User_2025-02-11-18-46-39-346 Reporting and Analytics for ERP
-
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh…Abhilash K - Deloitte USI 50 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …Himanshu245 320 views 2 comments 1 point Most recent by Matt Luscombe Reporting and Analytics for ERP
-
Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORYContent Hi, We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFR…Bhavik Shah 3K views 4 comments 3 points Most recent by Deepak Anand Reporting and Analytics for ERP -
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking …Dhruvjoshi23 15 views 0 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR AgContent Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR Aging report from scratch but lot of logic is hidden in stored … -
How to give an access to specific users to custom ess jobSummary How to give an access to specific users to custom ess jobContent Hello All, We have one custom report and we have created a ess job to it and now wats to give an…Koteswararao Yenikepalli 43 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
BI Parameter IssueSummary ORA-01795: maximum number of expressions in a list is 1000Content I have a BI Publisher report with a parameter that gets its list of values from a sql query. If…Lydia Jayasingh 184 views 6 comments 4 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP