Bounce Apache Server in Oracle R12

Below step by step to restart apache server :

1. Login to applmgr using putty or others tools

2. Go to directory $INST_TOP/admin/scripts, like image below

3. Stop apache service using command :

     $ sh adapcctl.sh stop

4. Output that script will be appear like image below 

5. Start apache service using command :

     $ sh adapcctl.sh start

6. Output that script will be appear like image below

7. Your apache service has been restarted

Change Site Name and Applet Colour Oracle EBS

In the project, sometimes you need to have differences about Production instance and Non-Production Instance. Oracle EBS can make that differences on colour and site name.

Change Applet Colour EBS 
1. Go to system profile form.
    Navigation : System Administrator  ->  Profile  ->  System
2. In the field "Profile", please insert value "Java Color Scheme", then click find button. Form will be appeared like image below.

3. Please choose appropriate colour under Site Column

4. Save 

Change Site Name EBS 

1. Go to system profile form.

    Navigation : System Administrator  ->  Profile  ->  System
2. In the field "Profile", please insert value "Site Name", then click find button. Form will be appeared like image below.

3. Please put your new name under Site Column
4. Save

Create Activity Suppression Oracle EAM (sample calling API)

DECLARE  

CURSOR stage IS  

    SELECT *    

    FROM staging_suppresion_table

    where flag is null;  

   

l_stat varchar2(100);    

l_count number;    

l_data varchar2(100);    

v_stat varchar2(1) := 'S';    

v_parent_association_id  number;

v_child_association_id  number;

BEGIN    

    FOR i IN stage LOOP    

       

       select activity_association_id

       into v_parent_association_id

       from mtl_eam_asset_activities

       where asset_activity_id=i.parent_activity_id;

       

       select activity_association_id

       into v_child_association_id

       from mtl_eam_asset_activities

       where asset_activity_id=i.child_activity_id;

        EAM_ActivitySupn_PUB.INSERT_ACTIVITYSUPN    

        (    

            p_api_version               => 1.0    

            , x_return_status           => l_stat    

            , x_msg_count               => l_count    

            , x_msg_data                => l_data    

            , p_parent_association_id   => v_parent_association_id    

            , p_child_association_id    => v_child_association_id 

            , p_tmpl_flag               => 'N'    

        );    

        update staging_suppresion_table

        set flag=l_stat,

            note=substr(l_data,5,length(l_data))

        where parent_activity_id=i.parent_activity_id

              and child_activity_id=i.child_activity_id;  

              

       commit;

       

           

    END LOOP;    

        

        

    IF v_stat <> 'E' THEN    

       COMMIT;    

    END IF;    

END;