26000 GL_COde Combinations

[amit_gupta]

Hi,

I am Functional Consultant and I need to Disable 26000 code combinations in GL can any body tell me how can we able to do it from the backend. If you have the Query or procedure Please forward me so that I can able to do it

Regards
Amit Gupta

[admin]

Login with GL responsibility and then Setup > Accounts > Combinations and search the code and enter to date. Hope it will work for you. thanks

[amit_gupta]

Yes it can be possible from the frontend also through combinations and I know the process of that but there are 26000 combinations which will take a long time so I want to know how to do it from TOAD

[admin]

Pl check the following query and filter the data as per your requirements.

SELECT code_combination_id, chart_of_accounts_id, end_date_active
FROM gl_code_combinations
WHERE chart_of_accounts_id = ?

I am sure you will first test all this on test. thanks