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

MOSC Banner

Update Item Attributes Problems

edited Mar 24, 2016 2:12PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered ✓

Hi,

  My requirement is to update item attributes "QTY_RCV_EXCEPTION_CODE" and "QTY_RCV_TOLERANCE". I am inserting only the needed columns into item interface.

insert into mtl_system_items_interface(set_process_id,

                                           inventory_item_id,                                          

                                           transaction_type,

                                           QTY_RCV_EXCEPTION_CODE,

                                           QTY_RCV_TOLERANCE,

                                           process_flag,

                                            organization_id );

The error I receive for a child organization is

"

TRANSACTION ID : 1510490

ORGANIZATION ID : 102

TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE

COLUMN NAME : SOURCE_SUBINVENTORY

MESSAGE NAME : INV_IOI_SOURCE_SUBINV_REQUIRED

ERROR MESSAGE : Source subinventory is mandatory for MRP planned items and having source organization as current organization."

But I am able to do the same update from front-end even though teh source subinventory is not populated. The attributes (

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