Recipe LOV In The Create Batch Form Shows Recipes Without Production Validity Rules (Doc ID 2924159.1)

Last updated on APRIL 05, 2023

Applies to:

Symptoms

When creating a batch, the LOV for Recipe on the Create Batch form shows recipes/versions that only have a Costing validity rule, not a Production validity rule, and therefore cannot actually be used to create a batch.

EXPECTED BEHAVIOR
Expect the LOV to only show recipes that are valid for batch creation.

STEPS
The issue can be reproduced at will with the following steps:
1. Create a recipe/version (Formulator or Process Engineer responsibilities > Recipes)
2. Create a Costing type validity rule (from Recipe Details, click Validity Rules button).
3. Open Create Batch form (Production Supervisor responsibility > Create Batch), do LOV on Recipe field. The recipe/version displays and can be selected.
4. When you click OK on Create Batch, the system correctly gives an error:

ERROR
APP-GMD-81134: No validity rules exist for validity rule specified criteria

Note that if there is no validity rule at all, or if the validity rule does not have a usable status, then the recipe is not shown. So the code is already checking validity rules, it is just not checking that the validity rule has a Recipe Use of Production.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.