FNDLOAD

FNDLOAD Options --

1 - Printer Styles
FNDLOAD apps/apps pwd 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 pwd O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND" LOOKUP_TYPE="lookup name"

FNDLOAD apps/apps pwd O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt

3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps pwd 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 pwd 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 pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent program short name"

FNDLOAD apps/apps pwd O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt

SQL> select application_short_name from fnd_application;

6 - Value Sets
FNDLOAD apps/apps pwd 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 pwd 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 pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

Select application_id,PROFILE_OPTION_NAME =PROFILE OPTION ID
USER_PROFILE_OPTION_NAME from FND_PROFILE_OPTIONS_VL
Where PROFILE_OPTION_NAME like ‘UPPER %profile option name ‘
Order by PROFILE_OPTION_NAME

FNDLOAD apps/apps pwd O Y $FND_TOP/patch/115/import/afscprof.lct file_name.ldt

9 - Request Groups
FNDLOAD apps/apps pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

FNDLOAD apps/apps pwd O Y UPLOAD $FND_TOP/patch/115/import/afcprepqg.lct

10 - Request Sets
FNDLOAD apps/apps pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SETAPPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"

SELECT request set name from fnd_requests_sets_vl where user_request_set_name=’user name ‘

FNDLOAD apps/apps pwd OY UPLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt

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

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

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

Select user_menu_name from fnd_menues_vl where menu_name=’xx’

FNDLOAD apps/apps pwd O Y UPLOAD $FND_LOAD/patch/115/import/afsload.lct file_name.ldt

13 – users
FNDLOAD apps/apps pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afscurp.lct file_name.ldt
FND_USER USER_NAME=”XYX”

Printers / Print queues / Executables Printers / Print queues / Executables.
Roles / Responsibilities / Forms Roles / Responsibilities / Forms.
Menus / Users / Request Sets Menus / Users / Request Sets.
Request Groups / Request Queues Request Groups / Request Queues.
Work shifts / Programs / Libraries Work shifts / Programs / Libraries.
Attachments / Help Files Attachments / Help Files.
Mime Types Mime Types.
Security Information.

Metalink Note id -- 274667.1


.ldt converted data file
.lct configuration file