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
Files with following extension(s) is considered, or files with extension .
Tip |
---|
See Considerations below for configuration Publisher files as they require manual entry and evaluate for some attributes. |
Object Type Identification
- Files with extensions .pdf, .rtf, .xsd, .xlf are included regardless of location, Or
- Files with extensions .xml, .xls, .xsl, .pdf, .rtf, .xsd that are in the publisher folder
...
- 1
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.
File Extensions
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 NameXXHR | 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 /defs/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 |
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 |
...
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 Anchor Considerations Considerations
Considerations | |
Considerations |
- When populating XML files from an SCM, the SCM, LOB Type is defaulted based file extension and file data. When sourcing files files from EBS, LOB Type is defaulted to XML_SAMPLE. Be sure to update the LOB Type to the appropriate type and regenerate the commands for bursting files, data templates, etc.based on file extension. In either case be sure to make sure that LOB Type is appropriate. For example,
- .pdf, .rtf, .xls, .xsl, .xlf files are TEMPLATE
- .xsd and .dtd files are XML_SCHEMA
- You must make sure that values for App Short Name, LOB Code, Territory and Language are correct when sourcing from SCM or EBS. Once you edit the values, make sure to click Evaluate to reevaluate commands and Save your changes after evaluate.
If necessary, you can find values for App Short Name, LOB Code, Territory and Language using following query.
Code Block language sql theme RDark SELECT LOB_CODE, LOB_TYPE, APPLICATION_SHORT_NAME, FILE_NAME, LANGUAGE, TERRITORY, XDO_FILE_TYPE FROM XDO_LOBS
- Ensure the LOB Code of the XML files and Name of the Data Definition (XDO_DS_DEFINITION - AOL) match the LOB Code of the report template, as this is what ties them together. Failure Failure to do so will result in the attachments not appearing under the data definition in EBS.