|
|
Dear Erman,
We found below invalids after upgrade from R12.1.3 to R12.2.10
OBJECT_NAME OBJECT_TYPE OWNER
------------------------------ ----------------------- --------------------------------------------------------------------------------------------------------------------------------
AR_CUSTOMER_PROFILES2_DFV VIEW APPS
AR_CUSTOMER_PROFILE_CLASS2_DFV VIEW APPS
AR_CUSTOMER_PROFILES1_DFV VIEW APPS
AR_CUSTOMER_PROFILE_CLASS1_DFV VIEW APPS
AR_CUSTOMER_PROFILE_AMOUN1_DFV VIEW APPS
RA_ADDRESSES_ALL2_DFV VIEW APPS
RA_SITE_USES_ALL1_DFV VIEW APPS
We tried to compile but no errors reported. Do we have to take any action for these invalids. Please suggest
SQL> alter view AR_CUSTOMER_PROFILES2_DFV compile;
Warning: View altered with compilation errors.
SQL> sho errors;
No errors.
SQL> alter view AR_CUSTOMER_PROFILES1_DFV compile;
Warning: View altered with compilation errors.
SQL> sho errors;
No errors.
Thanks,
Satish
|
Locked
