Custom Selectors Loader Not Working When The Selector Name Contains % Character (Doc ID 2741763.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

User encountered two issues while trying to upload (using ece_selector_loader.sh) a custom selector with the character '%' in the name:

1) The selector information is not correctly transformed from xml to csv format:
    a) The name in the selector header is incorrect
    b) The rule entry is not correct

2) The script aborts but prints out information about successfully loaded selectors - it is incorrect as the extension cache is empty since the transaction aborted
     Example: selector name is "International 40% discount"


EXPECTED BEHAVIOR
-----------------------
Expected header:
       #SELECTOR_BEGIN[CHARGE] SelectorName[International 40% discount]

Expected rule line:
       CHARGE International 40% discount af5ce6eb-d257-4cb8-aadd-e4cf4a401960 1 0 R_1 PPD.C_RULE.000617.VOICE 67279388-697d-4b85-bfb9-f36352e3f120:ORIG_ZONE_RESULT:Apeluri internationale REGEX[.*] REGEX[.*] REGEX[.*] REGEX[.*] VM_MAPS_TO[EXM;ZONEMAP_SERVICES;Voice-CC] VM_MAPS_TO[*] VM_MAPS_TO[*] VM_MAPS_TO[*] VM_MAPS_TO[EXM;ZONEMAP_DESTINATION_INTL_VOICE;USACAN]

ACTUAL BEHAVIOR
-----------------------
Actual header:
        #SELECTOR_BEGIN[CHARGE] SelectorName[International 40 0iscount]

Actual rule line:
        CHARGE International 40 0iscount af5ce6eb-d257-4cb8-aadd-e4cf4a401960 1 0 R_1 PPD.C_RULE.000617.VOICE 67279388-697d-4b85-bfb9-f36352e3f120:ORIG_ZONE_RESULT:Apeluri internationale

IMPACT
-----------------------
This will cause wrong discounting as missing entries in the extension caches will lead to not recognized discount rules.

Cause

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