Embed pdf doc in same OAF page

import oracle.apps.fnd.framework.webui.beans.OAHTMLWebBean;

//    OAHTMLWebBean pdfElement =  (OAHTMLWebBean)createWebBean(pageContext, HTML_WEB_BEAN, null, "IFRAME");

    //use IFRAME or EMBED

//    pdfElement.setHTMLAttributeValue("src", "http://www.google.com");

//    pdfElement.setHTMLAttributeValue("src", "/OA_HTML/test.pdf");

//    pdfElement.setHTMLAttributeValue("src", "/EDEVL/comn/java/jeg/oracle/apps/jeg/ARRADoc.pdf");

    //pdfBlob

    // p_output

//    pdfElement.setHTMLAttributeValue("width", "100%");

//    pdfElement.setHTMLAttributeValue("height", "500");

//    webBean.addIndexedChild(pdfElement);

Web ADI Menu Desktop Integration Menu

Common mistake - Users are not able to access web adi from the repsonsibility but user with Syadmin resp is able to get it.

Add Sub menu "Desktop Integration Menu"  with no prompt to that repsonsibiltiy,

Irritating issue in RTF - XML Publisher report

issue
BI Publisher - Options - Build
Form Field size - Change to Backward Compatible

R12 - To check which server your browser is connecting to

http://ebs.server.com/cgi-bin/which.cgi

Disable DFF Attributes in OAF Page

Diable DFF Attributes in OAF Page

Create a raw text item and give below java script.  Add 

SCRIPT type="text/javascript"

     var elementInDocument = function (element) {         while (element = element.parentNode) {             alert('ele ' + element);             alert('doc ' + document);             if (element == document) {                 return true;             }         }         return false;     };     if (elementInDocument("xxswCACPageNewFlag") == false) { if (document.getElementById("salesChannel").value != '') { document.getElementById("salesChannel").disabled = true; }if (document.getElementById("ActFlexField1").value != '') {             document.getElementById("ActFlexField1").disabled = true;             document.getElementById("ActFlexField2").disabled = true;             document.getElementById("ActFlexField3").disabled = true;             var cacGroup = document.getElementById("ActFlexField1__xc_0");             var cacGroupImg = cacGroup.getElementsByTagName("a");             cacGroupImg[0].style.visibility = 'hidden';             cacGroupImg[0].onclick = function () {                 return false;             } ;  var cacCode = document.getElementById("ActFlexField2__xc_0");             var cacCodeImg = cacCode.getElementsByTagName("a");             cacCodeImg[0].style.visibility = 'hidden';             cacCodeImg[0].onclick = function () {                 return false;             }       }        } 

SCRIPT

Menu - Sub Menu - Function (as tree structure) for a given Menu

SELECT LPAD(' ', 6*(LEVEL-1)) || menu_entry.entry_sequence sequence
, LPAD(' ', 6*(LEVEL-1)) || menu.user_menu_name SubMenu_Description
, LPAD(' ', 6*(LEVEL-1)) || func.user_function_name Function_Description
, menu.menu_id
, func.function_id
, menu_entry.grant_flag Grant_Flag
, DECODE( menu_entry.sub_menu_id
, null, 'FUNCTION'
, DECODE( menu_entry.function_id
, null, 'SUBMENU'
, 'BOTH')
) Type
FROM fnd_menu_entries menu_entry,
fnd_menus_vl menu,
fnd_form_functions_vl func
WHERE menu_entry.sub_menu_id = menu.menu_id(+)
AND menu_entry.function_id = func.function_id(+)
AND grant_flag = 'Y'
START WITH menu_entry.menu_id = (SELECT menu_id
FROM fnd_menus_tl menu2
WHERE menu2.user_menu_name = :Parent_Menu_User_Name)
CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
ORDER SIBLINGS BY menu_entry.entry_sequence 

NLS_LANGUAGE

To set in unix / linux

To download concurrent program ldt with translations we have to take 2 ldt files for each language
first take english file

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP_us.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"

To change language use below

export NLS_LANG="BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1"

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP_br.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM".

To change language in Database use
alter session

Ex -
ALTER SESSION SET NLS_LANGUAGE='BRAZILIAN PORTUGUESE';