Manual Planned Order for OPM Make items gives No matching rows found in GMPRELAP (Doc ID 2000344.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, Planner workbench

ACTUAL BEHAVIOR
---------------
Manual Planned Order release doesn't create OPM batch

We are creating a manual planned order (Work Order) for a make item in the PWB and releasing it. The "Auto Release of Planning suggestions for APS" is not creating the batch for the make item.

Log file has the following:
+---------------------------------------------------------------------------+
User-Defined Exception
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
===== Input Parameters =====
p_process_id = 107136
p_organization_id =
p_fitem_no =
p_titem_no =
p_fdate =
p_tdate =
-No matching rows found.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


EXPECTED BEHAVIOR
-----------------------
Manual Planned Order release creates OPM batch

STEPS
-----------------------
Steps to Reproduce:
==============
- In PWB, open supply window.
- Create a new record and enter the org, make item, new date & qty.
- Save the record;
- check 'select for release' and release the manual planned order
- Check the log file of program "Auto Release of Planning suggestions for APS" in the source instance. The log doesn't have the batch number.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Users cannot release manual PLO from ASCP to create batches

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