My Oracle Support Banner

PO LINE GROUPED IN SAME LINES EVEN THOUGH NEED_BY_DATE HAVE DIFFERENCE TIMESTAMP (Doc ID 2571637.1)

Last updated on AUGUST 02, 2019

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
When running 'Requisition Import' concurrent after entering 2 DropShip SO with same item but different REQUEST_DATE timestamp(but same date),
the 1 new Purchase Order created via CREATEPO process because they set ASL&SourceRule.
In this create PO lines, the same item lines grouped in 1 line even though whose NEED_BY_DATE which defaulted from REQUEST_DATE in drop ship order are different timestamp.

EXPECTED BEHAVIOR
When running 'Requisition Import' concurrent after entering 2 DropShip SO with same item but different REQUEST_DATE timestamp(but same date),
the 2 new Purchase Order created via CREATEPO process because they set ASL&SourceRule.

STEPS TO REPRODUCE
- Example
1.Create 2 DropShip SO
SO#69689
Line Item Qty RequestDate
--------------------------------------------
1.1 DropShip06 1 16-APR-2019 15:30:13
2.1 DropShip02 1 16-APR-2019 15:30:13
3.1 DropShip05 1 16-APR-2019 15:30:13
4.1 DropShip04 1 16-APR-2019 15:30:13

SO#69690
Line Item Qty RequestDate
--------------------------------------------
1.1 DropShip06 1 16-APR-2019 15:33:51
2.1 DropShip02 1 16-APR-2019 15:33:51
3.1 DropShip05 1 16-APR-2019 15:33:51
4.1 DropShip04 1 16-APR-2019 15:33:51

3.Run WorkFlowBackgroundProcess

4.Run Requisition Import
GroupBy:Vendor
REQ#16063
Line Item Qty NeedByDate
--------------------------------------------
1 DropShip02 1 16-APR-2019 15:33:51
2 DropShip02 1 16-APR-2019 15:30:13
3 DropShip04 1 16-APR-2019 15:33:51
4 DropShip04 1 16-APR-2019 15:30:13
5 DropShip05 1 16-APR-2019 15:33:51
6 DropShip05 1 16-APR-2019 15:30:13
7 DropShip06 1 16-APR-2019 15:33:51
8 DropShip06 1 16-APR-2019 15:30:13

5.Check the created PO
PO#6956
Line Item Qty NeedByDate
--------------------------------------------
1 DropShip02 1 Multiple
2 DropShip04 1 Multiple
3 DropShip05 1 Multiple
4 DropShip06 1 Multiple

Shipment Line of the Line#01
Line Item Qty NeedByDate
--------------------------------------------
1 DropShip02 1 16-APR-2019 15:33:51
2 DropShip02 1 16-APR-2019 15:30:13

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