My Oracle Support Banner

Warehouse Condition Is Not Working In OM Quote Expiration Date Defaulting Rule (Doc ID 2544660.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

If warehouse is added as a condition in defaulting validation template then defaulting rule does not work for OM quote expiration date.

1) Working Case:

Defaulting Setup
  > Attribute = Expiration Date
  > Attribute Defaulting Rules:
  Defaulting Condition = XYZ US
  Default Sourcing Rules:
Source Type = System Variable,
  Default Source/Value = sysdate+30 and,
Defaulting Condition Validation Template
  > Condition Name = XYZ US
  > Validation Rules
  #10 Attribute (Transaction Phase) = Value (Negotiation)
this works, i.e. when a new Quote is created on 22-Mar, it shows Expiration Date = 21-Apr.

2) Failure Case:

However, it does NOT work if added a new condition for Warehouse, i.e.
Defaulting Condition Validation Template
  > Condition Name = XYZ US
  > Validation Rules
  #10 Attribute (Transaction Phase) = Value (Negotiation),
  #10 Attribute (Warehouse) = Value (ABC) <<<< added new condition
then it does NOT work, i.e. when a new Quote is created on 22-Mar, it shows Expiration Date = null.

Why is is NOT working when warehouse is added as in the second case?

Solution

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
Goal
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.