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.
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:
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