java.sql.SQLException: ORA-04098: trigger 'APPS.FNDSM' is invalid and failed re-validation

Please Visit http://www.conacent.com/?page_id=218


Problem -

java.sql.SQLException: ORA-04098: trigger 'APPS.FNDSM' is invalid and failed re-validation

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
    at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
    at oracle.apps.ad.tools.configuration.NetServiceHandler.updateNodeIdIfNull(NetServiceHandler.java:357)
    at oracle.apps.ad.tools.configuration.NetServiceHandler.main(NetServiceHandler.java:2953)
AC-50480: Internal error occurred: java.sql.SQLException: ORA-04098: trigger 'APPS.FNDSM' is invalid and failed re-validation

Solution -

1. SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
2. SQL> commit;
3. Compile the FNDSM trigger by connecting as apps
    SQL> alter trigger fndsm compile;






   (If compilation error occurs then Run this script)
    CREATE OR REPLACE TRIGGER fndsm
    AFTER INSERT OR UPDATE ON FND_NODES
    FOR EACH ROW
    BEGIN
      if ( :new.NODE_NAME <> 'AUTHENTICATION' ) then
         if ( (:new.SUPPORT_CP='Y')
              or (:new.SUPPORT_FORMS='Y')
              or (:new.SUPPORT_WEB='Y') ) then
             fnd_cp_fndsm.register_fndsm_fcq(:new.NODE_NAME);
         end if;
         if (:new.SUPPORT_CP = 'Y') then
             fnd_cp_fndsm.register_fndim_fcq(:new.NODE_NAME);
        end if;
       end if;
    END;


4. run autoconfig on dbtier and then followed by appstier
5. start the middle tier.