Import Functionality inserting duplicate rows

(Doc ID 2119284.1)

Last updated on JULY 07, 2017

Applies to:

Siebel eCommunications - Version 8.1.1.11.12 [IP2013] and later
Information in this document applies to any platform.

Symptoms

The context is a custom business component which requires import functionality - import Rules. It is invoked from applet menu item "Import"

  -An Import Object was created as per https://docs.oracle.com/cd/E14004_01/books/ConfigApps/Procedures_business_layer15.html#wp1099658
 - This object has two Import Key Fields defined

BEHAVIOR:

After importing from a file there are some duplicated records which should not exist as per Import Key Field.
Issue is reproduced in both cases Auto Mapping and Predefined Mapping.

Example:

Initial row: (.)(?:.*?\\1){5}
Duplicate row: (.)(\?:.\*\?\\1){5}

Initial row: (.)\\1{2}.*?(.)\\2{2}
Duplicate row: (.)\\1{2}.\*\?(.)\\2{2}

Initial row: (.{3}).?\\1
Duplicate row: (.{3}).\?\\1

Initial row: (.)(?:.*?\\1){4}
Duplicate row: (.)(\?:.\*\?\\1){4}

Initial row: (.)0\\1.?(.)0\\2
Duplicate row: (.)0\\1.\?(.)0\\2

Initial row: ^.(?:.0){3}$
Duplicate row: ^.(\?:.0){3}$

Initial row: (.)(.)(.).?\\3\\2\\1
Duplicate row: (.)(.)(.).\?\\3\\2\\1

Conclusion: Below characters are escaped:

? AND *

 

Changes

 N/A

Cause

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