Inventory
Discussion List
-
Sandbox Personalization support by Oracle Support/development teamSummary: Dear Team, We have personalized fusion application using Page Compose via Sandbox and would like to know incase of any issues/errors/query related to these sand…Vijay Karuppiah-Oracle 11 views 1 comment 0 points Most recent by Aravind Ragul-Oracle SCM Redwood Personalization Helper Tool -
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 41 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 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 22 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 11 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 51 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 371 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 21 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 545 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 11 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 152 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…