Inventory
Discussion List
-
How to add attachments in Manage Charges and Estimates UISummary: Need to add attachments in Manage Charges and Estimates UI Content (required): We need to record customer acceptance of the estimates. Thus, we want to upload t…Abhishek Sinha 21 views 1 comment 1 point Most recent by Sandesh Chandrappa-Oracle Service Logistics -
Missing the Attribute Column in FLEX_BI_ItemBaseDFF_VISummary: Content (please ensure you mask any confidential information): using (FscmTopModelAM.EgpItemsPublicModelAM.ItemBaseDFFBIAM.FLEX_BI_ItemBaseDFF_VI) I'm attemptin…Waleed Fetoh 11 views 1 comment 0 points Most recent by Cornel Melinte-Support-Oracle Reporting and Analytics for SCM
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
movement request auto approval table in oracle fusionSummary: movement request auto approval table in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using,…KOTTHURI ASHOKBABU 21 views 2 comments 0 points Most recent by KrishnaV Reporting and Analytics for SCM
-
How can I identify Items which have common Structure with another item in different org?Summary: Goal is the extract list of item with with common structure. We have gone through the two subject areas below elated to Item Structure but did not find any comm…
-
Unable to Create Part RequirementSummary: In Service Logistics --> Manage Part Requirements, system is throwing below error when clicking on Order button. Content (please ensure you mask any confidentia…
-
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 173 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Destination Organization Has no Value in Part RequirementSummary: While trying to create part requirement in service logistics with type (Replenish Technician Trunk Stock), No destination organization appears. Content (please …Abdelrahman Salah 12 views 2 comments 0 points Most recent by Santosh Lingannagari Service Logistics
-
Not able to enter more serial numbers on transfer/return screenSummary: when we select the serial part to transfer/return, system is not showing quantity field and only allowing single serial number to select from the LOV. If techni…
-
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 52 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
i want a query to fetch item onhand with the current layer cost with a combination of valuation unitSummary: Attaching the code i am trying to run which is having a performance issue and could'nt figure out a way to fetch the layer cost of an item at a particular subin…Rudraksha Vishnu 373 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
How to identify Warranty Coverage in Depot Repair WorkbenchSummary: We have created a Sales Order for performing the Repair Work on a Product. How can we identify the Warranty Coverage of the Product/Serial Number and accordingl…Abhishek Sinha 111 views 13 comments 0 points Most recent by John Olszewski-Oracle Service Logistics
-
how to update/change Attributes in Fusion base table called "Inv_material_txns"Summary: Any rest api to update/change custom attributes in Fusion base table called "Inv_material_txns" Content (please ensure you mask any confidential information): V…mohamedaz 22 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Inventory transaction number in Inventory Transactions real time Subject areaSummary: Please suggest how to get the Inventory transaction number in Inventory Transactions real time Subject area Content (please ensure you mask any confidential inf… -
Unable to print pick splip to a printerSummary: Print Pick Slip report is ending in error while running with Printer as an output. Below are the details of error message from ESS jobs: Document delivery faile… -
Has anyone tried adding the cost to the INV_MATERIAL_TXNS table before?Summary: Hi, I'm trying to add the cost to the INV_MATERIAL_TXNS table. Has anyone tried this before? I'm using the cost from CST_LAYER_COSTS table but I'm getting dupli…
-
Report of units that cannot be reserved due to low stockSummary: The business requires knowing the information of order line units that cannot be reserved due to low stock and in consequence the customer's order cannot be ful…Fabian Castillo 11 views 1 comment 0 points Most recent by Fabian Castillo Reporting and Analytics for SCM
-
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 548 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM -
Is it possible to fetch historic On hand balances with it's costsSummary: We have a requirement that the business user wants to see backdated on-hand balances (Opening balances) with it's associated costs, i couldn't find any document…Mohamed Taher-Oracle 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
Report showing different output when logging in same environment (With SSO and Without SSO)Summary: Background A customer report is a custom report that shows all parts/items that are appended to a Machine. Parts/items will be included in the report even when …Kamohelo Leqele-Oracle 12 views 1 comment 0 points Most recent by Kamohelo Leqele-Oracle Reporting and Analytics for SCM -
Oracle fusion INV_MATERIAL_TXNS table's ACCT_PERIOD_ID column not populatedSummary: We are designing a DataWarehouse for fusion SCM and we notice that ACCT_PERIOD_ID column from INV_MATERIAL_TXNS table is not populated Content (please ensure yo…Emel Serpegean-Oracle 151 views 4 comments 0 points Most recent by Emel Serpegean-Oracle Reporting and Analytics for SCM
-
Manage Field Parts inventory page does not show org name/code in organization search fieldSummary: Manage Field Parts inventory page does not show any org name/code in organization search field. I had check all setups for Field service org and has all related… -
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu…
-
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…
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
Physical Inventory Adjustment ReportHello, Has anyone created a Physical Inventory Adjustment report for Oracle Fusion? We're on version 23A. Any guidance on the query would be appreciated. Thank you, Julia -
Access to Inventory Subject Areas for Inventory OTBI AnalysisHello, According to this document: https://docs.oracle.com/en/cloud/saas/supply-chain-management/22d/faosm/Inventory--Inventory-Transactions-Real-Time-SA-36.html#Invento…
-
Oracle fusion Service Logistics Implementation Document and user ManualSummary: Oracle fusion Service Logistics Implementation Document and User Manual Content (required): Hello Dears I'm searching for oracle fusion service logistics implem…
-
How to Create Estimates in Manage Charges and Estimates without any Parent TransactionSummary: We have a requirement to generate Estimates before creating any Service Work Order to answer the enquiries about the expected price of repair made by customer o…