Rapid Planning Plan is hung in Status: Started

Hello,

I have a peculiar issue in Rapid Planning R12.2.6. All the Plans in Rapid Planning are having the below issue.

Steps to reproduce

           Run Data Collection

         Launch Rapid Plan, Plan - A

          The Launch process Completes Normal . All the requests are completed Normal with in 5 min

          Go back to Rapid Planning UI and see that Plan is still in Status: Started.

          Status never reverts to Completed even after 2 hours and finally the plan fails to produce results.
    Due to this issue, we are not able to produce plan results and business has been majorly impacted.

As a part of resolution, we bounced Weblogic server and