My Oracle Support Banner

Item Rule - How To Add Additional Condition For Restricted Sub_Inventory Item (SI) Must Be Finish Goods Item (FGI)? (Doc ID 2668283.1)

Last updated on MAY 25, 2022

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Goal


Item rule - How to add additional condition for Restricted Sub_Inventory Item (SI) which must be Finish Goods Item (FGI)?

Business logic is if Hold days is equal to 30 and Shelf Life days is equal to 30 in that case Restricted Sub-inventory Item (SI) cannot be null as well as Restricted SI must be FGI (Finish Good Item). All these attributes belongs to Inventory Attribute Group.

IF Expression : IN("30", [Item].[Inventory].[Hold Days], [Item].[Inventory].[Shelf Life Days]) ---- no issue .

Validation Condition: (!isNull([Item].[Inventory].[Restrict Subinventory])) --- no issue

but as soon as user adds additional condition && [Item].[Inventory].[Restrict Subinventory] == "FGI" system is giving the error message.

Error: FGI is not a valid number. (EGO-2745439)

How to add additional condition for Restricted Sub inventory which must be FGI.


Solution

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
Goal
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.