Enabling Disabled Metadata Objects

Before an object may be copied from seeded metadata it must be enabled. 
The following script should be executed for the R12 module whose object you wish to copy.

SET VERIFY OFF

DECLARE
    p_meta_app_id PLS_INTEGER :=0;
   
Begin

    /* Replace the ‘FA 12.1’ with the appropriate R12 Module */

    Select meta_application_id Into p_meta_app_id
        From tick_meta_applications
    Where META_APPLICATION_NAME = 'FA 12.1';

    Update AM_META_APPLICATIONS ma
    Set ENABLED_FLAG = 'Y'     
    Where META_APPLICATION_NAME = 'FA'
    And MA.META_APPLICATION_VERSION ='12.1';

    Update TICK_TARGET_APPLICATIONS tta
    Set TTA.ENABLED_FLAG = 'Y'     
    Where TTA.APPLICATION_NAME = 'FA 12.1';

    Update TICK_META_APPLICATIONS tma
    Set TMA.ENABLED_FLAG = 'Y'     
    Where TMA.META_APPLICATION_NAME = 'FA 12.1';

    Update TICK_META_APPLICATIONS_OBJECTS mao
    Set enabled_flag = 'Y'
    Where META_APPLICATION_ID = p_meta_app_id --FA 12.1
    And enabled_flag = 'X' ;
   
     commit;
End;