Inventory
Discussion List
-
Min-Max Planning Details Across All Orgs ReportSummary: Needs a query to fetch the Min/Max details for all the items across all the inventory organization in the application. Content (please ensure you mask any confi…Mamdouh Ahmed 19 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM -
Exception Report for Inventory Pending TransactionsSummary: We need a query to get the details of the Inventory Pending Transactions. Content (please ensure you mask any confidential information): We are seeking a PL/SQL…Mamdouh Ahmed 20 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
No analysis available while creating a visualization metricI am trying to configure a visualization in the Inventory Management Landing page using an analysis, however when trying to search for the created analysis in the Visual…Ahmed Sameh Mohamed 11 views 0 comments 0 points Started by Ahmed Sameh Mohamed Reporting and Analytics for SCM -
How to Change/Rename Labels in Redwood pages?We want to know how to change label on redwood pages as well, user interface text changes the text everywhere. In sandbox/page composer we used to be able to target a sp…Seeam Jyanesh 451 views 6 comments 3 points Most recent by Bmasinen SCM Redwood Personalization Helper Tool -
After Posting Charges few of the fields are coming as blank in Sales OrderSummary: Hi, After we post the charges from Service Logistics, Sales Order gets created. Within the Sales Order when we look at the fields like Ship to Customer, Ship To… -
Redwood Migration Accelerator for SCM in Oracle FusionHi Everyone, I would like to know, similar to CX, is there a Redwood Migration Accelerator for SCM? If not, is there any plans to unveil it to help migrate to Redwood UI…Suriya Babu 61 views 5 comments 2 points Most recent by Rebecca Souza SCM Redwood Personalization Helper Tool -
Need a SQL query to get the Total Quantity of Pending Transactions of a item in oracle fusionHi Experts, I need a SQL query to get the Total Quantity of Pending Transactions for a item. My requirement is to get "Available to Transact" Quantity of a item. ( = 200…Krishan_Palihakkara 1.3K views 20 comments 0 points Most recent by Shyam Patel Reporting and Analytics for SCM -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh…
-
Select BIP to get the pick slip for the pending transactionsSummary: Select BIP to get the pick slip for the pending transactions of a specific item Content (please ensure you mask any confidential information): Hi All, we need a…Mamdouh Ahmed 11 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM
-
BIP Bursting Email Delivery Failing - SMTP_FROM Missing Required Property in Oracle Fusion CloudSummary: I have set up a BIP bursting report in Oracle Fusion Cloud (SCM/Inventory Management) to deliver personalized Excel reports to multiple email recipients based o… -
Restrict access of Field Service Administrator job role to Organization level transactions/work areaThe seeded role of Field Service Administrator has data access to every organization created in the Service Logistics. User can view all the work orders created in all t…Bhargav Nandanwar - Trinamix 2 views 0 comments 0 points Started by Bhargav Nandanwar - Trinamix Service Logistics
-
How to customise Print Min Max Planning ReportHi, We have a requirement to add/modify columns in the seeded Print min max planning report. Since it fetches data from a temporary table, is it possible to customise? W…Ankana Bhattacharya 41 views 0 comments 0 points Most recent by Ankana Bhattacharya Reporting and Analytics for SCM
-
Serious UX Concerns in Oracle Fusion SCM – Immediate Attention RequiredSummary: Serious UX Concerns in Oracle Fusion SCM – Immediate Attention Required Content (please ensure you mask any confidential information): Dear Oracle Fusion SCM Te…
-
How to remove classic page Create Miscellaneous Transaction task in Redwood landing pageSummary: We have activated the Redwood pages in Inventory Management. We use the Miscelleneous transactions page in Redwood via Redwood Item Quantities page, but we can …Anita Jansen 28 views 2 comments 0 points Most recent by Anita Jansen SCM Redwood Personalization Helper Tool
-
How I can extract the list of subinventories and the respective Inventory OrgSummary: Extract the list of subinventories and the respective Inventory Org Content (please ensure you mask any confidential information): We need a query or a way to e…Mamdouh Ahmed 21 views 5 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 181 views 2 comments 0 points Most recent by Dineshkumar.A-Oracle Reporting and Analytics for SCM
-
Query to fetch the item wise lots with the on-hand per subinventorySummary: Request to have a select query to fetch the item wise lots with the on-hand per subinventory Content (please ensure you mask any confidential information): We h…Mamdouh Ahmed 21 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Get More from SCM Analytics: Three Webinars You Won’t Want to MissThree upcoming webinars will show how to get more from Oracle Fusion SCM Analytics—using prebuilt analyses, metrics, and dashboards (Sales Orders, Procurement Spend, Inv…Aimee Williams-Oracle 13 views 0 comments 0 points Most recent by Aimee Williams-Oracle Reporting and Analytics for SCM -
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 526 views 2 comments 11 points Most recent by Mohammed Rafi Reporting and Analytics for SCM -
Query for joining inventory transaction tables to costing transaction tablesSummary: I want to join INV_MATERIAL_TXNS table and CST_TRANSACTIONS to get the details of all the inventory transactions including costed transactions with their costin…
-
Redwood Adoption ManualSummary: Currently trying to get Redwood enabled in all our environments. We started with Dev but did not use the helper tool. Is that a prerequisite? How do we know if …Rachel.J 11 views 2 comments 0 points Most recent by Rachel.J SCM Redwood Personalization Helper Tool
-
Migrating data to redwood screen require scheduled job ?Does transferring / migrating existing data to new Redwood-enabled features or pages within SCM Oracle Fusion will be done via scheduled jobs ?Shivangi Bakhshi 6 views 1 comment 0 points Most recent by Prince Singh SCM Redwood Personalization Helper Tool
-
report only returns current live inspection dataWe have developed an Inspection Summary Report in Oracle Fusion (BI Publisher / OTBI) to retrieve inspection history for all items in our inventory organizations. The re…Patrick Chrabieh 1 view 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
How to identify Region/Location names on Transit time tables?Summary: On the transit time tables (WSH_TRANSIT_TIMES/WSH_TRANSIT_TIME_VALUES), we have the From & To Location and Region ID's. So, which tables can be used to map thes…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 152 views 8 comments 0 points Most recent by Kunal Verma Reporting and Analytics for SCM