process_Transactions error
Hi,
I have written a code for subinventory transfer
INV_TXN_MANAGER_PUB.process_Transactions returns an error : All records failed after line validation
(no locator, no serial, not lot controllable item)
----------------------------------------------------------------------------------------------------------------------------------------------
DECLARE
L_TRANSACTION_HEADER_ID NUMBER;
L_TRANSACT_INTERFACE_ID NUMBER;
L_RETURN_STATUS VARCHAR2(1024);
L_MSG_COUNT NUMBER;
L_MSG_DATA VARCHAR2(1024);
L_TRANS_COUNT NUMBER;
retcd number;
BEGIN
SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
INTO L_TRANSACT_INTERFACE_ID
FROM DUAL;
SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
INTO L_TRANSACTION_HEADER_ID
FROM DUAL;
INSERT INTO MTL_TRANSACTIONS_INTERFACE
(CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
I have written a code for subinventory transfer
INV_TXN_MANAGER_PUB.process_Transactions returns an error : All records failed after line validation
(no locator, no serial, not lot controllable item)
----------------------------------------------------------------------------------------------------------------------------------------------
DECLARE
L_TRANSACTION_HEADER_ID NUMBER;
L_TRANSACT_INTERFACE_ID NUMBER;
L_RETURN_STATUS VARCHAR2(1024);
L_MSG_COUNT NUMBER;
L_MSG_DATA VARCHAR2(1024);
L_TRANS_COUNT NUMBER;
retcd number;
BEGIN
SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
INTO L_TRANSACT_INTERFACE_ID
FROM DUAL;
SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
INTO L_TRANSACTION_HEADER_ID
FROM DUAL;
INSERT INTO MTL_TRANSACTIONS_INTERFACE
(CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
0