Monday, August 26, 2019

What Is The Recommended Location Of Xdodelivery.cfg or XDO.cfg In An R12.2 Environment? (Doc ID 1915791.1)

APPLIES TO:

BI Publisher (formerly XML Publisher) - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.
What is The Recommended Location Of Xdodelivery.cfg In A R12.2 Environment?

GOAL

Traditionally, the xdodelivery.cfg is located under $XDO_TOP/resource, but with 12.2 dual filesystems, this may not be the best idea.

What is the recommendation for R12.2?

(1) Should it be put under fs_ne? ( fs_ne/EBSapps/appl/xdo/resource ) and the relevant profile option pointed there.
(2) Or continue to be under the $XDO_TOP/resource existing in BOTH fs1 and fs2.

SOLUTION

For Oracle R12.2.x:
The .cfg file can be stored in the fs_ne/EBSapps/appl/xdo/resource file system not fs1 or fs2.
The fs_ne filesystem is not swapped during cutover, hence the changes stay intact.

Note:  This issue is fixed from EBS  12.2.5.

REFERENCES


BUG:18673638 - SETTING IBY_XDO_DELIVERY_CFG_FILE DOES NOT TAKE DUAL FILE SYSTEM INTO ACCOUNT
NOTE:461842.1 - R12 Error: The IBY_XDO_DELIVERY_CFG_FILE Profile Option Is Not Set Or Is Invalid



To BottomTo Bottom


In this Document
Goal
Solution
References


APPLIES TO:

BI Publisher (formerly XML Publisher) - Version 12.0 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 27-MAR-2013
Reviewed for relevance 10 Feb 2019.

GOAL

Some Oracle Applications programs need the setup of xdodelivery file to Mail/Print/Fax documents.
e.g.
IBY_FD_SRA_FORMAT module: Send Separate Remittance Advices
need the setup of  IBY_XDO_DELIVERY_CFG_FILE profile option which need to point to the exact location of the xdodelivery file

Without this setup, the report is failing with the following error message:
"IBY_XDO_DELIVERY_CFG_FILE is not set"
 This Note suggests some examples of xdodelivery.cfg file.

SOLUTION

The configuration file $XDO_TOP/resource/xdodelivery.cfg is detailed in the Oracle XML Publisher Administration and Developer's Guide and Oracle® XML Publisher User’s Guide in the section 'Configuration File Support':
Oracle® XML Publisher Administration and Developer's Guide Release 12 Part No. B31412-01

Oracle® XML Publisher User’s Guide Release 11i Part No. B13817-06
Here are some examples you can use :
<?xml version="1.0" encoding="UTF-8" ?> 
<config xmlns="http://xmlns.oracle.com/oxp/delivery/config"> 
<servers> 
<server name="mysmtp1" type="smtp_email" default="true"> 
<host>myhost.mydomain</host> 
<port>25</port> 
</server> 
</servers> 
<properties> 
<property name="ds-temp-dir">/tmp</property> 
<property name="ds-buffering">true</property> 
<property name="SMTP_CONTENT_TYPE:String">"application/pdf"</property> 
</properties> 
</config>

<?xml version="1.0" encoding="UTF-8" ?> 
<config xmlns="http://xmlns.oracle.com/oxp/delivery/config"> 
    <servers> 
    <server name="printer1" type="ipp_printer" default="true"> 
                  <uri>http://bacsfax:631/printers/printer1</uri> 
    </server> 
     <server name="fax1" type="ipp_fax" default="true"> 
                  <uri>ipp://bacsfax:631/printers/printer1</uri> 
    </server> 
    <server name="mysmtp1" type="smtp_email" default="true"> 
    <host>smtp.ph.rc</host> 
    <port>25</port> 
    </server> 
    </servers> 
    <properties> 
    <property name="ds-temp-dir">/tmp</property> 
    <property name="ds-buffering">true</property> 
    <property name="SMTP_CONTENT_TYPE:String">"application/pdf"</property> 
    </properties> 
</config>

<?xml version='1.0' encoding='UTF-8'?> 
<config xmlns="http://xmlns.oracle.com/oxp/delivery/config"> 
<!-- ************************************************** --> 
<!-- servers section --> 
<!-- List your pre-defined servers here. --> 
<!-- ************************************************** -->
<servers> 
<server name="myprinter1" type="ipp_printer" default="true"> 
<uri>ipp://myprinter1.oracle.com:631/printers/myprinter1</uri> 
</server> 
<server name="myprinter2" type="ipp_printer" > 
<host>myprinter2.oracle.com</host> 
<port>631</port> 
<uri>ipp://myprinter2.oracle.com:631/printers/myprinter2</uri> 
<authType>basic</authType> 
<username>xdo</username> 
<password>xdo</password> 
</server> 
<server name="myfax1" type="ipp_fax" default="true" > 
<host>myfax1.oracle.com</host> 
<port>631</port> 
<uri>ipp://myfax1.oracle.com:631/printers/myfax1</uri> 
</server> 
<server name="mysmtp1" type="smtp_email" default="true"> 
<host>myprinter1.oracle.com</host> 
<port>25</port> 
</server> 
<server name="mysmtp2" type="smtp_email" > 
<host>mysmtp12.oracle.com</host> 
<port>25</port> 
<username>xdo</username> 
<password>xdo</password> 
</server> 
</servers> 
<!-- ************************************************** -->
<!-- properties section --> 
<!-- List the system properties here. --> 
<!-- ************************************************** -->
<properties> 
<property name="ds-temp-dir">/tmp</property> 
<property name="ds-buffering">true</property> 
</properties> 
<!-- ************************************************** -->
<!-- channels section --> 
<!-- List the custom delivery channels here. --> 
<!-- ************************************************** -->
<channels>
<channel name="file">oracle.apps.xdo.delivery.file.FileDeliveryRequestFactory</channel>
</channels>
</config>
Notes :

- Replace myhost and mydomain by your host name and domain name (myhost and mydomain are the mail host and server)

"http://xmlns.oracle.com/oxp/delivery/config"  is for information only.

- Once the xdodelivery.cfg file has been created, please set the profile option IBY_XDO_DELIVERY_CFG_FILE (IBY: XML Publisher Delivery Manager Configuration File) to point to the location of configuration file, e.g. /.../apps/apps_st/appl/xdo/12.0.0/resource/xdodelivery.cfg

- Additional help can be provided by the following note: Note 401619.1 "How Do I Troubleshoot XML with Collections"
- Some times saving the configuration file /xdodelivery.cfg under: $XDO_TOP/resource did not work.  Try to save it under: jre/lib directory and check again.
Make sure to put xdodebug.cfg file under "lib" directory of JRE used to run the delivery process (for example:
/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib -> if JDK is used.
Join our Oracle BI Publisher Community to discuss further with other Oracle BI Publisher Experts and learn more from your peers.

For more information on BI Publisher Product documentation, Announcements, Hot Topics, Community, Blog and Training details. Take a look at the Oracle BI Publisher (BIP) Product Information Center (PIC) (Doc ID 1338762.1).

REFERENCES

NOTE:364547.1 - BI Publisher - Troubleshooting Oracle Business Intelligence (XML) Publisher For The Oracle E-Business Suite
NOTE:1434655.1 - How To Troubleshoot Bursting in EBS for XML Publisher
NOTE:401619.1 - How Do I Troubleshoot XML with Collections?
NOTE:412232.1 - Troubleshooting Oracle BI Publisher Enterprise 10g
NOTE:1410160.1 - R12: Troubleshooting Known XML Publisher and E-Business Suite (EBS) Integration Issues
NOTE:1338762.1 - Information Center: Oracle BI Publisher (BIP)
NOTE:1387643.1 - Troubleshooting Oracle BI Publisher Enterprise 11g



No comments:

Post a Comment

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

  Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...