hi,
you can use the FNDMIG migration tool to consume stock. Note that - in terms of IFS transactions - you have multiple choices, like “Issue Inventory Part” or “Count (out)”. I would suggest Issue Inventory Part is the simplest (inventory transaction = NISS).
Anyway, to set this up requires some familiarity with the migration tool, but basically you are replicating a oracle script like the following.
Using it - you can run it manually or scheduled, and you could feed in a spreadsheet of data.
DECLARE
-- p0 -> i_hWndFrame.frmIssue.tblPartLoc_colsContract
p0_ VARCHAR2(32000) := '1';
-- p1 -> i_hWndFrame.frmIssue.tblPartLoc_colsPartNo
p1_ VARCHAR2(32000) := '10501';
-- p2 -> i_hWndFrame.frmIssue.tblPartLoc_colsConfigurationId
p2_ VARCHAR2(32000) := '*';
-- p3 -> i_hWndFrame.frmIssue.tblPartLoc_colsLocationNo
p3_ VARCHAR2(32000) := '01-10-18-02';
-- p4 -> i_hWndFrame.frmIssue.tblPartLoc_colsLotBatchNo
p4_ VARCHAR2(32000) := '*';
-- p5 -> i_hWndFrame.frmIssue.tblPartLoc_colsSerialNo
p5_ VARCHAR2(32000) := '*';
-- p6 -> i_hWndFrame.frmIssue.tblPartLoc_colsEngChgLevel
p6_ VARCHAR2(32000) := '1';
-- p7 -> i_hWndFrame.frmIssue.tblPartLoc_colsWaivDevRejNo
p7_ VARCHAR2(32000) := '*';
-- p8 -> i_hWndFrame.frmIssue.tblPartLoc_colnQtyIssued
p8_ FLOAT := 1;
-- p9 -> i_hWndFrame.frmIssue.tblPartLoc_colnQtyCatchIssued
p9_ FLOAT := NULL;
-- p10 -> i_hWndFrame.frmIssue.tblPartLoc_colsAccountNo
p10_ VARCHAR2(32000) := '';
-- p11 -> i_hWndFrame.frmIssue.tblPartLoc_colsCostCenter
p11_ VARCHAR2(32000) := '';
-- p12 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeC
p12_ VARCHAR2(32000) := '';
-- p13 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeD
p13_ VARCHAR2(32000) := '';
-- p14 -> i_hWndFrame.frmIssue.tblPartLoc_colsObjectNo
p14_ VARCHAR2(32000) := '';
-- p15 -> i_hWndFrame.frmIssue.tblPartLoc_colsProjectNo
p15_ VARCHAR2(32000) := '';
-- p16 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeG
p16_ VARCHAR2(32000) := '';
-- p17 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeH
p17_ VARCHAR2(32000) := '';
-- p18 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeI
p18_ VARCHAR2(32000) := '';
-- p19 -> i_hWndFrame.frmIssue.tblPartLoc_colsCodeJ
p19_ VARCHAR2(32000) := '';
-- p20 -> i_hWndFrame.frmIssue.tblPartLoc_colsInvtranSource
p20_ VARCHAR2(32000) := '';
-- p21 -> i_hWndFrame.frmIssue.nPartTrackSessionId
p21_ FLOAT := NULL;
BEGIN
Inventory_Part_In_Stock_API.Issue_Part_With_Posting(p0_ , p1_ , p2_ , p3_ , p4_ , p5_ , p6_ , p7_ , 0,
'NISS', p8_ , p9_ , p10_ , p11_ , p12_ , p13_ , p14_ , p15_ , p16_ , p17_ , p18_ , p19_ , p20_ , p21_ );