My Oracle Support Banner

Auto Release of Planning suggestions for APS fails with :1:GMO_DISABLED_ERR (Doc ID 2073172.1)

Last updated on AUGUST 28, 2019

Applies to:

Oracle Process Manufacturing Process Planning - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, APS Feedback

When attempting to release an ASCP Planned order for an OPM make item,
the following error occurs.


GMPRELAP: Auto Release of Planning suggestions for APS

===== Input Parameters =====
p_process_id = 1014
p_organization_id =
p_fitem_no =
p_titem_no =
p_fdate =
p_tdate =
Implementing Batches
New btach Processing for Group ID = 1014 Header ID = 16093
Before validate Effectivity
p_organization_id 309
p_inventory_item_id 5
p_effectivity_id 131
p_plan_quantity 2000
Batch type 0
p_start_date 09-NOV-15
p_end_date 09-NOV-15
 No effectivity id
After validate Effectivity
l_recipe_id 1
l_return 1
Calendar Code CP-Mon-70
Start Date 11/09/2015 23:59:00
End Date 11/09/2015 23:59:00
09/11/2015 23:58:59
Nearest End Date = 11/09/2015 23:00:00
 Error - Status is E or U User-Defined Exception
:2:ORA-01403: no data found
ORA-01403: no data found in Package INV_Quantity_Tree_PVT Procedure Check_Is_Reservable_SUB
:3:User-Defined Exception in Package INV_Quantity_Tree_PVT Procedure New_Tree_Node

The issue can be reproduced at will with the following steps:
1. Release an ASCP Planned order for an OPM Make Item

The issue has the following business impact:
Due to this issue, users cannot create batches is this way


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.