My Oracle Support Banner

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

Last updated on JANUARY 06, 2017

Applies to:

Oracle Argus Safety - Version 7.0.5 and later
Information in this document applies to any platform.

Symptoms

The selected value of the ingredient does not populate in AC 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.

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!


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