Create Called Number Translation Rules for Invalid NPA/NXX or ANI

It can be done by the script called exportForInvalidCallingNumbers.sql.

[ossadmin@nexoss ~]$ cd $NexOSS_HOME/sql/LERG
[ossadmin@nexoss LERG]$ ls
exportForIntraStateCalls.sql lerg_pre_load.sql
exportForInvalidCallingNumbers.sql nnacltb_load_instr.ctl
lerg_1_load_instr.ctl nnacltb_post_load.sql
LERG6.DAT nnacltb_pre_load.sql
lerg_6_load_instr.ctl RoutingCalledNumberManipulation.txt
lerg_6_load_instr.log telcodata_load_instr.ctl
lerg_post_load.log telcodata_post_load.sql
lerg_post_load.sql telcodata_pre_load.sql

Steps:

  1. Run this script. It will generate PreRoutingCalledNumberTranslation.txt file

  2. Delete last few lines indicating the number of exported rows from the generated file

  3. Upload the file to NexOSS (take note of any current rules and add them back to this file once uploaded - also take a backup copy of the current configuration file before uploading new file)

  4. Add a Pre-Routing Called Number translation rule for “All Other Numbers” to prefix called number with ### (###+)

  5. Add a Post-Routing Called Number translation for called numbers beginning with ### to strip the prefix (+)

  6. Don’t forget to add ### rates to your current rate plans too.

You should have something similar to the following in your Products-Full-View.

The goal is to have inTER rates, inTRA (##), and interdeterminate (###) routes/rates in your product full view.

  • If the Calling Number is valid, do not add ### to the called number. pre_routing_called_number_translation.cfg / calling-only

  • If the Calling Number is not in the valid ANI list, then add ### to the called number before routing to use indeterminate routes/rates. pre_routing_called_number_translation.cfg / All Other

  • If the Called Number was translated to ### before routing because of an invalid ANI, then remove the ### after routing before call hits destination. post_routing_called_number_translation.cfg / called-only