Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

process_Transactions error

edited Nov 25, 2013 7:34PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered
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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center