FNDLOAD commands

1. XML Publisher Data Definition and Templates
a) To download all Templates defined for a particular Data Definition


FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ldt_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[APPSHORTNAME] DATA_SOURCE_CODE=[DATADEFINITIONCODE]


b) To download for a particular Template and Data Definition


FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct ldt_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[APPSHORTNAME] DATA_SOURCE_CODE=[DATADEFSHORTCODE] TMPL_APP_SHORT_NAME=[APPSHORTNAME] TEMPLATE_CODE=[TEMPLATECODE]


c) Upload RTF to XML Template

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD [APPSPWD] -JDBC_CONNECTION [DBHOST:DBPORT:SID] -LOB_TYPE TEMPLATE -APPS_SHORT_NAME [APPSHORTNAME] -LOB_CODE [TEMPLATESHORTNAME] -LANGUAGE en -TERRITORY [TERRITORYCODE] -XDO_FILE_TYPE RTF -FILE_CONTENT_TYPE 'application/rtf' -FILE_NAME [FILEPATH_ON_SERVER] -CUSTOM_MODE FORCE -LOG_FILE [LOGFILEPATH_ON_SERVER]


2. Concurrent Programs


FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct ldt_name.ldt PROGRAM APPLICATION_SHORT_NAME="APPSHORTNAME" CONCURRENT_PROGRAM_NAME="PROGSHORTNAME"


3. Request Set


a) To download Request Set Definition


FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct ldt_name.ldt REQ_SET APPLICATION_SHORT_NAME="APPSHORTNAME" REQUEST_SET_NAME="REQSETSHORTNAME"


b) To download Request Set Link Stage Definition


FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct ldt_name.ldt REQ_SET_LINKS APPLICATION_SHORT_NAME="APPSHORTNAME" REQUEST_SET_NAME="REQSETSHORTNAME"

4. Flexfields

a) To download Flexfields

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct ldt_name.ldt DESC_FLEX APPLICATION_SHORT_NAME= ‘APPSHORTNAME’ DESCRIPTIVE_FLEXFIELD_NAME=’FLEXFIELD_CODE’

b) To upload Flexfields

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct ldt_name.ldt  

Basic Sql Statements

Use ALTER statement  to modify table structure
 ALTER TABLE table_name
   ADD(
         column1_name column1_datatype column1_constraint,
         column2_name column2_datatype column2_constraint   );

Example 
ALTER TABLE XXTABLE_NAME
   ADD(
          creation_date DATE,
          last_update_date DATE   );


ALTER TABLE XXTABLE_NAME 
 MODIFY 
            last_name VARCHAR2(350);                    --this will make the length of existing last_name column to 350

Query to find Request Group, Responsibility name,and so on...

Use this query if you know the concurrent program name

SELECT DISTINCT
            FCPL.USER_CONCURRENT_PROGRAM_NAME,
            FCP.CONCURRENT_PROGRAM_NAME,
            FAPP.APPLICATION_NAME,
            FRG.REQUEST_GROUP_NAME, 
            FNRTL.RESPONSIBILITY_NAME
  FROM APPS.FND_REQUEST_GROUPS FRG,
           APPS.FND_APPLICATION_TL FAPP,
           APPS.FND_REQUEST_GROUP_UNITS FRGU,
           APPS.FND_CONCURRENT_PROGRAMS FCP,
           APPS.FND_CONCURRENT_PROGRAMS_TL FCPL,
           APPS.FND_RESPONSIBILITY FNR,
           APPS.FND_RESPONSIBILITY_TL FNRTL
WHERE FRG.APPLICATION_ID =FAPP.APPLICATION_ID
    AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
    AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
    AND FRG.REQUEST_GROUP_ID = FNR.REQUEST_GROUP_ID
    AND FRG.APPLICATION_ID = FNR.APPLICATION_ID
    AND FNR.RESPONSIBILITY_ID = FNRTL.RESPONSIBILITY_ID
    AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
    AND FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
    AND FCP.CONCURRENT_PROGRAM_ID = FCPL.CONCURRENT_PROGRAM_ID
    AND FCPL.USER_CONCURRENT_PROGRAM_NAME LIKE 'Name of concurrent program'
    AND FNRTL.LANGUAGE = 'US'AND FAPP.LANGUAGE = 'US'

Basic UNIX commands

#Command to find Operating System in UNIX
$ uname -a
#Additional options supported by uname command can be found as follows
$ man uname


#Command to find a file(say XYZ.txt) under current directory
$ find . -name "XYZ*"     --this will list path of all files starting with XYZ under current directory
$ find . -name "XYZ.txt"  --this will list path of file XYZ.txt under current directory


#Command to list contents of directory 
$ ls                      --this will list file and directory names under current directory
$ ls -ltr                 --this will list details of files and directories under current directory
$ ls -ltr *ABC*   --this will list contents of directory with filename like ABC


#Command to search for string in a directory or particular file
$ grep 'test' filename.txt            --searches for string 'test' in filename.txt
$ cat filename.txt | grep -i 'test' --searches for string 'test' in filename.txt
$ grep -i 'test' filename.txt         --ignores case of string 'test' (TEST, test, Test, etc) while searching
$ grep -r 'test' ./migration         --searches for string 'test' recursively in migration directory
$ grep -l 'test' *.ldt                    --list all .ldt files, where 'test' appears