This content has been marked as final. Show 13 replies
What is the table name in Inventory schema that contains the "Quantity On Hand" column? and corresponding "Cost Value" column?
I tried searching the column name but I can not find any.
Thanks a lot
Hi,1 person found this helpful
For onhand quantities, try table MTL_ONHAND_QUANTITIES_DETAIL. For costs you may try CST_ITEM_COSTS.
Hi;1 person found this helpful
You can query below table
select count(*) from all_tab_columns;
ALL_TAB_COLUMNS for all tables of all users. Also you can check DBA_TAB_COLUMNS
Thanks a lot MP and HELL,
Why is that the Oracle Report (CSTRINVR.rdf) "Inventory Value Report" which shows "TOTAL QUANTITY ON HAND" and "TOTAL COST VALUE" have the following complexed tables being accessed the makes you crazy
and there is no MTL_ONHAND_QUANTITIES_DETAIL on the above :(
cst_value_report_temp mfg_lookups gl_code_combinations cst_cost_elements mtl_categories_b mtl_system_items_vl mtl_secondary_inventories cst_inv_qty_temp cst_inv_cost_temp mtl_parameters cst_item_costs
Hi;1 person found this helpful
Please check below:
Inventory Value Report
Hi again;1 person found this helpful
I also suggest please check below note:
Inventory Value Report - FAQ [ID 110529.1]
Probably the report does have multiple parameters and multiple wasy of showing the information (or multiple information to show), and the developers are pre-calculating values which are storing in temporary tables (cst_inv_qty_temp, cst_inv_cost_temp, cst_value_report_temp) and then they are running the report on those tables. I guess they are not using MTL_ONHAND_QUANTITIES_DETAIL directly in the report because they are using it previously, while populating the temporary tables.1 person found this helpful
Actually, my goal is to zero out the column Inventory "Quantity Stocks on Hand". So we can start the Prod cut-over from zero. That is why I want to know which table is afftected.
The supported way I guess to "zero" it out, is to manually issue the Stocks on Hand to (misc issuance?) so that all
the stocks will be consumed (actually these are dummies stocks created duting UAT phase). This is tideous bacause
there are lots of items. Can you think of a fast way to initialize it?
I heard some suggestion of user "interface loaders" in which I will extract the data from "quantity on hand" and
create a loader to interface tables for misc issuance, so that the stocks will be "forced" issued by the interface loader.
Can you help me which interface tables I need to populate to ba able to issue misc transactions issuance? The will automatically deduct values from stocks on hand?
Thanks a lot,
You said " We are implementing inventory system and we will be going live next week. How do I zero out or initialize to "0" the "QUANTITY" and "VALUE" columns of the inventory tables?".
I am surprised that this question came up one week before go-live.
In any case, if you are just implementing it, the onhand balances will be set to zero automatically. Most companies have to import onhand and that is why they use the Transactions Interface to load beginning onhand. Since you want them to be zero, just don't do anything.
Hope this helps.
I raised an SR and the support said:
What do you mean by "ODM"? :)
=== ODM Answer === Option 1 - Use Physical Inventory to zero the on hand (recommended) References ========== Oracle® Inventory User’s Guide Release 11i Part No. A83507-09 February 2005 Metalink Note 374864.1 - How Physical Inventory Works Metalink Note 246934.1 - Understanding Physical Inventory Option 2 - do Misc issues
They could mean by ODM is Oracle Data Miner. But confirm it wiht oracle support,its more easy way to learn it