Oracle’s BIPRIELD program had a performance issue. The Bill Finalization Job at 10 pm used to run beyond 12 am of the next day and skip the 12 am schedule, further making the 2.30 am schedule get overloaded. This used to further delay the schedule. Thus, the AutoZone in store payment and reconciliation file process would run with further delay and complete during the business hours, resulting in non-updated payments information. Satish Kumar N analyzed the Billing Finalization Job and found an opportunity to optimize the performance of the BIPRIELD program where an SQL update was found to be running for longer than expected. After optimizing, the team could increase the performance of the BIPRIED program by 75%, resulting in effort savings of 730 hours.
( Mandatory field * )
Please Check on "I Agree" to register for the blog.