Oracle Apps Technical Information

FND_LOAD commands. Posted by  Arun Kumar S.R   at 3:35 AM FND in Oracle: 1. FND is short for “Foundation” which was the name Oracle initially wanted to use for the Application Object Library- the application with common components shared between all the other applications in the Oracle E-Business Suite. Profile Options: Source: FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XXPRNAME.ldt PROFILE PROFILE_NAME="XXPRNAME" APPLICATION_SHORT_NAME="PN" Target: 1. FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XXPRNAME.ldt 2. FNDLOAD apps/apps 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afscprof.lct XXPRNAME.ldt PROFILE PROFILE_NAME=" XXPRNAME" APPLICATION_SHORT_NAME="PN" Forms: Source: FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXFRMNAME.ldt FORM APPLICATION_SHORT_NAME="PN" FORM_NAME="XXFRMNAME" Target: FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/...

Version :  SELECT * FROM V$VERSION; Installed Modules : select * from (select   substr(a.APPLICATION_NAME,1,60) "AN" ,  substr(i.PRODUCT_VERSION,1,4)  "Version" ,  i.PATCH_LEVEL    "Patch Level" ,  i.APPLICATION_ID   "Application ID" ,  i.LAST_UPDATE_DATE   "Last Update" from   APPS.FND_PRODUCT_INSTALLATIONS  i ,  APPS.FND_APPLICATION_ALL_VIEW  a where   i.APPLICATION_ID   = a.APPLICATION_ID --  not all applications update the next field correctly --  and i.PATCH_LEVEL   like '11i%' --  these are the applications that concern me most --  and i.APPLICATION_ID in   ('0','140','260','101','200','275','201','222','185') order by a.APPLICATION_NAME) --where AN like  ('%CPC%')  

www.w3schools.com

CREATE DATABASE LINK one_next CONNECT TO apps-- User Name 2 nd Db or Instance IDENTIFIED BY apps-- pwd 2 nd Db or Instance USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.0.183)(PORT = 1523)) ) (CONNECT_DATA = (SERVICE_NAME = prod) ) )'; after creating Db Link Access The 3rd party Ex: select * from po_vendors@one_next