OTBI
Discussion List
-
Customer Cannot Enter OTBI catalog because of dll exists in the URLSummary: Customer Cannot Enter OTBI catalog because of dll exists in the URL Content (required): We came up with an issue from a customer that cannot open OTBI catalog b…Alexia Vitsa 2 views 2 comments 0 points Most recent by Shannon Skyrme-Oracle Supply Chain Planning and Collaboration -
How to create interactive dashboardSummary: I need to create a dashboard to show the count of requisitions for each type, the requisitions page should be displayed by clicking on the dashboard and the das…Farah Alajou 23 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
How to build queries on custom measuresSummary: I need to build queries to create reports those search for custom measures data I could create data set to search for dynamic tables (Query 1) and measures (Que…Carlos Benassi 87 views 5 comments 1 point Most recent by User_SM7RZ Supply Chain Planning and Collaboration -
Can we run ad-hoc queries using a custom tool/webpage by using BI publisher to access the Oracle CloSummary:We are currently in Cloud 23A for planning. We have an On prem 12.2.2 ERP system. Due to the new restriction Planning DB is on cloud and cannot be use accessed d…Raj Suman 27 views 2 comments 0 points Most recent by James Fabia Supply Chain Planning and Collaboration
-
How to derive Consumed Quantity ValueSummary: Requirement is to get the Review Supply Availability for a resource , I got the Table which stores the Supply quantity value, I am not getting the source table/…
-
Is there any reason why OTBI analysis report is not able to fetch details of some supply plans?Summary: In our case, in production environment, we have 2 supply plans and in both of them "Enable for OTBI reporting" is "checked" but our OTBI analysis report is able…Soumya_Gharei 28 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
Extracting Bookings History in Demand Mgmt - Customer Info requiredSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 52 views 8 comments 0 points Most recent by Avinash Erande Supply Chain Planning and Collaboration
-
Cloud Plan outputSummary Any inputs on how to pull the entire plan output in SCM cloudVersion 20 cuser10955442 42 views 4 comments 0 points Most recent by Shivana Sannagowdar Supply Chain Planning and Collaboration
-
Can we Display 'Standard Cost' of Item in Demand Plan Tables?Summary Can we Display 'Standard Cost' of Item in Demand Plan Tables?Content Hi All, We have column 'Standard Cost' in Demand Plan in Items table (as shown in screenshot…Ramesh Choudhary-137014 35 views 2 comments 0 points Most recent by Avinash Erande Supply Chain Planning and Collaboration -
CTO and OTBI practical tip as of 20AContent Dear SCPers! There are 2 points I would like to bring to ease troubleshooting and avoid filing SRs in the following scenarios. 1. OTBI fix will come in 20C. With…DinaJacobs-Oracle 45 views 1 comment 0 points Most recent by Cherry Bruns-Oracle Supply Chain Planning and Collaboration -
Which table has patching info in oracle cloud ?Summary: Oracle is deploying one off patches for SR fixes/issues, is there a way to identify the patch deployments in any tables ? Content (required): We need a table or…Kannan Janardhanababu-283647 20 views 2 comments 0 points Most recent by Kannan Janardhanababu-283647 Supply Chain Planning and Collaboration -
OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleSummary OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleContent Hi, OTBI Analysis Prompts NOT SEEN when I run the report in supply ch…Sanjiiv Chavaan-158651 16 views 1 comment 0 points Most recent by Cherry Bruns-Oracle Supply Chain Planning and Collaboration
-
In Supply Chain Planning Real Time Subject area, can I fetch non functional catalogs values?Summary: I am creating an OTBI with Subject area Supply Chain Planning Real Time, I am only able to see the values getting populated for Functional area catalogs and we …Vatsala Bharadwaj-Oracle 22 views 1 comment 0 points Most recent by Cherry Bruns-Oracle Supply Chain Planning and Collaboration -
Unable to open User Defined report in the Demand ManagementContent Hi Gurus, According the user guide we should be able to add user defined reports once user defined report is placed on into the Reports Components subfolder with…Venkatesh Periketi 30 views 1 comment 1 point Most recent by Yogesh_P-Oracle Supply Chain Planning and Collaboration -
Unable to see data correctly after combining multiple subject areas in OTBIContent I have combined 2 subject areas and from the Advanced Tab and clicked on dimensionality and applied SQL. But the data is not showing up correctly.Vatsala Bharadwaj-Oracle 34 views 1 comment 1 point Most recent by Krushna Sahoo-Oracle Supply Chain Planning and Collaboration
-
How to derive 'Price' and 'Values' from multiple Price ListsSummary How to derive 'Price' and 'Values' from multiple Price ListsContent We've multiple Price Lists defined in our system. For same Organization/BU, we've different P…Omkar Panda-Oracle 78 views 9 comments 1 point Most recent by SilviaCosentino-Oracle Supply Chain Planning and Collaboration -
How can we add custom Planning Measures from Supply chain planning in OTBI?Summary I have created an Adjusted measure and its not visible in OTBI Subject area of Supply Chain Planning, How we can enable it in OTBI?Vatsala Bharadwaj-Oracle 34 views 8 comments 3 points Most recent by Sebastian Thomas Supply Chain Planning and Collaboration
-
How to delete shipments history collected from OPS for last one monthSummary How to delete shipments history collected from OPS for last one month. We used seeded collection to collect shipments history from fusion (OPS).Content We are tr…Omkar Panda-Oracle 58 views 4 comments 1 point Most recent by Omkar Panda-Oracle Supply Chain Planning and Collaboration
-
Publish Data from UI: the column sequence keeps changingSummary Users are using publish data functionality from Dm/SOP Cloud. Once they add a new column, the column sequence changes in the output file.Content Hi All, Our user…Ankur Bhatia 39 views 5 comments 0 points Most recent by Ankur Bhatia Supply Chain Planning and Collaboration
-
Received Quantity of a ASBN in In Transait OTBI ReportSummary In transit ASBN with 1 received and 1 non received lines are not on the OTBI report, Received Quantity is not in the Receiving In-Transit Advance Shipment Notifi…Bernd Borstelmann-203269 31 views 1 comment 1 point Most recent by Yogesh_P-Oracle Supply Chain Planning and Collaboration
-
Collect 'Cost List' through Collections for use in Demand ManagementSummary Collect 'Cost List' through Collections for use in Demand ManagementContent Hi All, Can we collect the 'Cost List' from Pricing Module through collections for us…Ramesh Choudhary-137014 37 views 7 comments 2 points Most recent by Yogesh_P-Oracle Supply Chain Planning and Collaboration
-
Tables/ joins for BI publisher report for audit trail in Cloud Demand PlanningSummary Tables/ joins for BI publisher report for audit trail in Cloud Demand PlanningContent Hi All, We are planning to use BI publisher to create an audit trail report…Kaushik Dinkar Mantri 71 views 6 comments 1 point Most recent by Ankit Arora Supply Chain Planning and Collaboration
-
Loaded Forecast for star items in CTO flow, but in supply planning the forecast was not getting consSummary Customer wants to load the forecast for star item in demand management and validate the forecast consumption happening at Model.Content Customer wants to load th…Sreelekha P-Oracle 57 views 2 comments 0 points Most recent by Sreelekha P-Oracle Supply Chain Planning and Collaboration
-
Send UCM File As Email AttachmentSummary Send UCM File As Email AttachmentContent Hello Experts, We are using “Publish Plan” program to export some planning tables data to UCM server but there is no way…Abhishek Sharma- 85 views 4 comments 2 points Most recent by Dj-Oracle Supply Chain Planning and Collaboration -
Demand Plan: Which Data base table stores the details of 'which forecasting method was used to generSummary Demand Plan: Which Data base table stores the details of 'which forecasting method was used to generate the forecast for Item-Org combination in a demand plan'?C…Ramesh Choudhary-137014 67 views 2 comments 0 points Most recent by RakeshOracle-Oracle Supply Chain Planning and Collaboration
-
Which PVO should be used to extract Resource Requirements in Supply Planning from BICC in Fusion ?Content Which PVO should be used to extract Resource Requirements in Supply Planning from BICC in Fusion ? Version Release 20BSandeep Pati 31 views 2 comments 0 points Most recent by Cherry Bruns-Oracle Supply Chain Planning and Collaboration
-
Question: In Demand Management, How to use Moving_Total Function to exclude past one month while perSummary Question: In Demand Management, How to use Moving_Total Function to exclude past one month while performing summationContent Hi Team, We have an requirement to d…Ramesh Choudhary-137014 26 views 1 comment 0 points Most recent by Nagappan Periakaruppan Supply Chain Planning and Collaboration
-
Can we reserve supplies against Transfer OrdersSummary In a constrained planning system, we can reserve supplies such as On Hand, PO's, PR's etc against high priority customers and high valued Sales Orders. Can it be…Omkar Panda-Oracle 53 views 1 comment 2 points Most recent by Rahul Awasthi-Oracle Supply Chain Planning and Collaboration
-
How to automate Supply Plan Back-Up process in Planning CentralSummary Business Requirement - Supply Plan should be copied first to a back up before being launched as part of daily run schedule.Content Hi, Business Requirement - Sup…Omkar Panda-Oracle 47 views 2 comments 0 points Most recent by Omkar Panda-Oracle Supply Chain Planning and Collaboration
-
Can we perform material simulations in S&OP based on Demand ?Content Hello All, I need some clarification regarding oracle cloud S&OP Requirement : Once forecast is generated in Demand Management(DM) user copies the forecast from …SHARATH CHANDER MANOHAR 37 views 2 comments 0 points Most recent by SHARATH CHANDER MANOHAR Supply Chain Planning and Collaboration