Login  Register

Invalids after upgrade to R12.2.10

classic Classic list List threaded Threaded
2 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Invalids after upgrade to R12.2.10

satish
1157 posts
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

Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Invalids after upgrade to R12.2.10

ErmanArslansOracleBlog
Administrator
5727 posts
These are related with flexfields and they are in turn probably related with the localizations.

You may try compiling the flexfields using adadmin.