Distribution - JDE1 (MOSC)

MOSC Banner

Filter out blank currency values in application

edited Dec 21, 2020 10:29PM in Distribution - JDE1 (MOSC) 6 commentsAnswered

I'm using the field AOPN in an application which is based on V43121F. I want to filter out values that are blank/empty/null/zero. The UBE R43450 uses <is not equal to "                             "> in the data selection. I'm trying to achieve the same results by setting the filter on the form control and assigning a value in the Post Dialog is Initialized ER in the application. I've tried != 0, "0", " ", "                             ", "" when assigning a value and nothing works to filter out the blank/empty/null/zero values. They also don't work in the QBE or the browser, however they

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center