OTBI
Discussion List
-
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 542 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 724 views 4 comments 3 points Most recent by Sushan Peiris 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 865 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 1K views 1 comment 3 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 93 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM -
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
-
OTBI - Product Management - Cross Subject Area Logical SQL giving ErrorSummary OTBI - Product Management - Cross Subject Area Logical SQL giving Error 'The selected request cannot be performed because it references an unknown subject area n…
-
Number of receipts made in a periodContent Hello I am trying to find out the number of receipts made between certain dates, but I am struggling to find the correct subject areas, or BI tables which contai…Helen Thomas 33 views 2 comments 3 points Most recent by Helen Thomas Reporting and Analytics for SCM
-
OTBI Dashboard results in display errorSummary The dashboard contains an analysis with extensible flexfields. The flex field is deployed and working fine within OTBI but when deployed on OM Landing page via s…Tejas Mehta-248693 150 views 2 comments 0 points Most recent by Tejas Mehta-248693 Reporting and Analytics for SCM
-
Where is "Available to Reserve" fact in BISummary Where can "Available to Reserve" fact be located in BIContent Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the f…User_2025-02-06-00-08-33-553 26 views 1 comment 2 points Most recent by User_LDHCN Reporting and Analytics for SCM
-
RSUM not giving expected results.Content Hi. I made an OTBI report (check attached image) using the Cash Management - Bank Statements Real Time, Subject Area I want to do a RSUM of each bank account to …User_2025-02-07-06-48-26-537 45 views 3 comments 0 points Most recent by Syed Misbauddin-Support-Oracle 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 22 views 2 comments 0 points Most recent by Hari Thyagaraj 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 …
-
![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] 38 views 4 comments 0 points Most recent by Karina Ogata 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 122 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
Access PermissionSummary i need to give one user read only for Purshase and Sales OTBI reportContent Hello i have one use , this user is not have license to Order management module and p…Mahgoub S.Mohamed 34 views 3 comments 0 points Most recent by Karina Ogata 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…
-
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…User_2025-02-05-12-20-44-163 193 views 1 comment 0 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
How to join Procurement - Procure To Pay Real Time and Procurement - Purchasing Real Time without "OSummary Ability to display PO Line DFF with Procure to Pay information and Logical SQLContent We would like to display the PO Line DFF with Procure to Pay information an…
-
Oracle Fusion Cloud Audit Reports - Changes in Static Data (Before and After Values)Summary Audit Reports - Additional Functionality (Before and After Values)Content Hi, My client wishes to have a more detailed Audit Report functionality Currently the A…Stuart Hackney 45 views 2 comments 0 points Most recent by Stuart Hackney Reporting and Analytics for SCM
-
Remove merged cells from report in reports & analyticsSummary Remove merged cells from report in reports & analyticsContent Hello, Please note that we have a report : Scott Marketing report which has merged columns B & C AN…User_2025-02-05-12-20-44-163 237 views 7 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM