BI Publisher Delivery Manager: How to Implement Support For FTP/SFTP Download

APPLIES TO:

BI Publisher (formerly XML Publisher) – Version 12.0 to 12.1 [Release 12.0 to 12.1]

GOAL

The goal of this document is to indicate the patch that needs to be applied to support FTP/SFTP download using existing delivery manager code for FTP/SFTP upload.

Scenarios: One connecting to other ftp and sftp servers and pull XML data.

SOLUTION

To implement the solution, please execute the following steps:

1. Download and Review the Patch Readme for patch 10284966:R12.XDO.B – Abstract :ER: SUPPORT OF FTP/SFTP FILE DOWNLOAD.
Pre-requisites: Oracle Applications Technology 12.1.3

2. For EBS patches use ADADMIN to enable maintenance mode and then shut down your EBS application or middle tier services.

3. Ensure that you have taken a backup of your system before applying the recommended patch on test environment.

4. Unzip the patch and go to the unzipped directory.

5. Using ADADMIN,Apply Patch 10284966:R12.XDO.B , You need to apply unified driver u10284966.drv on the middle tier.

6. Once applied, use ADADMIN to disable maintenance mode.

Confirm the following file versions are delivered :

Class files are located at $JAVA_TOP/oracle/apps/xdo/delivery directory

xdo java/delivery/ftp FTPClient.java 120.2.12010000.2
xdo java/delivery/ftp FTPDataConnection.java 120.1.12010000.2
xdo java/delivery/ftp FTPDeliveryRequestHandler.java 120.4.12010000.2
xdo java/delivery/ftp FTPMainConnection.java 120.2.12010000.2
xdo java/delivery/ssh2/sftp SFTPUtil.java 120.0.12010000.2

You can use the commands like the following:
strings -a $XX_TOP/filename |grep ‘$Header’

7. Restart the EBS Application Services to retest the issue.

8. Migrate the solution as appropriate to other environments.

REFERENCES

Support Doc ID : 1609258.1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s