E1: 43X: Record Count on UX One Query (P4311) Different From UX One Chart (P4311X)

(Doc ID 2353164.1)

Last updated on JANUARY 25, 2018

Applies to:

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

Symptoms

Number of Requisitions by Buyer Chart (P4311X Form W4311XE)

The Number of Requisitions by Buyer Chart (P4311X Form W4311XE) returns a different number of requisitions than the Inquiry (P4311 Form W4311D) when the same query criteria is applied.

The issue can be reproduced at will with the following steps:

  1. Run the Open Requsitions Query (P4311 Form W4311D) 89 records are returned.
  2. Check the Query Criteria
    1. Order Type = OR
    2. Line Type IN LIST S, J and
    3. Next Status not equal to 999
  3. Now run the Number of Requisitions by Buyer Chart (P4311X Form W4311XE)
  4. The line graph shows the following counts displayed
  5. Chart (P4311X) returns 62 records
    1.   Buyer 20298 - 8 records
    2.   Buyer 901188 - 22 records
    3.   Buyer 901288 - 1 record
    4.   Buyer 901688 - 31 records
    5.   There is are green bars displaying the number of closed orders
    6.   Why doesn't the chart (P4311X) return 89 records like the Query (P4311)?
    7.   Since the query criteria filters out Next Status 999, why do the green bars with closed orders (999) appear in the chart?

Cause

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 hundreds of Community platforms