My Oracle Support Banner

E1: ORCH: How to Exclude Blank Values in the Filter of a Data Request (Doc ID 2876893.1)

Last updated on JUNE 14, 2022

Applies to:

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


Customer has a data request on table F41021 where the filter includes the lot number.

Sometimes the input value will have a value for lot number and sometimes it will be blank.

When the lot number is blank the data request does not work.

For example: Lot Number = "123" or Lot Number = ""

How to exclude blank values from the filter in the Data service 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

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