E1: UBE : How to Export Data From Standard Table to Text File and Encrypt the File (Doc ID 2252879.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Goal

A custom UBE fetches the data from JDE standard table
The output of UBE is in the form of .txt or .csv file. These are Financial / Bank data. This file should be encrypted.
This .txt / .csv file is picked for processing by SSIS(SQL Server Integration Service).
The SSIS output is used by another software, which picks this data and will decrypt for further processing.

The file that contains data from standard JDE tables should be encrypted.
This file should also be digitally signed.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms