My Oracle Support Banner

Sales Orders Are Using An Incorrect Request Date To Derive Blanket Line Number (Doc ID 2593571.1)

Last updated on JANUARY 07, 2022

Applies to:

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


On : 12.2.6 version, Agreements/Blankets/Contracts

Dependency is created between Line Type and Request Date in defaulting dependency package.
When changing the Line Type on the line we see the Blanket Line Number is flipping to a unexpected value even though the request date on the line remains unchanged.
The seeded Dependencies in file OEXUDEPB.pls does not show any seeded dependency between request date or Line Type with the Blanket Line Number

Expected is Blanket Line Number should not get changed.

The issue can be reproduced at will with the following steps:
1. Define the dependency between Line Type and Request Date in OEXEDEPB.pls
2. Created sales Agreement with same item with 2 lines having prices covering the sysdate and also future date .
  For example
  agreement line#    item            active date from Active   end date Price
  1                        ItemA          01-JUNE -2019               11-JULY-2019 10
  2                        itemB          11-JULY-2019                 30-JULY-2019 20
3.Enable the defaulting rule for the Request date to default the request date of future date say 30-JULY-2019 .
4. Create an order with one order line line and enter agreement number and notice the agreement line # on the line is populated with the number 2 whose price = 20 which falls  in that date range 30-JULY-2019.
5. Change the Line type on the line and notice the agreement line flips to 1 even though the Request date remains same.



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.