Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Performance impact for 60K items assigned to 650 inventory organizations

in Inventory Management 2 comments

Summary:

We would appreciate any feedback / suggestions for inventory organization setup. We have to create 650 Inventory organizations and probably assign about 50K items to all inventory organizations. (32 Million). And in future we may be adding more items too. We would like to know if having these many items in EGP_SYSTEM_ITEM_B would cause issues with the performance of the application? We would like to know if this would also have impact on the many integrations we have built with external applications, reports, posting transactions, etc.

I have championed the concept of Definition Orgs and Reference Orgs, but need to understand with a strong facts that the above said setup may cause issues? or if it would be Ok to move ahead with setting up all 650 inventory organizations as Definition Organizations.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!