My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
 The context is a custom business component which requires import functionality - import Rules. It is invoked from applet menu item "Import"
 BEHAVIOR:
Changes
Cause
Solution
 New Field ("Rule Number") is used to identify if record already exists during import. "Rule Text" Field is no longer used as Import Key Field.
References


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