This discussion is archived
1 Reply Latest reply: Feb 5, 2013 8:12 AM by user427024 RSS

Item Related

968368 Newbie
Currently Being Moderated
If item is Serial Controlled, then how we will migrate the onhand quantity ?
  • 1. Re: Item Related
    user427024 Newbie
    Currently Being Moderated
    You have to populate two tables MTL_TRANSACTIONS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE.

    If you are transacting items under serial control, you need to link the serial transaction detail rows to their parent row. You accomplish this by populating MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID with a unique value to be used as the primary key to link the child lot/serial rows. If the item is under serial control, you populate the foreign key MTL_SERIAL_NUMBERS_INTERFACE.TRANSACTION_INTERFACE_ID with the value in the parent row and ensure that the total number of serial numbers adds up to the transaction quantity of the parent row.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points