Symptoms
Trying to Deploy Object and having issues with Stored Procedures
Diagnoses
During Smartobject Server load, updating/refreshing an oracle service instance and specifying the "Owner List" (which schemas it should surface) results in intermittent behavior of the service instance not surfacing the correct objects/schemas.
Resolution
Customer was provided with a coldfix to resolve this issue.