E1: RDA: How to Create a Handle and Use it in a Table I/O to an Alternate Data Source (Doc ID 639024.1)

Last updated on MAY 30, 2017

Applies to:

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

Goal

I am purging tables and want to write the results to a custom archive table that resides in a different data source. This is not working properly, the insert statement is failing. How can I access a table in an alternate data source when using Table I/O Event Rules from within Report Design Aid?

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