My Oracle Support Banner

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

Last updated on MARCH 25, 2019

Applies to:

Oracle Argus Safety - Version 7.0.5 to 8.2 [Release 7.0.0 to 8.2]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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