Increase GLCCs from 61,000 to 500,000: Does this jump hurt/affect system performance?

Hi GL Gurus,

 

Currently our GL_CODE_COMBINATIONS table has 61,000 GL Code Combinations (GLCCs) and we are on R12.1.3.

We are trying to reduce the load of entering the GL Accounts every day manually, which is very cumbersome for our users. So we are thinking of entering almost 500,000 GL Code combinations in GL_CODE_COMBINATIONS table at once, so this way they do not have to deal with entering accounts every day. And in future we anticipate an increase of around 15000 GL CCs every year thereafter.

But one main point is around 1% of 500,000 that is 5,000 GL Code combinations will be used per year. That means transactions related to these 5000 will be created in associated GL (...Batches, Headers and Lines... etc) tables.