My Oracle Support Banner

E1: BSSV: How To Select Record That Has Blank Date On Table? (Doc ID 3003378.1)

Last updated on FEBRUARY 09, 2024

Applies to:

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

Goal


Customer created a custom BSSV and would like to know how to query record with blank date.

The below where clause works fine, but once added the date fields "F1721.CNDJ or F1721.SSDJ EQUALS, 0", the bssv crashed during runtime. What's the syntax to select those records (F1721.CNDJ =0 and F1721.SSDJ =0) on BSSV?

 

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


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