Prasanna Kumar: For one of our client, PeopleSoft Accounts Receivable condition monitor process helps in checking multiple conditions on Customer transactions and triggered an alert as well generated a report to the Accounts Receivable Specialists/Sales Person/Credit Analyst. The trigger is generated for various scenarios like customers with disputes, promise date is broken, exceeded credit limit and large amount due etc. This condition monitoring process ran for 11-12 hours a day, resulting in delayed reports generation and notification further delayed by a day. Subsequently Accounts Receivable Specialists/Sales Person/Credit Analyst were not able to take action on reported Customers on the same day. Prasanna identified the long running SQL scripts and fine-tuned them, resulting in process completion within 2 hours. This value add helped in saving close to $ 74880 USD per year.
( Mandatory field * )
Please Check on "I Agree" to register for the blog.