Problem:
I applied patch 10338643,this patch was solved my problem,but it generate 5 invalid in apps schema.
Invalid objects:
OE_ORDER_GRP
OE_OE_FORM_LOT_SERIAL
OE_DEFAULT_LOT_SERIAL
OE_DEFAULT_LINE_PATTR
OE_OE_FORM_HEADER_PAYMENT
I compiled apps schema via adadmin,I compiled these packages via alter package <package_name> compile;but these packages are
invalid.I am getting PLS-00801 on compiling this objects.I followed this document below:
Getting PLS-00801 on compiling various ONT packages [ID 1062560.1]
Then I create a SR,then my problem was resolved.
Solution:
as a database user
sqlplus / as sysdba
SQL>shutdown immediate;
SQL>startup nomount
SQL>alter system set "_disable_fast_validate"=TRUE SCOPE=pfile
SQL>create spfile from pfile
SQL>shutdown immediate;
SQL>startup upgrade;
SQL>@?/rdbms/admin/utlirp.sql
SQL>shutdown immediate
SQL>startup
SQL>@?/rdbms/admin/utlrp.sql
All objects will be invalid via utlirp.sql,then utlrp.sql will compile them.
Note:"?" means $ORACLE_HOME
Hiç yorum yok:
Yorum Gönder