0 Replies Latest reply: Sep 12, 2013 3:11 PM by CREATION_ENG_ANALYST RSS

    How to store lead-time and price per MPN for a single Item

    CREATION_ENG_ANALYST

      We are probably one of the only CEM's that use Oracle Applications in a one-to-one MPN-IPN (Oracle Item Part Number) relationship. We do not currently store multiple Manufacturers under a single Item. Rather, we use the Customer Item Cross Reference to rank the customer's AML, with each IPN tied to a single MPN.

       

      We are looking at moving into a one-to-many "world" in Oracle but are not sure how we can handle different pricing, lead-time, preference, status (prototype, production, obsolete, do not use), etc. for each Manufacturer's Part Number under a single Item. How are other CM's handling this???