You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to prevent item description containing carriage return?

Received Response
17
Views
2
Comments
edited Aug 2, 2019 2:40PM in Product Development 2 comments

Summary

Need to prevent end user from creating new items (or updating existing items) with item description containing a carriage return (easily happens when using copy/paste from another application/source)

Content

Trying to get the "prevent item description containing carriage return" requirement working using a 'Validation' item rule, where the Product Management implementation manual (https://docs.oracle.com/en/cloud/saas/supply-chain-management/19c/faipr/defining-product-rules.html#FAIPR1237667) mentioned string functions contains() and match() seem most likely candidates to somehow be able to do the job.

We've been using several item rules successfully, but even after several hours of playing around with string functions contains() and match() we seem to be struggling to get this requirement working. For example below rule setup seems to always raise an error (with or with carriage return present in the item description):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!