Additional Issues With The Db2irules.pl Script

(Doc ID 1936440.1)

Last updated on OCTOBER 31, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

After applied the patch 19428842

1. When execute the db2irules.pl script with the -u option the generated output file does not match the ST_CIBER_VAL.xml file that was loaded in the pipeline database.

2. When execute the db2irules.pl script with the -d option the CIBER validation rules are not deleted from the pipeline database.

  We believe that the validation rules are not deleted because the pattern in the delete SQL queries is not correct.

  We can see that the delete SQL queries executed by the db2irules.pl script are as follow:
  DELETE FROM IFW_RULESETLIST WHERE RULESET = 'CIBER_VAL%'
  DELETE FROM IFW_RULESET WHERE RULESET = 'CIBER_VAL%'
  DELETE FROM IFW_RULEITEM WHERE RULE_ID = 'CIBER_VAL%'
  DELETE FROM IFW_RULE WHERE RULE_ID = 'CIBER_VAL%'

  These delete SQL queries should be as follow:
  DELETE FROM IFW_RULESETLIST WHERE RULESET like 'CIBER_VAL%'
  DELETE FROM IFW_RULESETLIST WHERE RULESET like 'CIBER_VAL%'
  DELETE FROM IFW_RULEITEM WHERE RULE_ID like ‘CIBER25.ASS_CIBER_EXT%’
  DELETE FROM IFW_RULE WHERE RULE_ID like ‘CIBER25.ASS_CIBER_EXT%’


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