Personalization transfer

This subject can be divided to two subtitles: OAF personalizations, Forms personalizations.

To transfer OAF personalizations "Functional Administrator" responsibility is used.
"FND: Personalization Document Root Path" profile should be set.
personalizations>import/export then search and export the personalization.
Login to linux and go to the profile directory, use "tar –cvf xxPersonalizations.tar ./*"
Transfer files via FTP to destination.
Login to linux and go to the profile directory, use "tar –xvf xxPersonalizations.tar *****"
personalizations>import/export then search and import the personalization.


To transfer Forms personalizations FND Load is used.
To download rules for a particular function: FNDLOAD /
0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
FND_FORM_CUSTOM_RULES function_name=
To download rules for a particular form: FNDLOAD / 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct FND_FORM_CUSTOM_RULES form_name="form_name" To download all personalizations (all forms and functions): FNDLOAD / 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct FND_FORM_CUSTOM_RULES Upload: FNDLOAD / 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct

Note: These are not tested by me.

Sum over partition, invalid number

Discoverer reports rearrange the views you create and add new rows to the original "select" for calculations, sums vs. I needed to have a sum calculation in the original sql have the wanted results. So for the first time i used "sum over partition" , example code to sum "column1" for every "column2" change is : select sum (column1) over (partition by column2) from table. If wanted running (cumulative) sum also can be calculated.

SQL have a classic "invalid number" error yet more sometimes Discoverer gives this error though sql does not. Especially while using flexfields number problems occur, usually depending on language (like "." and "," discrepancy). The statement to solve this problem is: fnd_number.canonical_to_number (column1)

Creating a new profile

Sometimes custom solutions are needed for customer requests and profiles are important part of these solutions. Sometimes in personalizations, sometimes in database variable values are needed for different users, responsibilities, organizations vs. And profile is a cure for that, the path to create a new profile is: application developer> profile