My Oracle Support Banner

E1: ORCH: Fetch Data from JDE Table to Update Another Record, How to Ignore Blank Input ? (Doc ID 2683169.1)

Last updated on JULY 21, 2020

Applies to:

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

Goal


Customer has a requirement to read data from a staging jde table using a data request and update employee data in E1 using form request. There are around 70 columns in this staging table being populated by another process, and any of them could be blank for a given record and it indicates that the corresponding field in jde table should not be updated.

But form request is updating an existing field value to blank.
How to avoid updating the data in E1 when the staging table column being fetched in the data request is blank?

 

Form request to Update:

 

Running the orchestration that fetch data from F0116 using Data Request and update using Form Request:


 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.