exec ad_zd_seed.prepare

Hi,

On 12.2.5 DB 12.1.0

Adop prepare fails with:

ERROR] Error Message:

[ERROR] ORA-04098: trigger 'APPS.FND_PROFILE_OPTION_VALUES>' is invalid and failed re-validation

[ERROR] ORA-06512: at "APPS.AD_ZD_SEED", line 1663

I tried (following Doc  2002605.1

)

SQL> exec ad_zd_seed.prepare('FND_PROFILE_OPTION_VALUES');

BEGIN ad_zd_seed.prepare('FND_PROFILE_OPTION_VALUES'); END;

*

ERROR at line 1:

ORA-04098: trigger 'APPS.FND_PROFILE_OPTION_VALUES>' is invalid and failed

But when connected to database with sqldevloper:

exec ad_zd_seed.prepare('FND_PROFILE_OPTION_VALUES');

anonymous block completed

For me it means success.

Can someone be kind and explain me why in PATCH file edition it fails?