Random Number Is Getting Generated In Order Line Number Instead Of Sequence (Doc ID 2246128.1)

Last updated on MARCH 21, 2017

Applies to:

Siebel eCommunications - Version 8.1.1.14.10 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.14.10 [IP2014] version, Order Management

ACTUAL BEHAVIOR
---------------
FINS Data Transfer Utilities --> DataTransfer generating random sequence number


EXPECTED BEHAVIOR
-----------------------
Customer expecting LN_NUM should be generated as next seq value in the Order context

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Same behavior observed even we simulate the FINS Data Transfer Utilities (Data Transfer).
2.Steps to reproduce the issue.
First create an Order with order lines having hierarchy of products.(for example root product with 4 child products)
LN_NUM Product
1 Root Product
2 Child Product1
3 Child Product 2
4 Child Product 3
5 Child Product 4
Now create and another order and create the order lines using FINS Data Transfer Utilities (Data Transfer). Using Source filter Specification allow only Root Product, Child Product 1,2 and 4 to be copied and not Child Product 3. In this order line numbers would be like this.

LN_NUM Product
1 copy of Root Product
2 copy of Child Product1
3 copy of Child Product2
4 copy of Child Product4

now run the Data Map again and copy Child Product 3. Now the line number would be some random number instead of 5

LN_NUM Product
1 copy of Root Product
2 copy of Child Product1
3 copy of Child Product2
4 copy of Child Product4
412345 copy of Child Product3



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms