Search 800 + Posts

Mar 16, 2011

Drop Ship receiving ORA-01422: exact fetch returns more than requested number of rows(Part-2)

Many a Times we noticed duplicate data in oe_drop_ship_sources , or we try to perform virtual receiving in the system and receiving Transaction processor error out with following error message  “ORA-01422: exact fetch  returns more than requested number of rows
Second  reason ( Please refer Part 1 for more info for this error ) for this error could be
Data already exists in oe_drop_ship_sources table and then user "RETRY" Sales Order Line workflow activity "purchase release", doing so will insert duplicate data in oe_drop_ship_sources.

So be careful if you want to Retry this activity ( My suggestion don't do that unless you are pretty much sure about it).

No comments:

Post a Comment