In Oracle e-business suite 12.2 I need to create some Mtl Serial Number entries for current_status = 3.
I have been told that I cannot use the INV_SERIAL_NUMBER_PUB.INSERTSERIAL to directly create current_status = 3, but I have to create a current_status = 1 and then use transactions to move the current_status from 1 → 2 and then another to move 2 →3
Where I am struggling is using INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS to create the transactions. Where I am struggling is currently I get the error → ‘Negative Balances Not Allowed’ - where I am pulling the costs and quantities from the on shelf entries. Can anyone tell me exactly what this error message is telling me, and also, exactly what field(s) I need to populate in mtl_material_transactions_temp to (for the 1→2) associate the transaction with the current_status = 1 entry and which fields in combination would give me the effects that I need, i.e. ‘moving’ a serial number from current_status from 1 to 2 (1 transaction) and moving current_status from 2 to 3.
Edit: the other error that I get that seems to be without reason is → Ex.. in updateOnhand ..oracle.apps.inv.transaction.utilities.InvTrxException → note I have found the Oracle note: Doc ID 3093479.1 and followed its advice recompiling packages, but this did not resolve it for me.
Any help however oblique appreciated.