BI publisher reporting product from Oracle that provides the ability to create and manage highly formatted reports from a wide range of data sources.
File Extensions
| Name | Description |
|---|---|
| .xml | XML Publisher (XDO) non-translatable XML templates. |
| .xsl | XML Publisher (XDO) non-translatable XSL templates. |
| .rtf | XML Publisher (XDO) translatable templates and non-translatable RTF templates. |
| XML Publisher (XDO) PDF templates. | |
| .xsd | XML Publisher (XDO) non-translatable XML Schema. |
Attributes
| 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 | XXHR | |
| 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 | 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/defs/ | |
| Territory Code | ISO two-letter territory code. | 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. | NOFORCE | NOFORCE | FORCE |
| NLS Lang | NLS_LANG environment variable | $NLS_LANG |
Related Project Properties
| 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 |
Sample Build Commands
| Code Block | ||||
|---|---|---|---|---|
| ||||
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 |
Sample Deploy Commands
| Code Block | ||||
|---|---|---|---|---|
| ||||
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 |
Considerations
None