OTBI
Discussion List
-
SQL Query to Extract Accurate Last Login Date for Active Users in Oracle Cloud SCM PlanningDear Oracle Experts, We are seeking assistance in generating a report from the PROD environment that provides a list of all active users across the following Oracle Clou…Nagaraj A 13 views 2 comments 0 points Most recent by Nagaraj A Supply Chain Planning and Collaboration -
What is the OTBI Subject Area to pull in Supply Planning assignment sets?looking to query our assignment sets (sourcing rules for items make and buy) in OTBI and cannot find the subject areaNicole Sievert 3 views 0 comments 0 points Started by Nicole Sievert Supply Chain Planning and Collaboration
-
Do we have any equivalent view in Fusion for mrp_orders_sc_vHi, I've a requirement to provide the Demand quantity. Please provide me the equivalent view for mrp_orders_sc_v. SELECT inventory_item_id, abs(sum(quantity_rate)) dmd F…Dinesh K89 11 views 2 comments 0 points Most recent by Dinesh K89 Supply Chain Planning and Collaboration
-
Functionality to print a label or report once the receiving is completedSummary: Business user is looking for the functionality to print a label or report once the receiving is completed against to the PO in Oracle. Is there a way to print i…Valencia Jonathan 20 views 0 comments 1 point Started by Valencia Jonathan Supply Chain Planning and Collaboration
-
Custom OTBI report under "Open Table, Graph or Tile Set"Summary: Need the ability to view a custom OTBI report under "Open Table, Graph or Tile Set" Content (please ensure you mask any confidential information): I can see the…starsniper_11 11 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle 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 54 views 2 comments 0 points Most recent by SARTHAK GOSWAMI Supply Chain Planning and Collaboration -
Looking for backend Planning column table nameSummary: Hi Team, We are looking for the back table name for below columns Safety_stock_planning_method , Days of Cover and Category_set_name with catalog and descriptio…LOKESH K MI 1 view 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
Create BI report from supply planning tableSummary: Hello, I was looking for source tables to create OTBI report from Tables and Views for SCM > Planning common, My objective is replicate the table view attached …Diego Zegarra 21 views 4 comments 0 points Most recent by Diego Zegarra Supply Chain Planning and Collaboration -
Oracle EBS BOM equivalent query in oracleSummary: Hello Team, I am researching on fining the equivalent query we are using EBS in Oracle Cloud. SELECT al2.organization_code, al1.item_number, al1.operation_seq_n…Jignesh_HAE 21 views 7 comments 0 points Most recent by Thierry Lamote Supply Chain Planning and Collaboration
-
is there any standard PVO available for table MSC_PEGGING_DEMAND2_VSummary: I am trying to extract data from Oracle Fusion using BICC. Please suggest the corresponding PVO for the table, MSC_PEGGING_DEMAND2_V Content (please ensure you …Anuprasad Anilkumar 11 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration
-
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 83 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM
-
SARTHAK GOSWAMI 11 views 1 comment 0 points Most recent by RakeshOracle-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 91 views 6 comments 1 point Most recent by ChallaPavan Supply Chain Planning and Collaboration -
How to Create Planned Order Report from Supply Planning DetailsSummary: Currently, user will go to supply planning screen and export planned order details manually to get the report. We need help for query to write this report and s…AISYAH ATHIRAH 62 views 2 comments 0 points Most recent by AISYAH ATHIRAH Supply Chain Planning and Collaboration
-
Query Original value of Transfer orderHi, We're trying to query the original value of a Transfer order. So it should be the UNIT_COST_AVERAGE value at the moment of creation of the transferorder line. Is the…MennovD 11 views 3 comments 0 points Most recent by Venkat Jagan Pakala-Support-Oracle Supply Chain Financial Orchestration
-
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 1 view 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 21 views 1 comment 0 points Most recent by Prateek_16-Oracle 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 31 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 24 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 51 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 41 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 44 views 2 comments 0 points Most recent by Avinash Erande 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…User_2025-03-07-19-29-15-074 11 views 2 comments 0 points Most recent by User_2025-03-07-19-29-15-074 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 15 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 21 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 28 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 75 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 33 views 8 comments 3 points Most recent by Sebastian Thomas Supply Chain Planning and Collaboration