How To Handle Numeric Fields When Profile Icx: Numeric Character = 10.000,00 (Doc ID 452839.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.0 to 11.5.10.0 [Release 11.5]
Information in this document applies to any platform.

Goal

When you change the profile option "ICX: Numeric Characters" = 10.000,00 the following custom.pll entries fail -> to_number(name_in('lines.order_quantity').  The problem is because name_in returns values like 5.100,20 and then to_number fails.

Solution

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 hundreds of Community platforms