My Oracle Support Banner

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 AUGUST 19, 2019

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

MRPCISOB.pls 120.12.12010000.6
mscprf.ldt 120.57.12010000.84

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!

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.