5 Replies Latest reply on Aug 16, 2018 4:34 AM by Beauty_and_dBest

    Invalid View FND_IREP_ALL_INTERFACES

    Beauty_and_dBest

      EBS 12.2.7

      12c

      OL6

       

      Hi ALL,

       

      I have invalid view FND_IREP_ALL_INTERFACES  in APPS schema.

       

      I tried to run:

       

      SQL> alter view FND_IREP_ALL_INTERFACES compile;

       

      Warning: View altered with compilation errors.

       

      SQL> show error

      No errors.

      SQL>

       

       

      How do I get the error in view please...

       

       

      Kind regards,

      jc

        • 1. Re: Invalid View FND_IREP_ALL_INTERFACES
          John_K

          After compilation, please run:

           

          select * from user_errors where name='FND_IREP_ALL_INTERFACES';

          • 2. Re: Invalid View FND_IREP_ALL_INTERFACES
            Beauty_and_dBest

            Thanks John

             

             

            I will riun that...brb

            • 3. Re: Invalid View FND_IREP_ALL_INTERFACES
              Beauty_and_dBest

              SQL>  alter view FND_IREP_ALL_INTERFACES compile;

               

              Warning: View altered with compilation errors.

               

              SQL> select * from user_errors where name='FND_IREP_ALL_INTERFACES';

               

              NAME

              --------------------------------------------------------------------------------

              TYPE           SEQUENCE       LINE   POSITION

              ------------ ---------- ---------- ----------

              TEXT

              --------------------------------------------------------------------------------

              ATTRIBUTE MESSAGE_NUMBER

              --------- --------------

              FND_IREP_ALL_INTERFACES

              VIEW                  1          0          0

              ORA-04063: view "APPS.FND_IREP_CLASSES_VL" has errors

              ERROR                  0

               

               

               

              SQL> alter view FND_IREP_CLASSES_VL compile;

               

              Warning: View altered with compilation errors.

               

              SQL> select * from user_errors where name='FND_IREP_CLASSES_VL';

               

              NAME

              --------------------------------------------------------------------------------

              TYPE           SEQUENCE       LINE   POSITION

              ------------ ---------- ---------- ----------

              TEXT

              --------------------------------------------------------------------------------

              ATTRIBUTE MESSAGE_NUMBER

              --------- --------------

              FND_IREP_CLASSES_VL

              VIEW                  1          0          0

              ORA-00904: "B"."IREP_RESOURCE_PATH": invalid identifier

              ERROR                  0

               

               

              SQL>

               

               

              How to resolve invalid identifier?

               

               

              Kind regards,

              • 4. Re: Invalid View FND_IREP_ALL_INTERFACES
                John_K

                This could be very similar to your other problem with the editioning view? The _VL is complaining it can't find the column FND_IREP_CLASSES.IREP_RESOURCE_PATH. Check whether that exists on APPLSYS.FND_IREP_CLASSES, and on APPS.FND_IREP_CLASSES#. If not the latter then it might be worth trying the table upgrade on this one too.

                • 5. Re: Invalid View FND_IREP_ALL_INTERFACES
                  Beauty_and_dBest

                  Thanks friend,

                   

                  I will try that later, anyways the functional people was able to resume setup after the clean compile of the FA_DEPRN_SUMMARY PKG.