Error Importing Rebuildable Serial Numbers using Open Interface
Hi Everyone,
I tried to import Rebuildable Serial Numbers using Open Interface.
The script is as follow:
INSERT INTO MTL_EAM_ASSET_NUM_INTERFACE (BATCH_ID,INTERFACE_HEADER_ID,PROCESS_FLAG,IMPORT_MODE,IMPORT_SCOPE,INVENTORY_ITEM_ID,SERIAL_NUMBER,CURRENT_ORGANIZATION_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,DESCRIPTIVE_TEXT,WIP_ACCOUNTING_CLASS_CODE,OWNING_DEPartment_id ,CURRENT_STATUS, EAM_LOCATION_ID,MAINTAINABLE_FLAG)
VALUES (1008,203008,'P',0,1,37226,'42161-AMR-TEST02','6685',to_date('1980-01-01','YYYY-MM-DD'),-1,sysdate,-1,'AMR TEST 123','WIP CILEGO',59,3,535,'Y');
Then I import using Enterprise Asset Management menu: Interfaces -> Import Asset Number