Inventory
Discussion List
-
Unable to find Oracle R12 Inventory tables in Oracle FusionHi, We are working on Fusion Implementation project. We have developed some custom reports in our Old Oracle R12, we need to develop it in Oracle Fusion. We face difficu…Chaitanya KM 45 views 2 comments 0 points Most recent by Chaitanya KM Reporting and Analytics for SCM -
Return Transaction of Inventory IssuanceSummary: After an Inventory Item is utilized in a Field Service Activity, progresses through debriefing and completion stages, and a corresponding transaction is created…
-
How to lock and unlock assets from UI and API?Summary: Hi team, We want to lock an asset so that others cannot make update to it when we are doing any changes, and we need this functionality from both UI and API, I …
-
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 28 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 19 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 42 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…
-
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 15 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…Santosh Lingannagari 20 views 1 comment 0 points Most recent by Satya Ganti-Oracle Service Logistics
-
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 56 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 392 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 127 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 26 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
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 14 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 549 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 13 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 161 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…
-
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…