13 Replies Latest reply on Jul 8, 2010 7:54 AM by 762809

    Inventory System

    762809
      Hi,

      EBS 11i

      Is Inventory System under Pocurement? I can not see any forums here for inventory :)
      Anyways I will just post my question here.

      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?

      Thanks a lot,

      Ms K
        • 1. Re: Inventory System
          762809
          Hi hussein/helios,

          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
          • 2. Re: Inventory System
            rioman
            Hi,

            For onhand quantities, try table MTL_ONHAND_QUANTITIES_DETAIL. For costs you may try CST_ITEM_COSTS.

            Regards.
            1 person found this helpful
            • 3. Re: Inventory System
              Helios-GunesEROL
              Hi;

              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

              Regard
              Helios
              1 person found this helpful
              • 4. Re: Inventory System
                Helios-GunesEROL
                Hi;

                Please also check below thread which you open on other OTN forum site:

                Re: Inventory Table

                Regard
                Helios
                • 5. Re: Inventory System
                  762809
                  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
                  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  
                  and there is no MTL_ONHAND_QUANTITIES_DETAIL on the above :(

                  Thanks
                  • 6. Re: Inventory System
                    Helios-GunesEROL
                    Hi;

                    Please check below:

                    Inventory Value Report
                    http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/cst/cstrinvr.htm

                    Regard
                    Helios
                    1 person found this helpful
                    • 7. Re: Inventory System
                      Helios-GunesEROL
                      Hi again;

                      I also suggest please check below note:

                      Inventory Value Report - FAQ [ID 110529.1]

                      Regard
                      Helios
                      1 person found this helpful
                      • 8. Re: Inventory System
                        rioman
                        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.

                        Regards.
                        1 person found this helpful
                        • 9. Re: Inventory System
                          762809
                          Thanks MP,Helios,

                          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?

                          Please Help.....

                          Thanks a lot,

                          Ms K
                          • 10. Re: Inventory System
                            Sandeep Gandhi, Consultant
                            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.
                            Sandeep Gandhi
                            • 11. Re: Inventory System
                              762809
                              Hi sandeep,

                              I raised an SR and the support said:
                              === 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 
                              What do you mean by "ODM"? :)


                              Thanks
                              • 12. Re: Inventory System
                                Helios-GunesEROL
                                Hi;

                                They could mean by ODM is Oracle Data Miner. But confirm it wiht oracle support,its more easy way to learn it

                                Regard
                                Helios
                                • 13. Re: Inventory System
                                  762809
                                  thanks :)