ORA-06508: PL/SQL: could not find program unit being called - Planning Data Pull request completes i
I am getting this error when running collections and it causes the Planning Data Pull stage to complete in error. At first this happened maybe once every few weeks, now it is more regular and these past 2 mornings, it has failed (we run this request a 2am each morning).
In the log for the Planning Data Pull it states:
Refresh Snapshot process started.
Application id: 660
Refresh Snapshot process( Request_ID=28494295) is submitted.
ORA-06508: PL/SQL: could not find program unit being called
When I view the Refresh Snapshot request, it is at the status Inactive No Manager. I then 'View' the request to see if all parameters have been entered correctly and it seems to refresh the request so its starts to run normally and then always completes normally. I dont understand why this happens as the log states the 'Refresh Snapshot process started', yet it is actually inactive.