DRP and SPP Plans During The Release Of DRP Shipement Order or SPP Transfer Orders - The Internal Sales Order (ISO) Is Getting Created With NULL Unit Selling Price and Remains in Entered Status Instead of Booked
(Doc ID 1546468.1)
Last updated on APRIL 25, 2017
Applies to:Oracle Service Parts Planning - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version,
Note that this was originally created for SPP Plan output, but applies to DRP plans when releasing Planned Inbound Shipment Orders and SPP plans when releasing New Transfer Orders
Item = JMake
Org = TST:M1
Users went into the SPP workbench and released a order type = Planned Transfer for qty = 29 with schedule shipment date = 19-FEB-2013 and Schedule Arrival Date 20-FEB-2013
The release was successful as the output of the log shows:
Order No in PWB = 10916008
Load Type = Release
ISO No = 7023730
Qty = 29
schedule shipment date = 19-FEB-2013
Schedule Arrival Date 20-FEB-2013
Internal Req No = 11824
Need by Date = 20-FEB-2013
1 out of 1 Internal Req/ISO released successfully
Now when they go to the Sales Order form in the source and query the Internal Sales Order (ISO) = 7023730 they see the data successfully but the Unit Selling Price is NULL and thus the problem. The sales order is also shown with Status = Entered and not booked (probably because of the missing data). We confirmed the item is on the price list for OM.
In researching this issue it looks just like a DRP issue in <Bug 7284253>. This bug is an 11.5.10 patch and created a new profile called MSC: Pass List Price to OM in DRP Release (I believe it's a source instance profile). The customer does not have this profile in either source nor destination apscheck outputs. I checked internal 220.127.116.11 instance and we don't have it either. There's a forward port 12.0 <Bug 7497020> but it's not been finished. There is no 12.1 bug that I can find on this issue
Per discussion with development this new profile, even though it says DRP in it's naming convention, should work for SPP as well. Customer key file versions:
Expect Planned Transfer release from SPP workbench to create the IR/ISO and also have the unit selling price populated on the ISO sales order line and this should also be booked status and not entered
The issue can be reproduced at will with the following steps:
1. Release Planned Transfer from SPP workbench
2. IR/ISO are created successfully but the ISO is in entered status probably because the list price, unit selling price is not picked up
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!