Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Restrict some special characters in description field of master items.

edited Oct 4, 2024 5:13PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 4 commentsAnswered ✓

Hi,

I want to restrict some special characters(~ @ _ - + = { [ } ] \ ; ? < > ?). I am achieving it through form personalization but functionality is not working. I am putting details below

Trigger event — when-new-item-instance

Trigger object — MTL_SYSTEM_ITEMS.DESCRIPTION_MIR

Condition — :MTL_SYSTEM_ITEMS.DESCRIPTION_MIR IS NOT NULL
AND :MTL_SYSTEM_ITEMS.DESCRIPTION_MIR = REGEXP_REPLACE(:MTL_SYSTEM_ITEMS.DESCRIPTION_MIR, '[~ @ _ - + = { [ } ] \ ; ? < > ?]')

Attaching snap for reference, Please help!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center