Inventory Management - EBS (MOSC)

MOSC Banner

CSTPIDIO(7):ORA-01422: exact fetch returns more than requested number of rows

edited Aug 28, 2009 3:56AM in Inventory Management - EBS (MOSC) 1 commentAnswered
 Hi,

I am running the Import Items after having records in mtl_system_interface table, the item is created in Master Organization, but not assigned to other organizations and the program is erring out with the error message.

TRANSACTION ID : 27910643
ORGANIZATION ID : 481
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME :
MESSAGE NAME : CST_ERR_IN_OI
ERROR MESSAGE : CSTPIDIO(7):ORA-01422: exact fetch returns more than requested number of rows

Now, If I exclude the items related to 481 organization and run the Import Items it assigns all the items to all other organizations successfully. Can somebody help me in this? Thank You very much

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