BI Publisher Reports
Discussion List
-
BI Publisher Service UnavailableWe are getting the message 'Service Unavailable' when attempting to access BI Publisher. All our automated reports are also impacted by this. They are not being sent. -
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 53 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM
-
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
BIP report to get the ESS job error details based on process idSummary: Hi Experts Does anybody have a BIP report sql query to get the details of error ESS process encounters in fusion post running the ESS scheduled process . Please…shaikh123 77 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsNeed SQL query or table details in Oracle Fusion when item structures are loaded in reference orgsDhilip Kumar P. 5 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 215 views 9 comments 0 points Most recent by Chandramouli Potnuru Reporting and Analytics for SCM -
Query to get Receipt Accounting Transaction StatusHi Team, Please let me know from where we can get the Receipt Accounting - Transaction status column from backend. ( Navigation - Supply chain execution → Receipt accoun…
-
Report header columns are missing when there is more than 65536 rowsReport header columns are missing when there is more than 65536 rows and the data is splitting into different sheets. The sheet numbers are also going from Sheet1 to She… -
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 46 views 2 comments 0 points Most recent by BalaKadapa Reporting and Analytics for SCM
-
Report is ending in errorWe have a custom BI report related to Inventort module. The report generates excel output and the file size can be of 100 MB or more. When we run the report for multiple…KabirB 29 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 659 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for SCM
-
https://CloudUrl:443/xmlpserver/services/ExternalReportWSSService' failed:Timeout exceeded.Summary: We have custom BI Report data model and layout. we trigger BI report using https://iaxgqy-dev1.fa.ocs.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSS…sasi 149 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Issue creating RTF Template using Non-standard SQL Data ModelSummary: Issue creating RTF Template using Non-standard SQL Data Model Content (please ensure you mask any confidential information): I have created a new Data Model in …
-
Need to validate why the value is differing from ERP in TableHi, At the table level, for item SU103216, we are seeing the inverse usage rate value as 1000000000, with a last update timestamp of 2025-05-19T10:33:22.169+00:00. Howev…
-
Need a query to get details in manage project costs -> view accounting detailsSummary: I need to add the GL Account column from manage project costs -> view accounting details UI. This data can be found by going into the transaction and going to A…
-
Print ZPL labelsSummary Print ZPL labelsContent Hi, We have a requirement to print ZPL labels on non-local Zebra printers. The availability and configuration of a Zebra printer (using a…Fabricio Reis 116 views 3 comments 0 points Most recent by User_2F7TP Reporting and Analytics for SCM
-
Not able to get any Data from the table INV_MIN_MAX_GTSummary: Not able to get any Data from the table INV_MIN_MAX_GT. Do we need any specific roles or data access for that Content (please ensure you mask any confidential i…Chaitra Kayi-Oracle 53 views 5 comments 0 points Most recent by Maalavica Reporting and Analytics for SCM
-
How can I use the item keyword as a parameter in a BI Publisher reportSummary: I want to allow users to search the BI Publisher report by any word within the item description. Currently, the parameter for item description limits LOV to 30 …
-
LOV Parameter Disabled When Using Full Item DescriptionSummary: I'm working on a BI Publisher report in Oracle Fusion where I want to use item description as a parameter. The parameter is based on a List of Values (LOV) from…
-
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…
-
I am trying to connect this table cst_layer_costs unit_cost with this table INV_MATERIAL_TXNSSummary: I am doing transaction stock movement report I am struggle with unit_cost column which I am taking the column from this table cst_layer_costs try to connect it …Khalid Aldosari-Oracle 121 views 2 comments 0 points Most recent by Walter Spinelli Reporting and Analytics for SCM
-
Scheduled BIP Report not Working post update to Recipients listSummary: A BIP report Scheduled to run once a week, made changes to the recipients list and observed the changes were not reflected in the next run, means recipient's li… -
Issue with HTML Tags in Excel Output from Oracle Fusion BIP ReportWe are encountering an issue in Oracle Fusion where HTML tags are appearing in the Excel output of a BIP report. This problem was observed during the creation of an RFQ …Venkatesh Babu Somalinga 30 views 2 comments 0 points Most recent by Venkatesh Babu Somalinga Reporting and Analytics for SCM
-
Unable to find PartySiteID received in EDI850 payload in backend CML Log tables for CMK Errors.We have a requirement to display the 'PartySiteId' and 'AccountSiteUseId' fields—present in the Purchase Order Inbound EDI payload—in the Custom EDI850 Error Report when…Manish Maheshwari 21 views 2 comments 0 points Most recent by Manish Maheshwari Reporting and Analytics for SCM
-
Print Commercial Invoice is ending up with retrying status.Hi All, We have a custom role and with privilege assigned print shipping reports. When i'm trying to run the Print commercial invoice, it is ending up retrying status. I…KSowmya 44 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Help Needed: Average Costing Logic – How to Carry Forward Updated Unit CostHi, I have a requirement to calculate the updated unit cost using the following formula and use the resulting value as the current unit cost for the next transaction row…RiyaKaushal123 14 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Need a SQL query to get all the transactions involving a specific serial number in Oracle FusionI need a SQL query to trace all the transactions for a specific item serial number involved in Oracle Fusion.Krishan_Palihakkara 617 views 8 comments 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for SCM
-
What tables stores fixed choice list dependency created using application composerSummary: A custom application was created using Application Composer. A fixed choice list field was set up to depend on another fixed choice list. However, the selected …
-
How to apply modifications to the Redwood Oracle Analytics Publisher template?Summary: We have been using a customized template for Requisition Approval Notifications. As per Oracle documentation, starting from 25A, businesses are required to reap…Vikrant Bhardwaj-Oracle 51 views 1 comment 0 points Most recent by Vikrant Bhardwaj-Oracle Reporting and Analytics for SCM
-
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 52 views 4 comments 0 points Most recent by Shamsul_Wzd Reporting and Analytics for SCM