FNDLOAD – One of handy apps utility, especially when we are working in oracle application implementation projects. A good companion for data migration, code migration across various implementations.

FNDLOAD assists us to download data from application entity to an editable text file, we can do the necessary changes and upload to another database.

Say for example, you have a development instance, after the code release you do a clone of Dev instance to Test instance. Now for Load Testing, you want to create 1000 users with same responsibility, Ooops being a AppsDBA request has come to you, easily you can automate the process as follows

1) Create one user with responsibility through forms.

Lets say, I created LOADTEST1 with General Ledger Super User and Payables Manager.

2) Export that user from Apps DB

FNDLOAD apps/simple4u 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct ./User_file.ldt FND_USER USER_NAME=’LOADTEST1′

3) Write a shell script to populate remaining 999 users using the existing User_file.ldt file, here we go….

#!/usr/bin/ksh
i=2
while [ $i -le 999 ]
do
sed -e “s/LOADTEST1/LOADTEST$i/g” User_file.ldt > User_file_load.ldt
FNDLOAD apps/simple4u 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct ./User_file_load.ldt
echo “User LOADTEST$1 Created Successfuly”
i=`expr $i + 1`
done

This is one of the live experience I worked on, here are few other cases where apps dba may be challenged to use FNDLOAD.

  • Forms/Functions
    FNDLOAD apps/apps@simple4u 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct load_file.ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@simple4u 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct load_file.ldt
  • Menus
    FNDLOAD apps/apps@simple4u O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct load_file.ldt MENU MENU_NAME=menu_name
  • Responsibilities
    FNDLOAD apps/apps@simple4u O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct load_file.ldt FND_RESPONSIBILITY RESP_KEY=responsibility
  • Concurrent Programs
    FNDLOAD apps/apps@simple4u O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct load_file.ldt PROGRAM APPLICATION_SHORT_NAME=prod CONCURRENT_PROGRAM_NAME=concurrent name
  • Profile Options
    FNDLOAD apps/apps@simple4u O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct load_file.ldt PROFILE PROFILE_NAME=profile option APPLICATION_SHORT_NAME=prod
  • Printer Styles
    FNDLOAD apps/apps@simple4u O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct load_file.ldt STYLE PRINTER_STYLE_NAME=printer style name
  • Responsibilities
    FNDLOAD apps/apps@simple4u O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct load_file.ldt FND_RESPONSIBILITY RESP_KEY=responsibility

Have some good read from:

  1. Patch History Migration For OAM Using Fndload Fails With ‘Use UPLOAD_PARTIAL to upload a specific entity’ [ID 235353.1]
  2. How to Export a Concurrent Program and Executable Using Fndload ? [ID 602267.1]
PrintFriendly

Viewers of this post also viewed...