3 Replies Latest reply on May 12, 2016 3:11 AM by Ramaraju

    How to register custom top which was not setup correctly, not registered with adsplice

    al_dba87
      Friends,
      We are on R12.2.3 with DB version 11.2.0.3, during implementation phase we created the custom top however didn't register it using adspilce. Can we register the custom top now as there is custom code present in custom top now.
      Is there any impact of registering it now on existing functionality ?



      Also, if I go with adsplice registration now using (Doc ID 1577707.1), Can I use the same custom code name. ( Current custom top is XXTB so can I use the same while registering it with adsplice).


      I have gone through 1577707.1 note and below is the details I could capture pertaining to our current custom top (XXTB) which we need to know whether registered or not, if not how to register it.

       

      1) I dont find txt files for custom top xxtb in $APPL_TOP/admin

      [appldev@oraupgrade ~]$ cd $APPL_TOP/admin

      [appldev@oraupgrade admin]$ ls -ltr xxtb*

      ls: cannot access xxtb*: No such file or directory

       

      2) Custopm top not present in custom file.

      [appldev@oraupgrade xxtb]$ grep -i xxtb $CONTEXT_FILE

      [appldev@oraupgrade xxtb]$

       

      3) Custom top listing

      [appldev@oraupgrade admin]$ cd $XXTB_TOP

      [appldev@oraupgrade xxtb]$ ls

      admin custdocs forms inbound lib media oracle publisher sql

      bin delivery help install log mesg out rep

      CEMLI_E_GL_01.0_V002 fix_del_receipt_R12.lst html java mds META-INF patch reports xml

      [appldev@oraupgrade xxtb]$

       

      4) Executed query from note which can help you to suggest

       

      SQL> select * from fnd_application where application_short_name = 'XXTB';

      APPLICATION_ID APPLICATION_SHORT_NAME LAST_UPDATE_DAT LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN BASEPATH

      -------------- -------------------------------------------------- --------------- --------------- --------------- ---------- ----------------- --------------------

      PRODUCT_CODE ZD_EDITION_NAME

      -------------------------------------------------- ------------------------------

      20003 XXTB 19-NOV-09 0 19-NOV-09 0 146971 XXTB_TOP

      XXTB ORA$BASE

       

       

      SQL>

      SQL>

      SQL> select * from fnd_product_installations where APPLICATION_ID =20003;

       

      no rows selected

      SQL> select * from dba_users where username = 'XXTB';

       

      USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE

      ------------------------------ ---------- ------------------------------ -------------------------------- --------------- --------------- ------------------------------ ------------------------------

      CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP

      --------------- ------------------------------ ------------------------------

      EXTERNAL_NAME

      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      PASSWORD E AUTHENTI

      -------- - --------

      XXTB 288 OPEN APPS_TS_TX_DATA TEMP

      14-FEB-15 DEFAULT DEFAULT_CONSUMER_GROUP

       

      10G Y PASSWORD



      Thanks

      Altaf