Item Substitution Rule Not Working In OM To Split The Line With Partial Substitution (Doc ID 1643379.1)

Last updated on JULY 19, 2021

Applies to:

Goal

In 12.2.3 - OM added new functionality surrounding Item Substitution:
Scheduling Auto Split Criteria
New system parameter 'Scheduling Auto Split Criteria '' controls this functionality.

Customer has the profile set to With Partial Substitution this means that during Scheduling following behavior should take place
Split the first line with quantity available on request date and second line with substitute item with remaining quantity.

See the following:
Oracle® Order Management
Implementation Manual
Release 12.2
Part No. E48842-01

Refer to 2-98 Oracle Order Management Implementation Manual

Customer is getting the following error:
Scheduling failed :cannot meet Request Date or latest acceptable date
Order is Booked

In the debug file we see the following:

SUBSTITUTION OCCURED
SUB ITEM :2002
ORIG ITEM :1
ORIG NAME :19156
ORIG REQ_ITEM_REQ_DATE_QTY :0
ORIG REQ_ITEM_AVAILABLE_DATE_QTY :16-AUG-14
ORIG REQ_ITEM_AVAILABLE_DATE :16-AUG-14
SUB QTY_ON_REQUEST_DATE :0
SUB ORDERED_QTY_AVAILABLE_DATE :28-FEB-14
SUB QTY_ON_AVAILABLE_DATE :4200
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for MASTER_ORGANIZATION_ID
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
Parameter value exists.
PARAMETER VALUE: 82
ENTERING ORDERED_ITEM
IN OEXSIDVB ITEM IDENTIFIER IS INT
ORDERED_ITEM_DSP: 19156
ORDERED_ITEM_DSP: 19156
ENTERING ORDERED_ITEM
IN OEXSIDVB ITEM IDENTIFIER IS INT
ORDERED_ITEM_DSP: 19156-31182
ORDERED_ITEM_DSP: 19156-31182
ERROR FROM MRP: 53
SCHEDULING FAILED
53

Per GOP:
The GOP User Guide references this with the following - which has been the functionality since inception of support for End Item Substitution
Ref Oracle Global Order Promising Implementation and User's Guide Release 12.1 Part No. E13378-07
Chapter 5 - End Item Substitution
pg 5-2 -
Note: Oracle Global Order Promising currently supports only the No Substitution or Full Substitution options.It does not support partial substitution....

Customer needs to know if this functionality works or does not work as the OM Guide suggests.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.