My Oracle Support Banner

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

Last updated on JUNE 28, 2017

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.