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:

Symptoms

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

Changes

Cause

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