OTBI
Discussion List
-
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 12 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 53 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 92 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 31 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 12 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 33 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 AviCPP 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 AviCPP 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 44 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 12 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 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 29 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
-
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 53 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 26 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 44 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 67 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 66 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- 80 views 4 comments 2 points Most recent by Dj-Oracle Supply Chain Planning and Collaboration