Discrete Manufacturing - EBS (MOSC)

MOSC Banner

Reservations Interface got error "Invalid Demand Source"

Hi,

I want to connect WIP Job with Internal Order Line without any user intervention.

I populate these coulmns and start the Reservations Interface Manager. Get Error 1 - Invalid Demand Source . WHY?

insert into MTL_RESERVATIONS_INTERFACE

(RESERVATION_INTERFACE_ID,

RESERVATION_BATCH_ID,

REQUIREMENT_DATE,

ORGANIZATION_ID,

INVENTORY_ITEM_ID,

DEMAND_SOURCE_TYPE_ID,

DEMAND_SOURCE_HEADER_ID,

DEMAND_SOURCE_LINE_ID,

SUPPLY_SOURCE_TYPE_ID,

SUPPLY_SOURCE_HEADER_ID,

RESERVATION_UOM_CODE,

RESERVATION_QUANTITY,

ROW_STATUS_CODE,

LOCK_FLAG,

TRANSACTION_MODE,

RESERVATION_ACTION_CODE,

VALIDATION_FLAG,

LAST_UPDATE_DATE,

LAST_UPDATED_BY,

CREATION_DATE,

CREATED_BY)

values

(MTL_RESERVATIONS_INTERFACE_S.nextval,    -- Sequence

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