BI publisher reporting product from Oracle that provides the ability to create and manage highly formatted reports from a wide range of data sources.
See Considerations below for configuration Publisher files as they require manual entry and evaluate for some attributes. |
1 - EBS Publisher Root Source Directory on Project Properties tab defaults to publisher, but you can update if you are keeping Publisher Files in different folder.
Name | Description |
---|---|
.rtf | XML Publisher (XDO) translatable templates and non-translatable RTF templates. |
XML Publisher (XDO) PDF templates. | |
.xsd | XML Publisher (XDO) non-translatable XML Schema. |
Name | Description | Default Value | Supported Values |
---|---|---|---|
Source | Object Source Location Type | SCM (**populating from SCM) EBS (**manual creation) | SCM | EBS |
App Short Name | Application Short Name | Defaults to EBS Module Application Short Name property. | |
LOB Code | XDO LOB code. Enter either the Template Code or the Data Definition Code. | <file name> (**without path/extension) | |
XDO File Type | XDO File type | ||
LOB Type | XDO LOB type | XML_SAMPLE See Considerations | BURSTING_FILE | DATA_TEMPLATE | TEMPLATE | TEMPLATE_SOURCE | XML_SCHEMA | XML_SAMPLE |
Target Location | Path to where the file should be deployed to. | $<PROD_TOP>/patch/115/publisher Default can be changed using EBS Publisher Root Destination Directory property. | |
Territory Code | ISO two-letter territory code. If no territory code, provide 00 to ignore the value. | US | |
Language | ISO two-letter language code. | en | |
Custom Mode | To override Oracle’s upload algorithm and update the custom AOL data regardless - use CUSTOM_MODE= FORCE. | FORCE Default can be changed using EBS Publisher Default Custom Mode property. | NOFORCE | FORCE |
NLS Lang | NLS_LANG environment variable | $NLS_LANG |
Name | Description | Default Value |
---|---|---|
EBS Publisher Root Source Directory | Source folder for publisher files (e.g. xmlpub). | publisher |
EBS Publisher Root Destination Directory | Target directory for Publisher files (e.g. $XXHR_TOP/publisher). | $<PROD_TOP>/patch/115/publisher |
When populating or evaluating files deployed with XDOLoader, set the CUSTOM_MODE of publisher files to this. | FORCE |
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME $FDEBS_DB_USER -DB_PASSWORD $FDEBS_DB_PASSWORD -JDBC_CONNECTION "$AD_APPS_JDBC_URL" -LOB_TYPE XML_SAMPLE -APPS_SHORT_NAME XXHR -LOB_CODE XXHR_BIP_ROSTER -LANGUAGE en -TERRITORY US -NLS_LANG $NLS_LANG -XDO_FILE_TYPE XML mv XML_SAMPLE_XXHR_XXHR_BIP_ROSTER_en_US.xml ./publisher/XXHR_BIP_ROSTER.xml |
cp $SOURCE_FILE $XXHR_TOP/patch/115/publisher/defs/; java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME $FDEBS_DB_USER -DB_PASSWORD $FDEBS_DB_PASSWORD -JDBC_CONNECTION "$AD_APPS_JDBC_URL" -LOB_TYPE XML_SAMPLE -APPS_SHORT_NAME XXHR -LOB_CODE XXHR_BIP_ROSTER -LANGUAGE en -TERRITORY US -NLS_LANG $NLS_LANG -XDO_FILE_TYPE XML -FILE_NAME "$XXHR_TOP/patch/115/publisher/defs/XXHR_BIP_ROSTER.xml" -CUSTOM_MODE NOFORCE |
If necessary, you can find values for App Short Name, LOB Code, Territory and Language using following query.
SELECT LOB_CODE, LOB_TYPE, APPLICATION_SHORT_NAME, FILE_NAME, LANGUAGE, TERRITORY, XDO_FILE_TYPE FROM XDO_LOBS |