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.

Symptoms

On : 12.1.3 version, APS Feedback

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

ERROR
-----------------------

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
CP-Mon-70
09/11/2015 23:58:59
Nearest End Date = 11/09/2015 23:00:00
 Error - Status is E or U User-Defined Exception
:1:GMO_DISABLED_ERR
: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

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

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms