Search Results


Tuesday, November 29, 2016

Import certificates using keytool

Keytool


One of the import step to call an https webservice using java is to import the SSL certificates before initiating a call.

This example shows the certificates imports on a default weblogic certificates path. However this could be different on your weblogic server, so make sure the path is checked before installing the certificates.


cd /u01/app/oracle/products/jdk1.8.0_66/bin

Install
./keytool -import -keystore /u01/app/oracle/products/fmw1213/wlserver/server/lib/DemoTrust.jks -alias salesforcecom_test -storepass DemoTrustKeyStorePassPhrase -file ~/SalesforceCert.cer

Verify
keytool -list -keystore /u01/app/oracle/products/fmw1213/wlserver/server/lib/DemoTrust.jks -storepass DemoTrustKeyStorePassPhrase -alias salesforcecom_test

Notepad++ plsql function list


Locate functionList.xml file on the Notepad++ install location.

Add association map

<association langID="17" id="sql_node"/>


And the following parser

<parser id="sql_node" displayName="SQL Node" commentExpr="((/\*.*?\*)/|(--.**$))">
    <function
            mainExpr="^[\s]{0,}(function|procedure|--[1-9])[\s]{1,}[\w_]{1,}">
            <functionName>
                  <nameExpr expr="^[\s]{0,}(function|procedure|--[1-9])[\s]{1,}\K[\w_]{1,}"/>
            </functionName>
    </function>
</parser>

And finally restart the Notepad++

Now enable View -- FunctionList

This should bring you list of all functions and procedures in the current sql or plsql file.

You can click on it to navigate to selected code block.

How to deploy XML publisher report to R12

XML Publisher deployment



To deploy concurrent program and request groups follow this link (FNDLOAD).

Deploy XMLP Entries

Following creates metadata for the XML publisher data definition and the associated template. This entries have to be created before uploading the actual files.

FNDLOAD apps/apps O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct XXC_CUSTOM_S.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXC' DATA_SOURCE_CODE='XXC_CUSTOM' TMPL_APP_SHORT_NAME='XXC' TEMPLATE_CODE='XXC_CUSTOM'



FNDLOAD apps/apps O Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct CUSTOM.ldt


Deploy RTF


java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD -DB_USERNAME $APPS_UN \
-DB_PASSWORD $APPS_PW -JDBC_CONNECTION \
$DB_IP_ADDR:$DB_PORT_NO:$APPS_INS \
-LOB_TYPE TEMPLATE -LOB_CODE XXCUSTOM_CODE \
-APPS_SHORT_NAME $XXC -LANGUAGE 'en' \
-XDO_FILE_TYPE 'RTF' -FILE_CONTENT_TYPE 'application/rtf' \
-lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct \
-LOG_FILE LXXCUSTOM.log \
-FILE_NAME $LOAD_DIR/XXCUSTOM.rtf \
-CUSTOM_MODE FORCE


Deploy XLS



java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME $APPS_UN \
-DB_PASSWORD $APPS_PW \
-JDBC_CONNECTION $DB_IP_ADDR:$DB_PORT_NO:$APPS_INS \
-LOB_TYPE TEMPLATE \
-APPS_SHORT_NAME $XXC \
-LOB_CODE XXCUSTOM_CODE \
-LANGUAGE en \
-TERRITORY 00 \
-NLS_LANG American_America.AL32UTF8 \
-XDO_FILE_TYPE XLS \
-FILE_CONTENT_TYPE application/rtf \
-FILE_NAME XXCUSTOM.xls \
-LOG_FILE L_XXCUSTOME.log     -CUSTOM_MODE FORCE


Deploy Data template



java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME $APPS_UN \
-DB_PASSWORD $APPS_PW \
-JDBC_CONNECTION $DB_IP_ADDR:$DB_PORT_NO:$APPS_INS \
-LOB_TYPE DATA_TEMPLATE \
-APPS_SHORT_NAME $XXC \
-LOB_CODE XXCUSTOMER_CODE \
-LANGUAGE en \
-TERRITORY 00 \
-NLS_LANG American_America.AL32UTF8 \
-XDO_FILE_TYPE XML-DATA-TEMPLATE \
-FILE_CONTENT_TYPE text/xml \
-FILE_NAME XXCUSTOM.xml \
  -LOG_FILE L_XXCUSTOM.log       -CUSTOM_MODE FORCE