Oracle APPS FNDLOAD batch solution for UPLOAD

Check video of alternative GUI ( finally arrived) for FNDLOAD.

With all the examples I've seen on Oracle FNDLOAD, I never ran across some sort of batch solution. I built one and tested on the few objects and it worked just fine. I wasn't able to test all of the objects UPLOAD.

Below is the source and sequence of the actions.

Step 1. Build your list of the objects needed to be migrated.
Follow the file layout below. Keep in mind that there are always 3 fields. (Put 'X' if there is no application associated with the AOL object):
# OBJECT_TYPE_IDENTIFICATOR,OBJECT_SHORT_NAME,APPLICATION_SHORT_NAME
# Below the example of the objects load list:
#
# CP - concurrent program, PO - profile option, USER - user etc...
# Enclose the object name in double quotes if its name contains spaces or commas..

# Example of the file layout

CP,CONC_PROG_SHORT_NAME,APP_SHORT_NAME
USER,USERNAME,FND
PO,PROFILE_OPTION_NAME,FND

Step 2. Save this file - for example as loadList on the server.

Step 3. Copy shell script from the source below and save it on the server as batchFNDLOAD_U.sh - this one for UPLOAD


#!/bin/ksh

# . batchFNDLOAD_U loadList appsPassword

output_dir='apps_objects_download_dir'
login=apps/$2

action='UPLOAD'

while read line
do

type=`echo $line cut -f1 -d,`

type=`echo $type tr [a-z] [A-Z]`
object=`echo $line cut -f2 -d,`
app=`echo $line cut -f3 -d,`



case $1 in
HELP)
echo ' Use the following format: MyFNDLOAD [helpRSCP] [D,U] output_file application_short entity_short'
echo ' RSET - Request set ';
echo ' CP - Concurrent Program';
echo ' PO - Profile option';
echo ' VS - Value Set definition';
echo ' MN - Menu';
echo ' RG - Request Group';
echo ' LKP - FND Lookups';
echo ' Example - MyFNDLOAD_U MN D save_as_file_name short_application_name apps_object_short_name - to download menu';
echo ' Example - MyFNDLOAD_U PO D save_as_file_name short_application_name profile_short_name - to download menu';
echo ' Example - MyFNDLOAD_U PO U save_as_file_name short_application_name profile_short_name - to download menu';
echo ' Example - MyFNDLOAD_U MN U MYMENU FND MENU_SHORT - to upload menu';
;;
RSET)
# FNDLOAD Upload Request Set Syntax
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afcprset.lct $object.ldt
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afcprset.lct $object_links.ldt
;;
CP)
# FNDLOAD UploadConcurrent Program Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afcpprog.lct $output_dir/$object.ldt
;;
PO)
# FNDLOAD Upload Profile Option Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afscprof.lct $output_dir/$object.ldt
;;
VS)
# FNDLOAD Upload Value Set Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afffload.lct $output_dir/$object.ldt
;;
VSV)
# FNDLOAD Upload Value Set With Values Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afffload.lct $output_dir/$object.ldt
;;

RSP)
# FNDLOAD Upload Responsibility Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afscursp.lct $output_dir/$object.ldt
;;
MN)
# FNDLOAD Upload Menu Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afsload.lct $output_dir/$object.ldt
;;
RG)
# FNDLOAD Upload Request Group Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afcpreqg.lct $output_dir/$object.ldt
;;
LKP)
# FNDLOAD Upload Lookup Type Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/aflvmlu.lct $output_dir/$object.ldt
;;
DFF)
# FNDLOAD Upload Descriptive Flex Field Example
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afffload.lct $output_dir/$object.ldt
;;
MSG)
# FNDLOAD Upload FND Message Example
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afmdmsg.lct $output_dir/$object.ldt
;;
USER)
# FNDLOAD Upload APPS User Example
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afscursp.lct $output_dir/$object.ldt
;;
*) ;;
esac


# keep the line below if you wish to overwrite the owner of the object to ANONYMOUS.
# This is not really what Oracle recommends, but just in case you need to know if #this has been done via batched FNDLOAD. Choose appropriate existing USER name.

cat $output_dir/$object.ldt sed 's/OWNER.*=.*\".*\"/OWNER = \"ANONYMOUS\"/' > xx
mv xx $output_dir/$object.ldt

done < $1 # the end Step 4. Execute the script : batchFNDLOAD_U loadList appsPassword.


All objects will be processed and migrated in a single run.
It is small, but improvement.
Don't forget to verify that all just created .ldt files correctly downloaded the designated objects.
Every file, which ends with # -- End Entity Definitions --
failed downloading the object definition. Most likely due to incorrect object name provided in the loadList file.