Expression Mismatch Between DMW And LSH Source Code (Doc ID 2951938.1)

Last updated on JULY 13, 2023

Applies to:

Goal

The purpose of this document is to find out why there is a mismatch between the expression defined in DMW and what was generated in LSH as shown below:

DMW
=====
CASE WHEN REGEXP_LIKE(DECODE(SUBSTR(<STRING>, 1, 1), '.', '0' || <STRING>, ',', '0' || <STRING>, <STRING>), '^[0-9]\d{0,2}(\,\d{3})*(.\d+)?$') THEN <STRING> END

LSH
=====
CASE WHEN REGEXP_LIKE(DECODE(SUBSTR(ORRESMB, 1, 1), '.', '0' || <STRING>, ',', '0' || <STRING>, <STRING>), '^[0-9]\d.{0,2(\,\d{3})*(.\d+)?$') THEN <STRING> END

Difference:

, '^[0-9]\d{0,2}(\,\d{3})*

Or
'^[0-9]\d.{0,2(\,\d{3})*
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.