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

Last updated on AUGUST 03, 2023

Applies to:

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

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