Secondary A_NUMBER Replace With Primary A_NUMBER in OCOMC EP (Doc ID 2539655.1)

Last updated on OCTOBER 15, 2019

Applies to:

Goal

On : 6.0.0.2.0 version, Cartridge Pack

Had an requirement to replace the secondary SIM number with Primary SIM number when call made from Secondary in Oracle Communications Offline Mediation Controller(OCOMC) and rating needs to be happens on primary number. Followed the below steps.

1. Create the Enhancement Processor (EP) Node(give the Database connection and SQL file name in Node configuration).
2. Create the Structured Query Language (SQL) file to get the primary number and place it on the $OCOMC/web/docs/sql directory.
3. Call the SQL in EP node Node Programming Language (NPL) file and get the value and replace the A_NUMBER with the Primary Number which got from the SQL.

Question: How to execute the SQL command in NPL to get the data from the Billing and Revenue Management (BRM) profile_t tables?

Solution

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