Invalids after upgrade to R12.2.10

Posted by satish on May 05, 2023; 9:11am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Invalids-after-upgrade-to-R12-2-10-tp11848.html

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