Item Organization Assignment Performance Tips (Doc ID 552829.1)

Last updated on MARCH 31, 2016

Applies to:

Oracle Item Master - Version 11.5.10.2 and later
Information in this document applies to any platform.
INVITEMORG_ASSIGN

Goal

You are running Item Organization Assignment with considerably large number of Organizations (80+) and about 10 lac items to be processed (for example some 12000 items to be assigned to some 80 different orgs)

You encounter poor performance and rollback segment issues. 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms