FDPSTP failed due to ORA-04063: package body "APPS.MSC_CL_PULL" has errors
hi
I'm getting below error
ATP Data Pull
ORACLE error 4063 in FDPSTP
Cause: FDPSTP failed due to ORA-04063: package body "APPS.MSC_CL_PULL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.MSC_CL_PULL"
ORA-06512: at line 1
then I have checked the APPS.MSC_CL_PULL and the package is invalid.
while trying to recompile the package ,I'm getting below errors.
SQL> alter package APPS.MSC_CL_PULL compile;
Warning: Package altered with compilation errors.
SQL> alter package APPS.MSC_CL_PULL compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors