Enterprise Asset Management - EBS (MOSC)

MOSC Banner

EAM Open Interface for Import Asset Number

edited Dec 10, 2018 4:07AM in Enterprise Asset Management - EBS (MOSC) 3 commentsAnswered

Dear all,

I'm using Open Interface for Import Asset Number (mass upload). I have populate required data and inserting into interface table. The sql script as shown below.

INSERT INTO APPS.MTL_EAM_ASSET_NUM_INTERFACE

( BATCH_ID,PROCESS_FLAG,IMPORT_MODE, IMPORT_SCOPE,INVENTORY_ITEM_ID, SERIAL_NUMBER,ORGANIZATION_CODE,OWNING_DEPARTMENT_ID, ERROR_CODE,ERROR_MESSAGE,CATEGORY_ID,DESCRIPTIVE_TEXT, CURRENT_ORGANIZATION_ID,WIP_ACCOUNTING_CLASS_CODE,

MAINTAINABLE_FLAg, EAM_LOCATION_ID, ASSET_CRITICALITY_CODE, INTERFACE_GROUP_ID, INTERFACE_HEADER_ID,

LOCATION_CODES, OWNING_DEPARTMENT_CODE, asset_criticality_id, current_status, LAST_UPDATE_date, LAST_UPDATEd_BY, CREATION_DATE, CREATED_BY)

Tagged:

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