FNDLOAD Dowload and Upload objects

FNDLOAD is used to migrate objects between instances.


DOWNLOAD



1 – Printer Styles
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

2 – Lookups
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND"
LOOKUP_TYPE="lookup name"

3 – Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=COL_ALL:REF_ALL:CTX_ONE:SEG_ALL APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"

4 – Key Flexfield Structures
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

5 – Concurrent Programs
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name"

6 – Value Sets
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

7 – Value Sets with values
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

8 – Profile Options
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

8 – Request Groups
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

10 – Request Sets
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"

11 – Responsibilities
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"

12 – Menus
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"

13 – Forms Personalization
FNDLOAD apps/$APPS_PWD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES function_name=FUNCTION_NAME

14 - XML Data Definition and Associated Template Definition ***Doesn't download attachments.
FNDLOAD apps/$APPS_PWD O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct file_name.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='FND' DATA_SOURCE_CODE='DATA SOURCE CODE' TMPL_APP_SHORT_NAME='FND' TEMPLATE_CODE='TEMPLATE_CODE'

15 - Workflow Download

WFLOAD apps/$APPS_PWD 0 Y DOWNLOAD file_name.ldt WF_INTERNAL_NAME



UPLOAD

UPLOAD command is same for all except replacing the .lct and passing any extra parameters if you want to
pass

FNDLOAD apps/$APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/corresponding.lct upload_file.ldt

Use the condition below to override the existing.

FNDLOAD apps/$APPS_PWD 0 Y UPLOAD $FND_TOP/patch/115/import/corresponding.lct upload_file.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Oracle compare dates with timestamp

Dates with timestamp can be compared by using

to_date(DATE_FIELD_VAL, 'DD/MM/YY HH24:MI:SS')

Date from : '07/11/13 01:01:01'
Date To :  '07/11/13 23:59:59'

Note that it's 24Hr format.


to_date(DATE_FIELD_VAL, 'DD/MM/YY HH24:MI:SS') between to_date('07/11/13 01:01:01','DD/MM/YY HH24:MI:SS') and to_date('07/11/13 23:59:59','DD/MM/YY HH24:MI:SS')

Leading zero's XML Publisher

When chosen Excel as XML publisher output, text with prefix zeros will be converted to number in excel output. To maintain the format

Option1
Change xml tag  in template from
<?your_field?> to ="<?your_field?>"


Option2
Add NONBREAKING SPACE before the column.

Place cursor in front of the column you need press CTRL + SHIFT + SPACE. You can also choose this from menu.

Insert -  Symbol - Special Characters.

java.lang.NullPointerException - XML Bursting Error

Perform the following check to resolve the error java.lang.NullPointerException in XML Bursting.

1. Check if your bursting XML definition and concurrent program belongs to same application.
2. Bursting XML definition name (CODE) should match the concurrent program short name for which it's deing called. No exception.
3. Follow other checks from here.

Dynamic Images in XML Publisher

Image path used in XML publisher can be constructed dynamically from values rather than hard coding. Below image provides the example.

CF_IMAGE_NAME in the report generates image name value for each row of data. And the images with those names reside in the path "$OA_MEDIA/custom/". Let's say a value of CF_IMAGE_NAME is image1.jpg during run time the follow value will be rendered to "$OA_MEDIA/custom/image1.jpg" and the corresponding image will be displayed on the output.

Format picture is a property of a dummy image used in the report to print the images in specific dimension. Due to white background its not visible. You can check more from other post.

There are times when a custom application server path has to be used instead of $OA_MEDIA.
In order to use a custom application path, derive the full path to image in the XML element along with
image name or different element for image name and use it in the XML template.

And use the elements in the image properties ALT TEXT. Below word properties are from Office 2013.
Note that data structure has  elements in root hence the construction of the concat is

url:{concat(IMAGE_PATH,'/',IMAGE_NAME)}






To bring up and use the XML elements at a different level use ../ or // in the concat

url:{concat(../IMAGE_PATH,'/',../IMAGE_NAME)}

Images in XML Publisher

1. Insert a dummy image in your template.
     In Microsoft Word's Format Picture dialog box select the Web tab. Enter the
     following syntax in the Alternative text region to reference the OA_MEDIA directory:
   url:{'${OA_MEDIA}/image name'}
   For example, enter:
   url:{'${OA_MEDIA}/ORACLE_LOGO.gif'} 



Picture properties from Word 2003.

2. Ensure that the image file is in OA_MEDIA
3. Then, from the XML Publisher Administrator resp, upload the edited template into the Template record.
   
   Also see Dynamic Images in XML Publisher

Some useful Unix commands for shell scripting

IF-ELSE

if [ "$value" -eq "0" ] || [ "$value" -ge "2" ]; then
    echo "condition met"
else
    echo "condition not met"

fi

Comparisons:

-eq	equal to
-ne	not equal to
-lt	less than
-le	less than or equal to
-gt	greater than
-ge	greater than or equal to

Exit Host concurrent program with Error

exit 2;

 Linux Find and Move Archive files older than N days

find $frompath -type f -mtime +$age -exec mv {} $archive \;

Obtain value from string

echo $value | cut -f1 -d"."

Command will return the value starting to until “.” is found.

Test.txt will return Test

Using SUBSTR in Unix

echo $name | awk '{ print substr( $0, 0, length($0)-4 ) }'

Command will return name starting from 0 to (lengthofstring)-4

Test.txt will return Test