FNDLOAD Upload and Download Commands For Different AOL Components

FNDLOAD Upload and Download Commands For Different AOL Components

FNDLOAD Command To Downlod Printer Styles
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct xxaoa_file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

FNDLOAD Command To Downlod Lookups

FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct xxaoa_file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="prod" LOOKUP_TYPE="lookup name"

FNDLOAD Command To Downlod Descriptive Flexfield with all of specific Contexts
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxaoa_file_name.ldt DESC_FLEX P_LEVEL=:COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME="prod" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"

FNDLOAD Command To Downlod Multiple Flexfields:
Use a combination of APPLICATION_SHORT_NAME and DESCRIPTIVE_FLEXFIELD_NAME names ie. APPLICATION_SHORT_NAME=PER >> will download all PER flexfields DESCRIPTIVE_FLEXFIELD_NAME=PER_% >> will download all flexfields that start with ‘PER_’.

FNDLOAD <username>/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxaoa_file_name.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME="PER_%"

FNDLOAD Command To Downlod Key Flexfield Structures:
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxaoa_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="prod" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

FNDLOAD Command To Downlod Concurrent Programs:
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct xxaoa_file_name.ldt PROGRAM APPLICATION_SHORT_NAME="prod" CONCURRENT_PROGRAM_NAME="concurrent name"

FNDLOAD Command To Downlod Value Sets:
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxaoa_file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

FNDLOAD Command To Downlod Value Sets with values:
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct xxaoa_file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

FNDLOAD Command To Downlod Profile Options:
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct xxaoa_file_name.ldt PROFILE PROxxaoa_file_name="profile option" APPLICATION_SHORT_NAME="prod"


FNDLOAD Command To Downlod Request Group:

FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct xxaoa_file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group"APPLICATION_SHORT_NAME="prod"

FNDLOAD Command To Downlod Request Sets:
- DOWNLOAD -- Request set Def   --

FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <xxaoa_filename.ldt> REQ_SET REQUEST_SET_NAME=<request set name>

DOWNLOAD     -- Request set link   --
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <xxaoa_filename.ldt> REQ_SET_LINKS REQUEST_SET_NAME=<request set link name>

FNDLOAD Command To Downlod Responsibilities

FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct xxaoa_file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"

FNDLOAD Command To Downlod Responsibilities with all Security Groups:
FNDLOAD <username>/<PASSWORD> 0 Y DOWNLOAD FND_TOP/patch/115/import/afscursp.lct <USER>.ldt FND_USER USER_NAME="<USER>" SECURITY_GROUP=% DATA_GROUP_NAME=%


Notes for using FNDLOAD against FND_USER:-

1. After uploading using FNDLOAD, user will be promoted to change their password again during their next signon attempt.
2. All the responsibilities will be extracted by FNDLOAD alongwith User Definition in FND_USER
3. In the Target Environment, make sure that you have done FNDLOAD for new responsibilities prior to running FNDLOAD on users.

FNDLOAD Command To Downlod Menus:
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxaoa_file_name.ldt MENU MENU_NAME="menu_name"

FNDLOAD Command To Downlod Forms/Functions/Personalizations:
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <xxaoa_file_name.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>
OR
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxaoa_file_name.ldt FUNCTION FUNCTION_NAME=<function_name>
OR
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct xxaoa_file_name.ldt FORM FORM_NAME=<form_name>
OR
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <xxaoa_file_name.ldt> FND_FORM_CUSTOM_RULES function_name=<function name>

FNDLOAD Command To Downlod User/Responsibilities:
FNDLOAD <username>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct xxaoa_file_name.ldt FND_USER

FNDLOAD Command To Downlod Alert:
FNDLOAD <username>/<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

FNDLOAD Command To Downlod Blob:
FNDLOAD <username>/<password> 0 Y mode configfile datafile entity [ param ... ]

FNDLOAD Command To Downlod Overwrite custom definitions:
FNDLOAD <username>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/.lct $XX_TOP/import/.ldt CUSTOM_MODE=FORCE


How To Transfer Custom Messages to another Instance:
a. Download the message from the source instance.
FNDLOAD <username>/<password> 0 Y DOWNLOAD @FND:patch/115/import/afmdmsg.lct password.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=FND MESSAGE_NAME=PASSWORD-INVALID-NO-SPEC-CHAR
b. Move the custom LDT file (password.ldt) over to the destination instance.
c. Upload the custom message to the destination instance.
FNDLOAD <username>/<password> 0 Y UPLOAD @FND:patch/115/import/afmdmsg.lct password.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=FND CUSTOM_MODE=FORCE

XML DATA DEFINITION:
FNDLOAD <username>/<password> O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct <xxaoa_filename.ldt> XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=<application shortname>DATA_SOURCE_CODE=<data source code > TMPL_APP_SHORT_NAME=<template application short name>TEMPLATE_CODE=<template code>
The Above command downloads all the templates defined for this Particular Data Definition. For a particular template to be downloadeduse

FNDLOAD <username>/<password> 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct <xxaoa_filename.ldt> XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=<application shortname>DATA_SOURCE_CODE=<datadefshortcode> TMPL_APP_SHORT_NAME==<template application short  name> TEMPLATE_CODE= <templatecode>

How TO Migrate Work Flows From One Instance to other:
WFLOAD <username>/<password> 0 Y DOWNLOAD <xxaoa_filepath.wft> <item type>

Execute Following Command to upload the workflow to target instance:

WFLOAD <username>/<password> 0 Y UPLOAD <xxaoa_filepath.wft>

UPLOAD UPLOAD COMMANDS For Different AOL Components:

Note: UPLOAD command is same for all except replacing the .lct and passing any extra parameters if you want to pass

FNDLOAD Command To upload Ldt file for a Concurent Program
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a Data Definition
FNDLOAD <username>/<password> O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a Request Set
FNDLOAD <username>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a Request Set Links
FNDLOAD <username>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a Lookup Up
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a request group for a Concurrent Program
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a request group for a Request Set
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a Value Set
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a Value Set with values
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a DFF
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a DFF for a particular attribute column
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a profile Option
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt

FNDLOAD Command To upload Ldt file for a Audit Group
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/affaudit.lct file_name.ldt

FNDLOAD Command  To upload Ldt file for a Audit Schema
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/affaudit.lct file_name.ldt

FNDLOAD Command  To upload Ldt file for a Responsibility
FNDLOAD <username>/<password> O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt


FNDLOAD Command  To upload Ldt file for a XML Data Definition
UPLOAD 
FNDLOAD <username>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct <xxaoa_filename.ldt>
FNDLOAD <username>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct <xxaoa_filename.ldt>

FNDLOAD <username>/<password> O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct <xxaoa_filename.ldt> XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=<application short name>DATA_SOURCE_CODE=<data source code > TMPL_APP_SHORT_NAME=<template application short  name>TEMPLATE_CODE=<template code>

FNDLOAD <username>/<password> O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct <xxaoa_filename.ldt>

The Above command downloads all the templates defined for this Particular Data Definition. For a particular template to be downloaded use

FNDLOAD <username>/<password> O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct <xxaoa_filename.ldt>

FNDLOAD Command to upload ALERTS
FNDLOAD <username>/<password> 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct  <ldt filename>


FNDLOAD Command TO Upload an NLS Language:
FNDLOAD <username>/<password> 0 Y UPLOAD <controlfile.lct> <datafile.ldt> \
- UPLOAD_MODE=NLS CUSTOM_MODE=FORCE WARNINGS=TRUE