BI Publisher Reports
Discussion List
-
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…Rohit Kumar-266502 601 views 1 comment 0 points Most recent by Rohit Kumar-266502 Reporting and Analytics for SCM -
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 716 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 1.6K views 3 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 87 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
How to get full access (create data model and report) only on My Folders in PRODSummary How to get full access (create data model and report) only on My Folders in PRODContent Friends, We have a requirement to allow IT support people to create data …Umamaheswara Reddy Karri 45 views 3 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for SCM -
Fetch only new or updated data from Last runContent Hi All, I am very new to Reporting hence need help to devlop report to fetch only incremental data. Report Logic: 1) Report will be called by Webservice by passi…Mayank Pande 95 views 1 comment 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
Report 'Receipt Accrual Balances'Summary Report similar to 'Adjust Receipt Accrual Balances' menuContent We want a report that shows the same information as you can see in the 'Adjust Receipt Accrual Ba… -
How to deactivate BI Report Jobs during/right after P2TSummary Is it possible to deactivate report jobs during a P2T, avoiding the reports to be sent automatically right after the P2T is completed?Content Hello, Our customer…Murielle Manambelona-Oracle 36 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for SCM
-
How to find or differentiate Internal/External Drop shipmentsSummary How to find or differentiate Internal/External Drop shipmentsContent Can you please share the query for the Internal/External Drop shipments sales order? This wi…AnishRV 31 views 2 comments 0 points Most recent by Arunkumar S-Oracle Reporting and Analytics for SCM
-
Event Trigger not working with multiple selection and null value passedSummary Event Trigger not working with multiple selection and null value passedContent In bip report we using multiple selection and null value passed parameter type, fo…VarunMittal2005 60 views 4 comments 0 points Most recent by VarunMittal2005 Reporting and Analytics for SCM
-
Function in Formula Column like Report Builder(RDF)Summary Function in Formula Column like Report Builder(RDF)Content In BI Publisher do we have an option to build a function(PL/SQL) in the formula column. In RDF report …
-
Email is not going through burstingContent Hello Team, We are trying to burst the report output to email from BI publisher, but it is not working. When I schedule to report that has the bursting query to …Abhi_Kr 43 views 7 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
How to send the header information in email body and line information as attachment using Bursting?Summary How to send the header information in email body and line information as attachment using Bursting?Content Hello Team, I have a requirement where an email needs …
-
How to attach UCM document in email using bursting?Summary How to attach UCM document in email using bursting?Content Hello Team, I have a requirement where i need to attach an UCM document(Dynamic) or the send URL to do…
-
Customer Data DumpSummary Seeded Customer dump reportContent All - Is there a seeded out of the box report that can create a dump of all customer related attributes?Hari Thyagaraj 22 views 2 comments 0 points Most recent by Hari Thyagaraj Reporting and Analytics for SCM
-
Complex Inventory Stock Ageing Report by Original PO Receipt DateSummary Require feasibility check on a complex Inventory Stock Ageing Report (Across Multiple Inventory Orgs)Content We have an unique report requirement for customer re…Balachander G-Oracle 41 views 2 comments 0 points Most recent by Balachander G-Oracle Reporting and Analytics for SCM
-
Version Control for Data Models and ReportsSummary version control reports in BI PublisherContent Hello, Is there any best practice, or any way to version or tag a report or a data model in BI Publisher ? Thanks,…Yasmine Boutin-Oracle 35 views 3 comments 1 point Most recent by Yasmine Boutin-Oracle Reporting and Analytics for SCM -
Outbound interface to fetch records from FBDI Template which are ProcessedSummary Outbound interface to fetch records from FBDI Template which are ProcessedContent Hello Tech Gurus, I am new to Oracle Cloud.I have a requirement for outbount in…Tejaswi p 47 views 1 comment 0 points Most recent by RaviThejaDarbha Reporting and Analytics for SCM
-
Bursting sending duplicated reports.Summary Some outputs are being sent duplicted (or more!) by mailContent I have a report to get the hand quantity for each subinventory. The output is like: SUB ITEM QTY.…Gabriel Alejandro Zorrilla 27 views 2 comments 0 points Most recent by Gabriel Alejandro Zorrilla Reporting and Analytics for SCM
-
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 108 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIPSummary Is there any specific way in which we can get all the Supplies and Demand related SP data in one BIP Report?Content I want to know if there any specific way in w…Renuka Soneja-154959 39 views 2 comments 2 points Most recent by Renuka Soneja-154959 Reporting and Analytics for SCM -
Use text box for user in analysisContent Hi, I am trying to create analysis that return data for selected reference designator. I succeeded to create analysis that let the user to select reference desig…
-
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…Yogesh Nemchand 127 views 8 comments 0 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM
-
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…Yogesh Nemchand 160 views 1 comment 0 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM
-
Fusion BI Publisher Report - How To Get Last Run DateSummary Fusion BI Publisher Report - How To Get Last Run DateContent We are working on creating BI Reports (SaaS BIP) and use bursting and scheduling to send the notific…User13282169-Oracle 761 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM