1 2 Previous Next 21 Replies Latest reply: Aug 22, 2007 9:33 AM by 594286 RSS

    Average Cost Update

    195588
      Hi,
      I am trying to import item cost and the cost_type is average Cost. How do i do that. I tried inserting into MTL_TRANSACTIONS_INTERFACE but in vain.

      Can anyone shed some light on it.

      Thanks and Regards,
      Kalpana Uppaladadiam
        • 1. Re: Average Cost Update
          50465
          Kalpana -

          Chapter 4 of the Oracle Manufacturing API's and Open Interface manual has some details about how you can import item costs from external systems.

          The interface table is : cst_item_cst_dtls_interface.

          Hope this helps.

          Regards,
          T.R. Srikanth
          • 2. Re: Average Cost Update
            Warren Tolentino
            You might also want to check the documents for Open Interface Manuals at:

            http://www.oracle.com/technology/documentation/index.html
            • 3. Re: Average Cost Update
              195588
              Srikanth,
              Thanks for the reply. I tried both the interfaces mtl_transactions_interface and item cost interface as well but in vain. Can you please give me more information abt this.

              Thanks and Regards,
              • 4. Re: Average Cost Update
                50465
                Kalpana - What was the error you encountered when you used the cst_item_cst_dtls_interface table?
                • 5. Re: Average Cost Update
                  195588
                  Srikant,
                  Sorry for the late response. Iam running the cost interface using Cost Import Interface. while running the interface the "cost type to import to " parameter has only one value in the LOV which is "Pending" (Pending Standard Cost Type). Since its passing Std cost as default parameter and iam trying to run the average cost its failing. The following is the code i have written..

                  INSERT INTO CST_ITEM_CST_DTLS_INTERFACE
                  (INVENTORY_ITEM_ID
                  ,ORGANIZATION_ID
                  ,COST_TYPE_ID
                  ,RESOURCE_CODE
                  ,USAGE_RATE_OR_AMOUNT
                  ,COST_ELEMENT_ID
                  ,PROCESS_FLAG
                  ,last_update_date
                  , last_updated_by
                  , creation_date
                  , created_by )
                  VALUES
                  (v_inventory_item_id,
                  ,85,
                  2,
                  'Material',
                  nvl(item_rec.item_cost,0)
                  ,1
                  ,1
                  , sysdate
                  , 1
                  , sysdate
                  , 1);


                  Please let me know where iam going wrong. Is there any additional setup i need to do.

                  Thanks and Regards
                  • 6. Re: Average Cost Update
                    50465
                    Kalpana -

                    Please check the cost type you are trying to insert into is setup to be updateable. I think the LOV only shows cost types that are updateable.

                    Please let me know if this worked for you.

                    -Srikanth
                    • 7. Re: Average Cost Update
                      195588
                      Srikant,
                      As you mentioned abt the update flag.. it is unchecked and when i try to check it its protected against update. Can you please let me know how to check the flag to updateable. I did try going to BOM module but didn;t see any Cost Type Information.

                      Thanks and Regards,
                      • 8. Re: Average Cost Update
                        50465
                        Kalpana -

                        You will not be allowed to change the "allow updates" flag for the Frozen cost type. As the name suggests, this is frozen and can not be updated. Please create a new cost type and import your costs into that cost type if you do not want to import into the "Pending" cost type.

                        Hope this helps,
                        Srikanth
                        • 9. Re: Average Cost Update
                          195588
                          Hi Srikant,
                          Thank You so much. It works like a charm now. Iam able to import the average cost using the new cost Type which i defined as "Average".

                          Thanks once again,
                          • 10. Re: Average Cost Update
                            50465
                            I am glad to be of some help.

                            Good luck!
                            • 11. Re: Average Cost Update
                              219274
                              Oracle does not allow you import Average Cost thro' Interface.
                              Average Cost type allow updates flag is set to No.

                              Average cost is calucated based on material transactions.
                              Only by having on hand you get the cost.
                              • 12. Re: Average Cost Update
                                195588
                                Hi,
                                I did try importing the cost while importing the Onhand Qty thru material transactions interface but didn;t load the Average Costs for the Items. Could you please give me more information regarding the same.

                                Thanks and Regards,
                                Kalpana
                                • 13. Re: Average Cost Update
                                  50465
                                  Hi Kalpana -

                                  To update your average cost from transactions you can use the "Mass Edit" program that is available withint the cost management module. It will let you edit cost based on average PO price, receipt price or average inventory cost.

                                  Dont know if thats what you are looking for.

                                  Regards,
                                  Srikanth
                                  • 14. Re: Average Cost Update
                                    195588
                                    Hi Srikant,
                                    This is exactly what iam trying to achieve through the interface. Can i do the same through the interface.

                                    Thanks and Regards,
                                    Kalpana
                                    1 2 Previous Next