"Schema Not Found" message when trying to create a Stored Procedure backed business object

exactly

   I believe that the root cause here is that you are using temporary tables which is confusing to the Object Mapper.

Fortunately, there is an easy workaround:

Just comment out the relevant sections of the stored pocedure that create and reference the temporary table(s), then use the OM to create the business object.  Finally, you can go back to the database, and take out your comments.  Everything will work as it should.  Of course, every time you go back to the OM to edit/create stored procedure-backed business objects, you must again comment out the sections that acccess the temporary tables.

An alternative workaround is to use any "dummy" stored procedure that has the correct input and output columns. After mapping has succeeded, replace the "dummy" stored procedure with the real one.  