FND Load Script

Open  ftp: oracle/oracle:

Go to directory: cd home

cd oracle

cd visnu ] $ FNDLOAD apps/appspp O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct

XXPPONT_CUSTOMER_TYPE.ldt FND_LOOKUP_TYPE

APPLICATION_SHORT_NAME="FND"

LOOKUP_TYPE="XXPP_NETWORK_HOLD_EXEMPTIONS"

These following are the other entity data types that we can move with FNDLOAD

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 – Descriptive Flexfield with all of specific Contexts

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

DESC_FLEX P_LEVEL=COL_ALL:REF_ALL:CTX_ONE:SEG_ALL

APPLICATION_SHORT_NAME=”FND” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name”

P_CONTEXT_CODE=”context name”

4 – Key Flexfield Structures

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

KEY_FLEX

P_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”

5 – Concurrent Programs

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”

6 – 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”

7 – 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”

8 – 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 – 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 – Responsibilities

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt

FND_RESPONSIBILITY RESP_KEY=”responsibility”

12 – Menus

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt

MENU MENU_NAME=”menu_name”

13 – 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

1. Command to download

FNDLOAD apps_user_name/apps_password 0 Y DOWNLOAD

$ALR_TOP/patch/115/import/alr.lct my_file.ldt ALR_ALERTS

APPLICATION_SHORT_NAME=FND ALERT_NAME=Alert name to download

Usage

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct

CMS.ldt ALR_ALERTS APPLICATION_SHORT_NAME='AR' ALERT_NAME= 'CMSEXCEPTION'

2. Command to upload

FNDLOAD apps_user_name/apps_password 0 Y UPLOAD

$ALR_TOP/patch/115/import/alr.lct my_file.ldt

Usage

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct

CMS.ldt