Enterprise Asset Management - EBS (MOSC)

MOSC Banner

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

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