CRM On Demand - Administration (MOSC)

MOSC Banner

How to restrict users from putting decimal values in a System provided number Field.

edited Oct 24, 2011 10:23PM in CRM On Demand - Administration (MOSC) 2 comments
Hi,

The issue is: in the Special Pricing Product there is a System Provided Field called: Quantity. This is a Number Field, which accepts decimals upto 2 Places.

Ideally Quantity of a Product cannot be in decimals, and it has to be in whole numbers. Since it is a system-defined field, we retained the field and decided against a Custom Integer Field.

Now, as natural the Quantity field in Special Pricing Product accepts a decimal value like: 10.05 or 11.29 .. like this.

I want to know is there an expression (sample Expression) by which I can put in a field validation that will restrict users to key in a decimal value in the Quantity field.

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