OK I have managed to confuse everyone.

The synonym is corrupt somehow.

I have proven a test synonym actually calls the correct package.

I am not interested in the outcome of the package its easy enough to give it the right table/owner. I dont intend to refresh the production table or I would not have intentionally created a user error.

Its of no consequence, as long as the synonym calls the right package with a good or bad outcome I dont care.

The problem is the DBMS_MVIEW synonym cannot even call the package it is suppose d to point to. Its messed up somehow. Client says it happened before.

I have proven I can create a new synonym and it calls the right package.

DBMS_MVIEW fails to invoke the right package - it does not work, it is somehow corrupt.

If my goal was to refresh the table I would just call DBMS_SNAPSHOT with the correct tablename. That is not my goal.

Thank you for trying to help me.