Commands to UPLOAD LDT Files

1. To upload Ldt file for a Concurent Program
FNDLOAD [username]/[password]' O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct my_ldt_filename.ldt

2. To upload Ldt file for a Data Definition
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/xdotmpl.lct my_ldt_filename.ldt

3. To upload Ldt file for a Request Set
FNDLOAD [username]/[password] 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct my_ldt_filename.ldt

4. To upload Ldt file for a Request Set Links
FNDLOAD [username]/[password] 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct my_ldt_filename.ldt

5. To upload Ldt file for a Lookup Up
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct my_ldt_filename.ldt

6. 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 my_ldt_filename.ldt

7. 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 my_ldt_filename.ldt

8. To upload Ldt file for a Value Set
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct my_ldt_filename.ldt

9. To upload Ldt file for a Value Set with values
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct my_ldt_filename.ldt

10. To upload Ldt file for a DFF
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct my_ldt_filename.ldt

11. 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 my_ldt_filename.ldt

12. To upload Ldt file for a profile Option
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct my_ldt_filename.ldt

13. To upload Ldt file for a Audit Group
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/affaudit.lct my_ldt_filename.ldt

14. To upload Ldt file for a Audit Schema
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/affaudit.lct my_ldt_filename.ldt

15. To upload Ldt file for a Responsibility
FNDLOAD [username]/[password] O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct my_ldt_filename.ldt

Creating LDT files for Concurrent Program

STEPS:
open WINSCP software,enter all the credentials of any instance,and press ok.,now folder view will be opend.
there will be putty software in winscp,press on it,it will show command promt screen,in that
enter username press enter,
enter password press enter,
enter sudo code of instance press enter,
enter  syntax of creating LDT file press enter
now it will create ldt file,to see which path it saved,in prompt enter pwd,now it will show path

creating LDT file for  CONCURRENT PROGRAM :

syntax :

 FNDLOAD apps/xx123 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct 

 <name of our ldt file.ldt> PROGRAM APPLICATION_SHORT_NAME='<shortname of application>' CONCURRENT_PROGRAM_NAME='<short name of concurrent program name>'

ex:
FNDLOAD apps/xx123 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct
<xx_apsuppliers.ldt> PROGRAM APPLICATION_SHORT_NAME='AP' CONCURRENT_PROGRAM_NAME='XX_AP_SUPPLIER_CONV_PROG'

creating LDT file for REQUEST GROUP to perticular CONCURRENT PROGRAM :

 

syntax:
FNDLOAD apps/xxx123 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <our required req group ldt name>.ldt REQUEST_GROUP REQUEST_GROUP_NAME='<request group name>' APPLICATION_SHORT_NAME='<request group application short name>' REQUEST_GROUP_UNIT UNIT_APP='<concurrent program application short name>' UNIT_TYPE='P' UNIT_NAME='<concurrent program short name>'

Ex:
FNDLOAD apps/xxx123 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_supplier_ConcProg_REQ.ldt REQUEST_GROUP REQUEST_GROUP_NAME='All Reports' APPLICATION_SHORT_NAME='SQLAP' REQUEST_GROUP_UNIT UNIT_APP='XXXXX' UNIT_TYPE='P' UNIT_NAME='XX_AP_supplier_conv_program'

Creating PATCH &Applying PATCH in instacne

CREATING PATCH:

1)create new folder with name xx_folder
 in that folder it should contain some folders named as
 admin,bin,code,sql,ctl,install
 and also contains some files named as readme,remarks,drv file,sh file,sh install filw

 folders:
 admin folder contains another subfolder inside named as import,in this folder all ldt files placed
 code is empty
 bin is empty
 sql is empty
 ctl is empty
 install folder contains all scripts i.e table scripts,packega spec and body
 files:
 readme file contains patch components,and process apply process
 remarks file contains all tables names,package name and body name,concurrent program name,responsibility name,parameters passed in c.p
          and any depencies of this conversion
drv file contains the all the syntaxs of code and also ldt file that need to be patched or installed and also  under which top need to be moved
sh file contains drv file name inside


by following above all steps,we can  create patch,


How to APPLY PATCH:

our patch folder need to be placed in desktop or any local disk

now connect to winscp with hostname,username ,password and press login.
now it open unix box.
leftside select the place where our patch folder is there,and move tht to rightside to which it need to be moved and patched.

now connect to putty software,with hostname and press open
command prompt screen wil be opened,by asking username,so enter username ,and press enter
agian it ask password,enter password.

now enter the sudo code and press enter
agian press all systaxes one by one i.e
$ cd /tmp   press enter
$ cd abcdef_patches     press enter      note:  abcdef_patches  is folder creted where our patches moving
$ ls
$ cd ram      note:ram folder i created in unix path,where all my patches need to be placed
$ ls
$ cp -r xx_folder $<topname>/install/conversion_patch
$ cd $<topname>/install/conversion_patch
$ ls
$ cd xx_folder
$ ls
$ dos2unix *.*
$ chmod 777 *.*
$ sh ap_sup.sh
$ n
$ y
$ erp_lance    note:this is password
$ apps
conclusion:after all steps,it will start applying patch.