My Oracle Support Banner

Selection Criteria Is Not Working For Cust Fields In HDR And DTL (Doc ID 2618178.1)

Last updated on DECEMBER 13, 2019

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Tasks are not getting created when uses run Wave Template if the associated Task Template contains Selection Criteria based on Order Hdr Cust Field


For example, If the following is mentioned in the selection criteria

SQL operator=AND
SQL operator: =
Column name: Order Hdr Cust Field 1
Column value= CONSOL

SQL operator=AND
SQL operator: =
Column name: Order Hdr Cust Field 1
Column value= NOCONSOL

SQL operator=AND
SQL operator: =
Column name: Order Hdr Cust Field 1
Column value= AUTOPICKING

Order created has Order Hdr Cust Field 1 = AUTOPICKING

With this configuration, Users expect that the Task Template to create tasks depending on the order´s “Cust field 1” but this is not working.


EXPECTED BEHAVIOR
-----------------------
Expect to create Tasks creation happens based on order Header “Cust field 1


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

1. Create a Order with Order Header Cust field 1 AUTOPICK and a Order DTL line with DTL Cust field 1 as NULL
2. Create wave template with the task template setup with a different “Selection Criteria”.

SQL operator=AND
SQL operator: =
Column name: Order Hdr Cust Field 1
Column value= CONSOL

SQL operator=AND
SQL operator: =
Column name: Order Hdr Cust Field 1
Column value= NOCONSOL

SQL operator=AND
SQL operator: =
Column name: Order Hdr Cust Field 1
Column value= AUTOPICK


3. Run the wave Template to allocate the Order. The Order allocation is created but no tasks

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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