FNDLOAD to Download and Upload XML Data Definition and Template

Download Script for Data Definition and Template
-------------------------------------------------------------
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct SUBS_QUOTE_RPT_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME='XXSSS' DATA_SOURCE_CODE='SUBS_QUOTE_RPT'

Upload Script for Data Definition and Template
-----------------------------------------------------------
FNDLOAD apps/<pwd> 0 Y UPLOAD ${XDO_TOP}/patch/115/import/xdotmpl.lct SUBS_QUOTE_RPT_DD.ldt

DATA_TEMPLATE (Data Source .xml file)
--------------------------------------------------------------

Download
--------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -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 -APPS_SHORT_NAME XXCUST -LANGUAGE en -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME


Upload
-------------
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 (Report Layout .rtf file)
----------------------------------------------------------

Download
-------------
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -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 TEMPLATE -LOB_CODE XX_TEMPLATE -APPS_SHORT_NAME XXCUST -LANGUAGE en -TERRITORY US -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME


Upload
-------------
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

How to use Division formula in rtf template XML Publisher Report

By using <?xdofx: CS_AMOUNT div CS_QUANTITY?>  in form field help text.

How to display Sequence number in xml publisher?

By using the <?position()?> in form field help text.

It will display the number from 1.

REP-0118 unable to create temp file while opening Report Builder

Causes: temp file directory is missing or path is incorrect in the reports_tmp registry.

regedit (start à run  à regedit)

go to hkey_local_machine  à software à WOW6432Node à oracle à KEY_DevSuiteHome1  à reports_tmp

change the directory path

Do we need to create multiple layout templates for printing report in multiple languages?

We can achieve multi language report by two ways:

     Different layout template for different languages This approach can be chosen if the layout is also different from language to language.

  Generate XLIFF template for each language XLIFF (XML Localization Interchange File Format): format for exchanging localization data. XML based format that enables translators to concentrate on the text to be translated. We use this option when we want to use the same layout and apply specific translation.

what is the file supporting the translation for a layout template?

XLIFF is the file that supports the translation, we have one XLIFF file for each language

Use of P_CONC_REQUEST_ID in report?

The concurrent Program manager passes concurrent request id in your report in P_CONC_REQUEST_ID.

When the concurrent manager runs an Oracle Reports concurrent request, it passes the concurrent request id in the P_CONC_REQUEST_ID parameter. When you call the FND SRWINIT user exit in the report's Before Report trigger, the user exit uses the passed request id to query the Oracle Applications context that the concurrent request was submitted in (via the FND_CONCURRENT_REQUESTS table) and then log on with that context. This allows you to use operating specific views, access profile option values, etc within your report. You should also call the FND SRWEXIT user exit in the After Report trigger.

If you try calling the FND SRWINIT user exit in your report without the P_CONC_REQUEST_ID parameter defined as a user parameter on your report, the user exit will fail.