9 Replies Latest reply on Mar 7, 2018 9:28 PM by Rohit Kumar

    Unable to Install SmartIT 2.0 "User Experience patch"- ARERR 552 because of ORA-00937

    Uwe Ryczek



      i try to install the User Experience patch for SmartIT 2.0.


      The installation failed because the installer is unable to import the "FND:SmartIT Layout Metadata Master" form (which is a view form).


      If i try to import the form with the BMC Remedy Developer Studio the following error is shown:

      Invalid object name 'VW_LAYOUT_METADATA_MASTER'


      the sql log file contains the following entry:

      PreparedStatementCallback; bad SQL grammar []; nested execption is java.sql.SQLSyntaxErrorException : ORA-00937 not a single-group group function.


      After a look at the 'VW_LAYOUT_METADATA_MASTER' view i got headaches.....


      Does someone know a solution for this Problem?






      EDIT: by the way the exception is raised after a "select count(*) from VW_LAYOUT_METADATA_MASTER where rownum =1;"