EBS : FND LOAD Scripts, LDT File (Oracle APPS)

FNDLOAD

The FNDLOAD loader program can move the EBS data between database and text file representations.
This is an Oracle utility provided by Oracle for the transfer of a wide range of Oracle Foundation (FND) data from one instance to another instance. This can be defined as a concurrent program that can move Oracle Apps data between database and text file or this can be defined as FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database very easily.

Its help to move the setup from once instance to another instance like Concurrent Program, Alerts, Lookup, Personalization,Data Definitions ,Template,Function etc.

How FNDLOAD Works

The Conversion between database format and text file format is specified by a configuration file in Oracle Apps. Oracle Apps does provide a confirmation file and it is important to just pass the configuration file name and then just call the loader and leave everything.

List of .lct file (Configuration File)

afcpprog.lct : Concurrent Program Definitions

afcprset.lct : Concurrent Request Sets

afffload.lct : Flexfields (KFF, DFF, value sets, value sets data)

aflvmlu.lct : Lookup types and codes

afscprof.lct : Profiles and Profile Values

afscursp.lct : Security data (users, responsibilities, etc)

afsload.lct : Menu / Function Security Data•Lookup Types

afattach.lct : Load attachments setup data

afcppstl.lct: : Concurrent Program Printer Styles

afcpreqg.lct : Concurrent Request Groups

Steps of Creating LDT file:-

1)Login to Application Server using WInscp -> Navigate to path like /home directory where you want to download ldt file.

2).ldt file shall always create in the directory where the fnd_load command will execute

2) Once Downloaded move to local directory and then move to target directory where its need to be uploaded.

----------Concurrent Program------------

Download:-

$FND_TOP/bin/FNDLOAD apps/alam  O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXX_GST_APXINRIR.ldt 

Upload:-

$FND_TOP/bin/FNDLOAD apps/alam64 O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXPROMISE_DATE_CALC_CP.ldt

------Personalization-------

Download:-

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XXHIL_PO_UPD_BPA.ldt FND_FORM_CUSTOM_RULES function_name='PO_POXPOEPO' RULE_KEY='XXO_UPD_BPA'

Upload:-

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_PROMISE_DT.ldt

----------Valueset download----------------------------------------------------------------

Download:-

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXSANCTION_DISC_TYPE.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME ='XXSANCTION_DISC_TYPE'

Upload:-

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXSANCTION_DISC_TYPE_VL.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME='XXOM_SANCTION_DISC_TYPE'

-------DATA DEFINITIONS---------------

$FND_TOP/bin/FNDLOAD apps/clone 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_GST_CASH_REGS_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="XX"  DATA_SOURCE_CODE="XX_GST_CASH_REGS" TMPL_APP_SHORT_NAME="XX" TEMPLATE_CODE="XX_GST_CASH_REGS"

-------DataDefintions and Template---

Download:-

Upload:-

FNDLOAD apps/techhards 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct $XXX_TOP/XXX_GST_APXINRIR_DD.ldt

---Upload RTF---------------------------------------------

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD B6gggggg -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=auohsitutxd09.oracleoutsourcing.com)(PORT=16710))(CONNECT_DATA=(SERVICE_NAME=DITU6I)))' -LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME XXX -LOB_CODE XXX_GST_APXINRIR -LANGUAGE en -TERRITORY IN -XDO_FILE_TYPE RTF -FILE_NAME $XXX_TOP/XXX_GST_APXINRIR.rtf -OWNER apps -CUSTOM_MODE FORCE

--------Upload Bursting--------

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD B6zOC8qb -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=9192.168.0.1)(PORT=167154)(CONNECT_DATA=(SERVICE_NAME=1111I)))' -LOB_TYPE BURSTING_FILE -LOB_CODE XXX_GST_BIP_POXPRPOP -XDO_FILE_TYPE XML -FILE_NAME $XXX_TOP/XXX_GST_PO_PRINT_BURST_CONTROL2.xml -APPS_SHORT_NAME XXX -NLS_LANG 00 -TERRITORY 00 -LOG_FILE $LOG_FILE_NAME

-------Valueset-----------

Download:-

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_SANC_DISC_TYPE.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME ='XX_SANC_DISC_TYPE'

Upload:-

---------Oracle Form-----

Download:-

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct FABIL003_form.ldt FORM APPLICATION_SHORT_NAME="XX" FORM_NAME="FABIL003"

Upload:-

--------Oracle Form Func-----

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXHIL_PO_REQ_IMP_INTG.ldt FUNCTION FUNC_APP_SHORT_NAME="XXHIL" FUNCTION_NAME="XXHIL_PO_REQ_IMP_INTG"

--Oracle Function other than forms-

Download:-

$FND_TOP/bin/FNDLOAD apps/TECHHARDS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct TECHHARDS_PO_REQ_IMP_INTG_FUNC.ldt FUNCTION FUNCTION_NAME="TECHHARDS_PO_REQ_IMP_INTG"

Upload:-

*******Workflow******************

Download:-

WFLOAD apps/apps  0 Y DOWNLOAD XXTECHHARDS_POWFRQAG.wft POWFRQAG

Upload:-

WFLOAD apps/apps 0 Y FORCE XXTECHHARDS_POWFPOAG.wft

-------Lookup-----------

Download:-

$FND_TOP/bin/FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_OM_DEV_REMARKS.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME='ONT' LOOKUP_TYPE='XX_OM_DEV_REMARKS'

Upload:-

---Profile Options----------------------------------------------------------

Download:-

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

Upload:-

$FND_TOP/bin/FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XXHIL_OM_DOM_MKTG_ROLE_PRF.ldt PROFILE PROFILE_NAME="XXHIL_OM_DOM_MKTG_ROLE" APPLICATION_SHORT_NAME="ONT"

###################################################################################WEBADI LDT File download/upload scripts

--################################################################################--

Below are the different components of WebADI the can be migrated from one instance to another

•     Integrators
•     Contents
•     Layouts
•     Mappings
•     Parameter List
•     Components

Integrator:-

  Download:-

FNDLOAD apps/alam 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XXFAHINTEGRATOR_LDT_FILE.ldt BNE_INTEGRATORS INTEGRATOR_ASN=”XXFAHCUST” INTEGRATOR_CODE=”XXFAHINTEGRATOR_CODE”

  Upload :-

FNDLOAD apps/alam 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XXFAHINTEGRATOR_LDT_FILE.ldt 

-------Contents----------

Download:-

FNDLOAD apps/alam 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecont.lct XXFAHCONTENT_LDT_FILE.ldt BNE_CONTENTS CONTENT_ASN=”XXFAHCUST” CONTENT_CODE=”XXFAHCONTENT_CODE” 

Upload:-

FNDLOAD apps/alam 0 Y UPLOAD $BNE_TOP/patch/115/import/bnecont.lct XXFAHCONTENT_LDT_FILE.ldt 

-------Layout-------

Download Layout:

 FNDLOAD apps/alam 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnelay.lct XXFAHLAYOUT_LDT_FILE.ldt BNE_LAYOUTS LAYOUT_ASN=”XXFAHCUST” LAYOUT_CODE=”XXFAHLAYOUT_CODE” 

Upload :-

FNDLOAD apps/alam 0 Y UPLOAD $BNE_TOP/patch/115/import/bnelay.lct XXFAHLAYOUT_LDT_FILE.ldt 

-------Mappings-------

  Download :-

FNDLOAD apps/alam 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnemap.lct XXFAHMAPPINGS_LDT_FILE.ldt BNE_MAPPINGS MAPPING_ASN=”XXFAHCUST” MAPPING_CODE=”XXFAHMAPPINGS_CODE” 

Upload :-

FNDLOAD apps/alam 0 Y UPLOAD $BNE_TOP/patch/115/import/bnemap.lct XXFAHMAPPINGS_LDT_FILE.ldt 

Parameter Lists

  Download Parameter List

    FNDLOAD apps/alam 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneparamlist.lct XXFAHPARAM_LIST_LDT_FILE.ldt BNE_PARAM_LISTS PARAM_LIST_ASN=”XXFAHCUST” PARAM_LIST_CODE=”XXFAHPARAM_LIST_CODE” 

  Upload Parameter List

    FNDLOAD apps/alam 0 Y UPLOAD $BNE_TOP/patch/115/import/bneparamlist.lct XXFAHPARAM_LIST_LDT_FILE.ldt 

Components

  Download Component

    FNDLOAD apps/alam 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecomp.lct XXFAHCOMPONENT_LDT_FILE.ldt BNE_COMPONENTS COMPONENT_ASN=”XXOM” COMPONENT_CODE=”XXFAHCOMPONENT_CODE” 

  Upload Component

    FNDLOAD apps/alam 0 Y UPLOAD $BNE_TOP/patch/115/import/bnecomp.lct XXFAHCOMPONENT_LDT_FILE.ldt 

--################################################################################--

#FNDLOAD #Oracle Apps #Migration Utility #.lct #.ldt #EBS

Download / Upload LDT File

Download / Upload WFT File