OTBI
Discussion List
-
Unable to link Order Fulfillment and Item Cross Reference Subject AreasSummary Unable to link Order Fulfillment and Item Cross Reference Subject AreasContent Hi, Are there any documentation to identify what join is missing when we try to re…Shifa Nazumudeen 17 views 1 comment 0 points Most recent by Shifa Nazumudeen Reporting and Analytics for SCM -
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…Harish Gundre 32 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
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… -
Is there a way to restrict BI Admin role user to Query only Supply Planning related tables to buildSummary BI Admin - Role restriction per moduleContent We are already live with HCM and implementing Planning modules. When a user having only supply chain roles get BI A…Ramkumar Sethuramalingam 36 views 2 comments 0 points Most recent by Ramkumar Sethuramalingam 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 785 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 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 -
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 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 -
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 40 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 166 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 31 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 48 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 28 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 … -
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 -
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 130 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 39 views 3 comments 0 points Most recent by Karina Ogata Reporting and Analytics for SCM