My Oracle Support Banner

E1: 42: Executing Query With Match Any Conditions In Sales Speed Status Update (P42040) Ignores Processing Options Set To Display Records With a Specific Last/Next Status (Doc ID 2949985.1)

Last updated on JUNE 27, 2023

Applies to:

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


P42040 sales speed status update inquiry displays sales order with all next statuses ignoring the next status setup in the P42040 processing option when a query is set to filter with match any conditions for sold to number field.

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

  1. P42040 - Setup processing options to display records with next status = 540
  2. P42040 - Click find and observe only records with next status = 540 is displayed for all sold to customers
  3. Create a new query with match any condition to display the records from sold to customer 4141 and 6074
  4. Added 2 lines of sold to address to the match condition; First where clause is for sold to address 4141 and second clause is for address 6074
  5. Save and execute
  6. P42040 - Observe P42040 respects the last status for address 6074 but not for 4141
  7. P42040 - Records with all last statuses are displayed for sold to address 4141




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.