Selected ingredient does not appear in Advanced Conditions if ingredient_id >= 12 digits (Doc ID 2221033.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

The selected ingredient value in AC does not populate after saving Advanced Condition(AC).


---------------------------------------------
STEPS
---------------------------------------------

(eg.,) The following ingredients which is LM_INGREDIENTS.ingredient_id >= 12 digits has been configured.

INGREDIENT 001 (ingredient_id = 103447702101)
INGREDIENT 002 (ingredient_id = 103447702102)

1. Create a new AC
2. Select the conditions (eg., "equal to")
3. Navigate to PRODUCTS > Product information and select "Ingredient"
4. Select ingredient "INGREDIENT 001"

5. Save the setting

6. Click [Show SQL]

CASE_PROD_INGREDIENT.INGREDIENT_ID = 0 has been set instead of the actual ingredient_id.

7. Close the AC
8. Open the AC settings again.

The different ingredient "INGREDIENT 002" is displayed.

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.