Date: Fri, 20 Aug 1999 14:35:36 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Script to transfer Menus, REsp.s from ONE instacne to ANOTHER
Message-ID: BB3B8E2BD7EED211935500A0C9C74B7B618960@exch-grimm.btg.com

All,

We are upgrading from 11.0.28 to 11.0.3 and I used folllowing scripts to
transfer menus from
CRP ( a development instace ) instacne to the brand new Blank copy of 11.0.3
intance.

Everything went fine when I checked from Define Menus screen.
All the details were looking fine.

I also transferred Resp.s in the same way as shown here.

After doing all this , I assigned one resp. to SYSADMIN and entered into the
new resp.
But I am getting FRM-40375: PRE-FORM trigger raised unhandled exception
error NO_DATA_FOUND
for some menu items.

PLEASE LET ME KNOW WHAT MIGHT BE THE PROBLEM.

I checked ENter Menus screen and Enter Resp.s screen in both CRP and the
OTHER instance.
Everything was looking fine.

+++++++++++++++++++++++++++++++++++++++++++
TWO extra menus have been created in the upgrade and hence I had to add 2 to
menu_ids.

insert into fnd_menus
(
MENU_ID,
MENU_NAME,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATION_DATE,
CREATED_BY
)
select
menu_id+2,
MENU_NAME,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
CREATION_DATE,
CREATED_BY
from fnd_menus@appscrp where menu_id  69438;

insert into fnd_menus_tl
(
 LANGUAGE,
 MENU_ID ,
 USER_MENU_NAME,
 LAST_UPDATE_DATE,
 LAST_UPDATED_BY ,
 LAST_UPDATE_LOGIN ,
 CREATION_DATE     ,
 CREATED_BY        ,
 DESCRIPTION       ,
 SOURCE_LANG
)
select
 LANGUAGE,
 MENU_ID+2 ,
 USER_MENU_NAME,
 LAST_UPDATE_DATE,
 LAST_UPDATED_BY ,
 LAST_UPDATE_LOGIN ,
 CREATION_DATE     ,
 CREATED_BY        ,
 DESCRIPTION       ,
 SOURCE_LANG
 from fnd_menus_tl@appscrp where menu_id > 69438;

insert into fnd_menu_entries
(
MENU_ID ,
ENTRY_SEQUENCE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY  ,
LAST_UPDATE_LOGIN,
CREATION_DATE    ,
CREATED_BY       ,
SUB_MENU_ID      ,
FUNCTION_ID
)
select
MENU_ID+2 ,
ENTRY_SEQUENCE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY  ,
LAST_UPDATE_LOGIN,
CREATION_DATE    ,
CREATED_BY       ,
SUB_MENU_ID      ,
FUNCTION_ID
from fnd_menu_entries@appscrp where menu_id > 69438;

insert into fnd_menu_entries_tl
(
 LANGUAGE,
 MENU_ID ,
 ENTRY_SEQUENCE                  ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 LAST_UPDATE_LOGIN               ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 PROMPT                          ,
 DESCRIPTION                     ,
 SOURCE_LANG
)
select
 LANGUAGE,
 MENU_ID+2 ,
 ENTRY_SEQUENCE                  ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 LAST_UPDATE_LOGIN               ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 PROMPT                          ,
 DESCRIPTION                     ,
 SOURCE_LANG
 from fnd_menu_entries_tl@appscrp where menu_id > 69438;

update fnd_menu_entries set sub_menu_id=sub_menu_id +2 where sub_menu_id >
69438;
commit;

+++++++++++++++++++++++++++++++++++++++++
+++++++++++TRANSFER RESP.s script below +++++++++++++++++
insert into fnd_responsibility
(
 APPLICATION_ID   ,
 RESPONSIBILITY_ID,
 LAST_UPDATE_DATE ,
 LAST_UPDATED_BY  ,
 CREATION_DATE    ,
 CREATED_BY       ,
 LAST_UPDATE_LOGIN ,
 DATA_GROUP_APPLICATION_ID  ,
 DATA_GROUP_ID              ,
 MENU_ID                    ,
 START_DATE                 ,
 END_DATE                   ,
 GROUP_APPLICATION_ID       ,
 REQUEST_GROUP_ID           ,
 VERSION                    ,
 WEB_HOST_NAME              ,
 WEB_AGENT_NAME             ,
 RESPONSIBILITY_KEY
)
select
 APPLICATION_ID   ,
 RESPONSIBILITY_ID,
 LAST_UPDATE_DATE ,
 LAST_UPDATED_BY  ,
 CREATION_DATE    ,
 CREATED_BY       ,
 LAST_UPDATE_LOGIN ,
 DATA_GROUP_APPLICATION_ID  ,
 DATA_GROUP_ID              ,
 MENU_ID                    ,
 START_DATE                 ,
 END_DATE                   ,
 GROUP_APPLICATION_ID       ,
 REQUEST_GROUP_ID           ,
 VERSION                    ,
 WEB_HOST_NAME              ,
 WEB_AGENT_NAME             ,
 RESPONSIBILITY_KEY
 from fnd_responsibility@appscrp where responsibility_id > 50000
/

update fnd_responsibility set menu_id = menu_id+2 where menu_id > 69438
/

commit
/

insert into fnd_responsibility_tl
 (
 APPLICATION_ID     ,
 RESPONSIBILITY_ID  ,
 LANGUAGE           ,
 RESPONSIBILITY_NAME,
 CREATED_BY         ,
 CREATION_DATE      ,
 LAST_UPDATED_BY    ,
 LAST_UPDATE_DATE   ,
 LAST_UPDATE_LOGIN  ,
 DESCRIPTION        ,
 SOURCE_LANG
)
select
 APPLICATION_ID     ,
 RESPONSIBILITY_ID  ,
 LANGUAGE           ,
 RESPONSIBILITY_NAME,
 CREATED_BY         ,
 CREATION_DATE      ,
 LAST_UPDATED_BY    ,
 LAST_UPDATE_DATE   ,
 LAST_UPDATE_LOGIN  ,
 DESCRIPTION        ,
 SOURCE_LANG
from fnd_responsibility_tl@appscrp where responsibility_id > 50000;
commit;
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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