Get Error, "Primary product does not match the current validity rule" Publishing Reschedule of Batch from Production Scheduling (PS) (Doc ID 2265419.1)

Last updated on MAY 12, 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 publish a reschedule of a batch from PS back to the batch itself, the Auto Release of Planning suggestions for APS log shows:
GMP Item Effectivity for Group Id = 489775 is Invalid for Item_no(id) = PCT90211(543649)
-Primary product does not match the current validity rule.

This occurs when the validity rule from which the batch was created has a validity_rule_status of 701 - a status of 700 works. It appears that the code in GMPRELAB.pls is checking for "status in ('700','900')", which does not take into account that we provide the ability for customers to create their own statuses. Any status from 700 - 799 and which has a status_type=700 in gmd_status is supposed to be treated the same as status 700 (and similarly for statuses between 900 and 999).

Note that the process effectivity was collected, so that code seems to be handling status correctly; the problem seems to be specifically in GMPRELAB.pls.

ERROR
-----------------------
GMP Item Effectivity for Group Id = 489775 is Invalid for Item_no(id) = PCT90211(543649)
-Primary product does not match the current validity rule.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new status 701 on the Status Codes form (Formulator > Setup > Status Codes
2. Set the status of a validity rule to this new status.
3. Create a batch from this validity rule.
4. Run collections and then use PS to reschedule the batch
5. Try to publish the change.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use PS for rescheduling batches using these validity rules.

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