With all the examples I've seen on Oracle FNDLOAD, I never ran across some sort of packaged solution. I built one and tested on the few objects and it worked just fine.
As an alternative Check the video tour for Migration LogiK(TM) FNDLOAD GUI
Below is the source and sequence of the actions.
Step 1. Build your list of the objects to needed to be migrated.
Follow the layout. Keep in mind that there are always 3 fields. (Put 'X' if there no application associated with the 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, commas #etc...
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_D.sh - this one for DOWNLOAD
#!/bin/ksh
# . batchFNDLOAD_D loadList appsPassword
output_dir='apps_objects_download_dir'
login=apps/$2
action='DOWNLOAD'
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 $type in
HELP)
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 Lookup TYPEs';
echo ' RSP - responsibility';
echo ' DFF - descriptive flexfield';
;;
RSET)
# FNDLOAD Download Request Set Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afcprset.lct $output_dir/$object.ldt REQ_SET REQUEST_SET_NAME=$object
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afcprset.lct $object_links.ldt REQ_SET_LINKS REQUEST_SET_NAME=$object
;;
CP)
# FNDLOAD Download Concurrent Program Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afcpprog.lct $output_dir/$object.ldt PROGRAM APPLICATION_SHORT_NAME=$app CONCURRENT_PROGRAM_NAME=$object
;;
PO)
# FNDLOAD Download Profile Option Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afscprof.lct $output_dir/$object.ldt PROFILE PROFILE_NAME=$object APPLICATION_SHORT_NAME=$app
;;
VS)
# FNDLOAD Download Value Set Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afffload.lct $output_dir/$object.ldt VALUE_SET FLEX_VALUE_SET_NAME=$object
;;
VSV)
# FNDLOAD Download Value With Values Set Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afffload.lct $output_dir/$object.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=$object
;;
RSP)
# FNDLOAD Download Responsibility Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afscursp.lct $output_dir/$object.ldt FND_RESPONSIBILITY RESP_KEY=$object
;;
MN)
# FNDLOAD Download Menu Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afsload.lct $output_dir/$object.ldt MENU MENU_NAME=$object
;;
RG)
# FNDLOAD Download Request Group Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/afcpreqg.lct $output_dir/$object.ldt REQUEST_GROUP REQUEST_GROUP_NAME=$object APPLICATION_SHORT_NAME=$app
;;
LKP)
# FNDLOAD Download Lookup Type Example
FNDLOAD $login O Y $action $FND_TOP/patch/115/import/aflvmlu.lct $output_dir/$object.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=$app LOOKUP_TYPE=$object
;;
DFF)
# FNDLOAD Download Descriptive Flex Fields Example
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afffload.lct $output_dir/$object.ldt DESC_FLEX APPLICATION_SHORT_NAME=PO DESCRIPTIVE_FLEXFIELD_NAME=$object
;;
MSG)
# FNDLOAD Download FND Message Example
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afmdmsg.lct $output_dir/$object.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=$app MESSAGE_NAME=$object
;;
USER)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afscursp.lct $output_dir/$object.ldt FND_USER USER_NAME=$object
;;
*) ;;
esac
done < $1
# the end
Step 4. Execute the script : batchFNDLOAD_D loadList appsPassword.
All objects will be processed and migrated in a single run.
It is small, but improvement.
Don't forget to verify that created .ldt files correctly downloaded the designated objects.
Each file, which ends with
# -- End Entity Definitions --
didn't download the object definition. Most likely due to incorrect object name provided in the FNDLOAD command.
Wednesday, April 8, 2009
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment