TN Block Search : Show Results Based On Provider Pool (Doc ID 2656273.1)

Last updated on JULY 12, 2022

Applies to:

Goal

On : 7.4.0.0.0 version, TN Component

TN Block Search : Show results based on Provider Pool

TNs have different chars like Line Type, Provider Pool , Switch etc. User is performing block search as below criteria.

Telephone Number starts with : xxxx.
Block Size : 999
Assignment Status : Unassigned

Currently results show the relevant ranges which is mix of Provider Pool Char like below

xxxxxxx1792 (Start Number) - xxxxxxx3799 (End Number) 2008 (Available)
xxxxxxx5000 (Start Number) - xxxxxxx8689 (End Number) 3690 (Available)

User want result as (PP1 is sample value of Provider Pool for example purpose)

xxxxxxx1792 (Start Number) - xxxxxxx1799 (End Number) 8 (Available) PP1 (Provider Pool 1)
xxxxxxx1800 (Start Number) - xxxxxxx3799 (End Number) 2000 (Available) PP2 (Provider Pool 2)
xxxxxxx5000 (Start Number) - xxxxxxx5999 (End Number) 1000 (Available) PP1 (Provider Pool 1)
xxxxxxx6000 (Start Number) - xxxxxxx8689 (End Number) 2690 (Available) PP3 (Provider Pool 3)
 

Solution

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