Custom Functions:
~~~~~~~~~~~~~~~~~
FNDLOAD apps/$PASSWORD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct FUNC_X_ARXRWMAI_HEADER.ldt FUNCTION FUNCTION_NAME="X_ARXRWMAI_HEADER"
FNDLOAD apps/$PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct FUNC_X_ARXRWMAI_HEADER.ldt
Personalizations:
~~~~~~~~~~~~~~~~~
FNDLOAD apps/$PASSWORD 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct PER_FUNC_X_ARXRWMAI_HEADER.ldt FND_FORM_CUSTOM_RULES function_name=X_ARXRWMAI_HEADER
FNDLOAD apps/$PASSWORD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct PER_FUNC_X_ARXRWMAI_HEADER.ldt
Concurrent Program
~~~~~~~~~~~~~~~~~~
FNDLOAD apps/$PASSWORD O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct CONC_DISD_AF_RECEIPT.ldt PROGRAM APPLICATION_SHORT_NAME="AR" CONCURRENT_PROGRAM_NAME="DISD_AF_RECEIPT"
FNDLOAD apps/$PASSWORD O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct CONC_DISD_AF_RECEIPT.ldt
Request Group
~~~~~~~~~~~~~
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"
Application Menu:
~~~~~~~~~~~~~~~~~
FNDLOAD apps/$PASSWORD O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct MENU_X_AR_ACTIVITY_FUNDS.ldt MENU MENU_NAME="X_AR_ACTIVITY_FUNDS"
FNDLOAD apps/$PASSWORD O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct MENU_X_AR_ACTIVITY_FUNDS.ldt
DFF's to Export:
~~~~~~~~~~~~~~~~~
Specific Context:
~~~~~~~~~~~~~~~~~~~
FNDLOAD apps/$PASSWORD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct DFF_AR_CASH_RECEIPTS.ldt DESC_FLEX P_LEVEL=COL_ALL:REF_ALL:CTX_ONE:SEG_ALL APPLICATION_SHORT_NAME="AR"
DESCRIPTIVE_FLEXFIELD_NAME="AR_CASH_RECEIPTS" P_CONTEXT_CODE="CONFIRMED"
All Context:
~~~~~~~~~~~~~~
FNDLOAD apps/$PASSWORD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct DFF_AR_RECEIVABLES_TRX.ldt DESC_FLEX P_LEVEL=COL_ALL:REF_ALL:CTX_ALL:SEG_ALL APPLICATION_SHORT_NAME="AR" DESCRIPTIVE_FLEXFIELD_NAME="AR_RECEIVABLES_TRX"
Specific Segment of Global Data Elements:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FNDLOAD apps/$PASSWORD 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct DFF_INVOICE.ldt DESC_FLEX APPLICATION_SHORT_NAME="SQLAP" DESCRIPTIVE_FLEXFIELD_NAME="AP_INVOICES" DESCRIPTIVE_FLEX_CONTEXT_CODE="Global Data Elements" END_USER_COLUMN_NAME="Check Req ID" APPLICATION_COLUMN_NAME=ATTRIBUTE13
FNDLOAD APPS/$PASSWORD O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct DFF_INVOICE.ldt
Data Definition and Template Definition
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FNDLOAD apps/$PASSWORD O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct DSRC_TMPL_DISD_AF_RECEIPT.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='AR' DATA_SOURCE_CODE='DISD_AF_RECEIPT' TMPL_APP_SHORT_NAME='AR' TEMPLATE_CODE='DISD_AF_RECEIPT'
Data Definition Template XML
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=XX_SERVICE_NAME)))' -LOB_TYPE DATA_TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE XML -FILE_NAME $DATA_FILE_PATH/$DATA_FILE_NAME.xml -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME
RTF Template XML
~~~~~~~~~~~~~~~~
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XX_HOST_NAME)(PORT=XX_PORT_NUMBER))(CONNECT_DATA=(SERVICE_NAME=SERVICE_NAME)))' -LOB_TYPE TEMPLATE -LOB_CODE XX_TEMPLATE -XDO_FILE_TYPE RTF -FILE_NAME $RTF_FILE_PATH/$RTF_FILE_NAME.rtf -APPS_SHORT_NAME XXCUST -NLS_LANG en -TERRITORY US -LOG_FILE $LOG_FILE_NAME
OAF Deployment
~~~~~~~~~~~~~~
Copy the zip file to JAVA_TOP and unzip on Server.
unzip deploy.zip –d $JAVA_TOP
Import Page Definition using the following command:
on windows:
~~~~~~~~~~
cd C:\Jdev_R12.1.1\jdevbin\oaext\bin
import C:\Jdev_R12.1.1\jdevhome\jdev\myprojects\XX\oracle\apps\XXar\webui\MainPG.xml -rootdir C:\Jdev_R12.1.1\jdevhome\jdev\myprojects\ -username apps -password $PASSWORD -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scbnetuxdb07.dallasisd.org)(PORT=1528))(CONNECT_DATA=(SID=PE02)))"
on server:
~~~~~~~~~~~
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/XX/oracle/apps/XXar/webui/MainPG.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=scbnetuxdb07.dallasisd.org)(PORT=1528))(CONNECT_DATA=(SID=PE02)))" -rootdir $JAVA_TOP
verify:
~~~~~~
set serveroutput on
BEGIN
jdr_utils.printDocument('/XX/oracle/apps/XXar/webui/MainPG',1000);
END;
