BI Publisher
Discussion List
-
Combine CSV Files to ZIP fileSummary Combine CSV output to ZIP fileContent We have requirement to combine the multiple CSV output files to single ZIP file and move it to UCM server. There were enhan… -
Tables regarded to Manage Item Quantities page on Oracle Inventory ModuleContent Hello all, I need to know the tables which contain the data related to the Manage Item Quantities page on Oracle ERP. I need to capture some fields from the page…Sushan Peiris 334 views 5 comments 5 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 558 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
How to create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS…Sushan Peiris 784 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee…Koteswararao Yenikepalli 74 views 4 comments 0 points Most recent by User_KM4LK Reporting and Analytics for SCM -
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…User_2025-02-11-07-07-59-045 925 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 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 1.1K views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Cost Accounting Distribution TablesContent Hi Team, Can anyone help me with table name for all the transaction types and the cost distribution details present on attached screen. Regards Nidhi...Nidhi Chhajed 35 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Not able to find Source Locator- Inventory Transaction Real Time Subject AreaContent Hi Team, I am new to Analytics reporting & need help to create a report with Below Scenario: 1) We need a report where Transaction Type = 'Subinventory Transfer'…Mayank Pande 37 views 2 comments 2 points Most recent by Sahil_Makhiza 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 102 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 56 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 116 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 41 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for SCM
-
Unable to add Negotiation Icon to the Springboard and Navigator.Summary Unable to add Negotiation, SQM, Catalog Icons to the Springboard and Navigator.Content Hi Fellow Practitioners, Season's greetings. I have done all the necessary…Prateek Moroney 159 views 1 comment 0 points Most recent by Yogesh_P-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 65 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 …
-
Specification for DOO_CROSS_REFERENCESummary Specification for DOO_CROSS_REFERENCEContent In the DOO, most of the views 'DOO_CROSS_REFERENCE' Pkg used to get shipment method, freight term...etc Where we can…
-
You cannot create a link to a child group as it is having a parent group.Summary Trouble joining more than one query to a "main" one.Content Hi. I'm trying to join two queries to another one as shown in the picture. I can join G2 or G3 to G1,…User_2025-02-07-06-48-26-537 350 views 2 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for SCM
-
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 28 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 53 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 38 views 3 comments 1 point Most recent by Yasmine Boutin-Oracle Reporting and Analytics for SCM -
Missing Create Infolet tile iconSummary Missing Analytics tab and Create Infolet optionContent Hello, I am interested in creating an Infolet based on information that is present in Product Information …
-
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.…User_2025-02-07-06-48-26-537 32 views 2 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for SCM
-
![Wim Bos [MLE]](https://us.v-cdn.net/6034893/uploads/userpics/ODSF2MJMJI4P/nCCCSR0CHH1FE.jpg)
Possible to retain OTBI/BIP report jobs upon P2TSummary Don't like having to reschedule the same report jobs after every P2TContent As stated in Doc ID 2581724.1 "P2T refresh clears the scheduled information too. Henc…Wim Bos [MLE] 46 views 4 comments 0 points Most recent by Karina Ogata Reporting and Analytics for SCM