Group Team
FNDLOAD is used to Upload and Download Setup data.
Its is more widely used in projects where setup need to be done between instance.

Process:
a. Run the Download command from instance where setup need to be copied.
b. file_name.ldt is user defined name.
c. Once ldt file is downloaded, move the ldt file to the unix server of the instance where the setup need to be replicated.
d. Run the upload command to replicate the setup.

Below are few FNDLOAD setup commands that can be used.

1. Printer Styles
Download Command:
FNDLOAD username/password@instance O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"


Upload Command:
FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt


2. Lookups
Download Command:
FNDLOAD username/password@instance O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND" LOOKUP_TYPE="lookup name"


Upload Command:
FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt

3. Descriptive Flexfield with all of specific Contexts
Download Command:
FNDLOAD username/password@instance 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"


Upload Command:
FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt


4. Key Flexfield Structures
Download Command:
FNDLOAD username/password@instance 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"

Upload Command:

FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
 
5. Concurrent Programs


Download Command:


FNDLOAD username/password@instance 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"

Upload Command:

FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt
 
6. Value Sets
Download Command:


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

Upload Command:

FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt
 7. Value Sets with values
Download Command:


FNDLOAD username/password@instance O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"
 Upload Command:
FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt

8. Profile Options
Download Command:

FNDLOAD username/password@instance O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile Option" APPLICATION_SHORT_NAME="FND"
 
Upload Command:


FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt
 9. Request Groups

Download Command:


FNDLOAD username/password@instance O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"
 
Upload Command:


FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt
 10. Request Sets


Download Command:


FNDLOAD username/password@instance O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"
 Upload Command:


FNDLOAD username/password@instance O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt
Labels: edit post
1 Response
  1. Sridevi K Says:

    Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.


Post a Comment