R12 - Seeking advice about "Program - Maintain Budget Organization" job
Hi,
A customer I support is on R12.1.3.
They are asking about GL Housekeeping jobs. As part of that I am investigating the "Program - Maintain Budget Organization" job.
I ran it on a test system and it ran for 14 minutes and returned this in the log file:
>> glugms() 23-MAY-2019 11:25:12=============================================================================== Date: 23-MAY-2019 11:27:48 Performance Module Execution Report Selectivity Summary Column Name Segment Name Segment Num Indexed? Class Selectivity Score ----------- --------------- ----------- -------- ----- ----------------- SEGMENT3 Account 2 Yes RT 9.932400100E+07 SEGMENT2 Cost Centre 1 Yes RT 1.340641280E+08 SEGMENT5 Product 4 Yes RT 9.111798240E+08 SEGMENT4 Sub Account 3 Yes RT 2.776379592E+09 SEGMENT1 Company 0 Yes RT 3.210351971E+10 SEGMENT6 Project 5 Yes RT 3.863918950E+10 SEGMENT7 IAS 6 Yes RT 3.963796077E+10 ----------------------------------------------------------------------------- *** The most selective segment is SEGMENT3===============================================================================<< glugms() 23-MAY-2019 11:27:48Deleting obsolete assignments ...6041 records processed.Adding new assignments ...42 records processed.