FNDLOAD Upload Oracle Applications (APPS) Objects

Check the video tour for Migration LogiK(TM) FNDLOAD GUI - alternative tool

FNDLOAD Upload Mode rules

If a row exists, but has different attributes, the row is updated. If a row
does not exist, a new row is inserted.
Depending on the configuration file, a row that exists in the database
but not in the text file may or may not be deleted when the text file is uploaded.
Refer to the configuration file to determine how such rows are handled.

Preservation of data

FNDLOAD uses the OWNER and LAST_UPDATE_DATE attributes to determine
whether to overwrite pre-existing data. The rules applied are:
1. If the entity being uploaded is not present in the database, a new entity is always inserted.
2. Entities uploaded from a file with OWNER=SEED never overwrite entities with
OWNER=CUSTOM in the database.
3. Entities with OWNER=CUSTOM uploaded from a file always update entities with
OWNER=SEED in the database.
4. If the owner of the entity is the same in the file and database, the entity is updated only if the LAST_UPDATE_DATE in the file is later than the LAST_UPDATE_DATE in the database.





If you have read Oracle FNDLOAD Download section, it is all true about Oracle FNDLOAD Upload as well.

Below is the Oracle FNDLOAD source example, which can be saved into UNIX shell script and executed in the same way as Oracle FNDLOAD Download.

If you saved it as MyFNDLOAD_U, then

. MyFNDLOAD_U CP CONCURRENT_PROG_SHORT_NAME APP_SHORT_NAME.

Of course your .ldt file from the previous download, should be stored in 'apps_objects_download_directory' or you have to make an appropriate change in the code.


Note: There is an error cloned from Metalink by multiple bloggers on Value Set with Values and Value Set migration parameter.
For Value Set it is really VALUE_SET.
For Value Set with Independent Values it is VALUE_SET_VALUE.


#!/bin/ksh



login=apps/password

action='UPLOAD'

output_dir='apps_objects_download_directory'

type=`echo $1 | tr [a-z] [A-Z]`

object=$2
app=$3



case $1 in
help)
echo ' Use the following format: MyFNDLOAD [help|RS|CP] [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 $login 0 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 $login 0 Y $action $FND_TOP/patch/115/import/afcpprog.lct $object.ldt
;;
PO)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afscprof.lct $object.ldt
;;
VS)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afffload.lct $object.ldt
;;
VSV)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afffload.lct $object.ldt
;;
RSP)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afscursp.lct $object.ldt
;;
MN)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afsload.lct $object.ldt
;;
RG)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afcpreqg.lct $object.ldt
;;
LKP)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/aflvmlu.lct $object.ldt
;;
DFF)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afffload.lct $object.ldt
;;
MSG)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afmdmsg.lct $object.ldt
;;
USER)
FNDLOAD $login 0 Y $action $FND_TOP/patch/115/import/afscursp.lct $object.ldt
;;
*) ;;
esac

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