7 March 2014

Various usages of FNDLOAD Command in R12

1 - Printer Styles
 

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

2 - Lookups

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND" LOOKUP_TYPE="lookup name" 

3 - Key Flexfield Structures 
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEXP_LEVEL=’COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL’ APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"


4 - Concurrent Programs
 
Download 

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name"


Upload

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt WARNINGS=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

5 - Value Sets

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

6 - Value Sets with values

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"
 

7 - Profile Options
 

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

8 - Profile option at responsibility level

FNDLOAD apps/password@connect_identifier 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="GL_SET_OF_BKS_ID" APPLICATION_SHORT_NAME="SQLGL" LEV="RESPONSIBILITY" LEV_NAME="KR OIE SELF SERVICES EXPENSES"
 

9 - Request Groups
 

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

10 - Request Sets

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET
APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"
 

11 - Request Set links

FNDLOAD apps/devdr4u 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET_LINKS REQUEST_SET_NAME='FNDRSSUB1380'


12 - Responsibilities
 

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"
 

13 - Menus

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"
 

14 - Forms Personalization

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES function_name=FUNCTION_NAME
 

15 - User Creation

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct File_name.ldt FND_USER USER_NAME=’user name'
 

16 - Grants

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct
file_name.ldt GRANT GNT_MENU_NAME=<GRANTED_MENU>
 

17 - Alerts
 

FNDLOAD  apps/  0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct file_name.ldt ALR_ALERTS APPLICATION_SHORT_NAME="alert shprt name" ALERT_NAME="alert name"

18 - Download FND Messages


For the entire message names which starts with XX_MESSAGE,
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct
file_name.ldt FND_NEW_MESSAGES MESSAGE_NAME=XX_MESSAGE%
 

For a particular message XXT_REGN_SUCCESS
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct file_name.ldt FND_NEW_MESSAGES MESSAGE_NAME= XXT_REGN_SUCCESS

19 - Functions


FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct
file_name.ldt FUNCTION FUNCTION_NAME=<YOUR FUNCTION NAME>

20 - AK Attributes


java oracle.apps.ak.akload apps apps THIN "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host =
<DB_HOSTNAME>)(Port = <DB_PORT>)) (CONNECT_DATA = (SID = <DB_SID>)))" DOWNLOAD
file_name.ldt GET CUSTOM_REGION AMS AMS_ASSOCIATE_DELV
AMS - Application Short Name

21 - WFLOAD 


WFLOAD apps/apps 0 Y DOWNLOAD APEXP.wft APEXP

22 - Data source &  Template Definition

FNDLOAD apps/apps O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXNAME' DATA_SOURCE_CODE='XX_SOURCE_CODE' TMPL_APP_SHORT_NAME='XXNAME' TEMPLATE_CODE='XX_SOURCE_CODE'

8 comments: