My Oracle Support Banner

E1: 34: Inclusion Rules P34004 QBE Row with Selected Check Box Returns All Demand/Supply Inclusion Rules F34004 Records (P34004/F40203) (Doc ID 2855735.1)

Last updated on MARCH 21, 2022

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 8.11 SP1 and later
Information in this document applies to any platform.

Symptoms

Currently, the P34004 Inclusion Rules program only filters records based on the Order Activity Rules F40203 file based on the QBE fields, when the Selected Check Box in the P34004 header is not selected. This allows any order activity rule record in F40203 to be added to the inclusion rules.

When the Selected Check Box in the P34004 header is selected, the view shifts to the Demand/Supply Inclusion Rules F34004 file, so the QBE line for F40203 file is no longer applicable, for this query.  Meaning that the QBE row F40203 filter fields are not applied to F34004, and the query returns all F34004 records, as filtered only by header values.

Client requests that when the Selected field is checked in P34004 Inclusion Rules, the system will display records in the F40203 per the QBE filter, but only for records, such as per a table join, with a matching F34004 record.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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