SAP Note 23816 - Procedures (PL/SQL) in Oracle

Symptom:

PL/SQL export import

Cause and prerequisites

Procedures invalid after import.

Solution
Stored procedures are exported on export in the user mode, set to import invalid and must be recomplied after the import with COMPILE ALL. Once this has been done, they have the status 'valid'.