Inventory
Discussion List
-
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 11 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 524 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 13 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 1 view 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 151 views 8 comments 0 points Most recent by Kunal Verma Reporting and Analytics for SCM
-
End to end flow for Oracle Field service inventory managementSummary: Looking for a flow chart or document that has the end to end flow and setups for inventory flow between Oracle Fusion ERP and Oracle Field service cloud. Conten… -
How to find the path for OTBI behind seeded infolets in Oracle?Hello, There is a seeded inventory dashboard in Oracle fusion, On-Hand value. I am trying to understand how to get to the actual OTBI it is invoking to get this data. I …Sheetal VBCS 31 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there any documentation or guidance on migrating to Oracle Fusion Redwood across all modules.Is there any documentation or guidance on migrating to Oracle Fusion Redwood across all modules (FIN, SCM, HCM)?Mohamed Roshdy 32 views 2 comments 0 points Most recent by Nora Nordin SCM Redwood Personalization Helper Tool
-
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line …
-
Movement Request DFF personalization issue in Redwood PagesSummary: On Movement Request, Redwood page if user selects “Project Number” then DFF fields should become Required. Content (please ensure you mask any confidential info…Ashutosh_b_sharma-Oracle 33 views 1 comment 0 points Most recent by Ashutosh_b_sharma-Oracle SCM Redwood Personalization Helper Tool
-
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 217 views 9 comments 0 points Most recent by Chandramouli Potnuru Reporting and Analytics for SCM -
Report header columns are missing when there is more than 65536 rowsReport header columns are missing when there is more than 65536 rows and the data is splitting into different sheets. The sheet numbers are also going from Sheet1 to She… -
please suggest database tables/how to calculate Available to reserve and Available to transact QtySummary: We want to fetch Available to reserve and Available to transact Qty based on lot details from the database tables. Can you please suggest the database tables/ho…KOTTHURI ASHOKBABU 43 views 2 comments 0 points Most recent by BalaKadapa Reporting and Analytics for SCM
-
Report is ending in errorWe have a custom BI report related to Inventort module. The report generates excel output and the file size can be of 100 MB or more. When we run the report for multiple…KabirB 21 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to remove a task from the Redwood "Item Quantities" screen?Summary: How to remove a task from the Redwood "Item Quantities" screen? Content (please ensure you mask any confidential information): We need to hide certain tasks ava…Marilynf 31 views 2 comments 0 points Most recent by Marilynf SCM Redwood Personalization Helper Tool -
Can we compare two environments and list of classic UI Changes using SCM Redwood PersonalizationtoolSummary: Can we compare two environments and list of classic UI Changes using SCM Redwood Personalization tool Content (please ensure you mask any confidential informati…S.S.ShahTTX 41 views 2 comments 0 points Most recent by Aravind Ragul-Oracle SCM Redwood Personalization Helper Tool
-
We have some doubts regarding the transition of Oracle Classic to RedwoodSummary: Below are the doubts we have regarding the transition of Oracle Classic to Redwood - 1. When oracle is decommissioning the classic pages and fully migrate to th…
-
Why is the Redwood Inventory Management Landing page Library button grayed out?Summary: We have enabled the Redwood Inventory Management Landing page in our test environment and want to use the Edit Page Layout option. I can open the Edit Page Layo…newbie_lynda 11 views 2 comments 1 point Most recent by newbie_lynda SCM Redwood Personalization Helper Tool
-
Redwood : Disable receipt correction if receipt is invoicedHi Redwood Community, I’m working on a Redwood UI page and trying to implement a rule to restrict receipt correction completely if an invoice has been created for the tr…devbabu49 11 views 0 comments 0 points Most recent by devbabu49 SCM Redwood Personalization Helper Tool
-
Unable to see the sources of manned/unmanned sources in service logistics part requirementHi All, We have created the manned/unmanned stocking locations, inter organization parameters and transit times are defined. But still in part requirement the source are…
-
Error response during RestAction in Awaiting Putaway ScreenSummary: Unable to do Putaway in Received Lines task and error message pops up "Error response during RestAction" Content (please ensure you mask any confidential inform…
-
Help Needed: Average Costing Logic – How to Carry Forward Updated Unit CostHi, I have a requirement to calculate the updated unit cost using the following formula and use the resulting value as the current unit cost for the next transaction row…RiyaKaushal123 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Is there a way to exclude the LOTs on hold from Inventory ValuationSummary: Is there a way to exclude the LOT on hold from the Inventory Valuation? example quality hold ? Content (please ensure you mask any confidential information): Ve…Amrish_Amradkar 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Unable to edit the redwood pages via Visual BuilderHello We are facing issue while editing and hiding columns, infolets within the redwood page via visual builder. Could you be able to provide some insights how to edit t…Krishanu Saha 101 views 2 comments 0 points Most recent by Shamsul_Wzd SCM Redwood Personalization Helper Tool