Technology Stack - EBS (MOSC)

MOSC Banner

aftcm046.sql executin time..

edited Aug 20, 2021 11:19AM in Technology Stack - EBS (MOSC) 3 commentsAnswered
 Hi , i have cloned a test instance sucessfully,but all the concurrent managers fail to startup .
to resolve the issue i refered note id:434613.1 where it is mentioned to execute the following script....
CREATE OR REPLACE TRIGGER fndsm
  AFTER INSERT 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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center