Hi:
You did not say in your original post that this was a stored process. Are you sure that the LIBNAME statement is correct for a Stored Process that uses the metadata server? Are your Oracle tables defined in the metadata with the correct engine? Are you sure your Workspace server or Stored Process server can "talk" to the Oracle server?
How did you build your stored process? From an EG project that was working or from an EG project that had errors reading the Oracle file? I believe, that in the Enterprise Intelligence Platform, there also could be some configuration and platform administration issues about which servers "know" about the location of the database tables and therefore, affect, which servers you choose to execute your stored process.
To me, this seems to be a question best answered by SAS Tech Support.
cynthia