Posts

Edit/read nar file in OCOMC without Nar editor

Now it no more a challenge to read or modify nar file in offline mediation controller (OCOMC) . There is an OOB utility which we can use in your perl/shell script to read nar files . All the transactional files of OCOMC are always in NAR format . For ex : Intermediate file between two nodes . Success response file by ECE. Suspense file in suspense directory. No response file. you may encounter situation where you have to read these files to get some value or do some analysis. There is script with name : NARVIEWER on your OCOMC_HOME/bin/tools directory . You can use this script in your custom shel script to read nar files or to get record count in one narfile. Sample loop to get record count in all NAR files in a directory:  #!/bin/bash FILES=No_response* for f in $FILES do echo "Processing $f file..."  get_only_filename=${f##*/} echo $f app/BRM/opt/OracleCommunications/ocomc/bin/tools/NARViewer -narfile $f -count done You can us...
Post a Comment
Read more

NO_RESPONSE file handling during rating in ECE and OCOMC

Implementing NO RESPONSE file handling for the ECE Cartridge Pack and Offline mediation controller (OCOMC) PROBLEM STATEMENT :  The ECE DC receives the CDR input stream, which includes the ECE response records from Oracle Communications Billing and Revenue Management Elastic Charging Engine and checks for CDR errors. The records for which no response is received from ECE, they are sent to NO_RESPONSE Directory of that particular ECE DC node. If the number of files increases in this no_response directory, then it is a critical situation and this needs to be handled properly. Such type of Revenue Leakage of the CDRs need to be appropriately routed to avoid causing losses to the Bahrain operator. BACKGROUND STUDY : Step 1 : Network Accounting Record (NAR) Collection Cartridge (CC). The NAR CC reads the no response CDR input stream from the No response directory. The output is made available for the No Response DC ASCII .   Step 2 : NO RESPONSE OCECE ASCII Distrib...
Post a Comment
Read more

Script to create snapshot in Oracle ECE

In Oracle ECE patch set 3 , we need to take pricing snapshot before restart so that it can be recovered with same pricing data again. If snapshot is not taken then you will end up loosing all your pricing data in ECE cache. Then you have to go for PDC republish which may take more than 48 hrs (depending upon your price plan structure). To avoid this situation I would recommend you to schedule snapshot creation in crontab so that always you have backup . You can put a simple login to delete snapshot older than 30 days as per your business policy. Please find below steps to create pricing snapshot in oracle ECE using script . Create groovy with below lines of code . import java.lang.management.* import javax.management.ObjectName import javax.management.remote.JMXConnectorFactory as JmxFactory import javax.management.remote.JMXServiceURL as JmxUrl import groovy.swing.SwingBuilder import javax.swing.WindowConstants as WC import java.time.LocalDate import java.t...
Post a Comment
Read more

cm core dump analysis

Go to the location of core file , ideally it should be there in $PIN_HOME/sys/cm Then , execute below command :   gdb cm <core file name > It will execute debugger for the core file . Now , put below command : Thread apply all bt T he output of above command will dump the stack frames for all the threads in a process You can select thread a according to your issue. use below command to select a thread. Thread 1 This will switch to thread 1 after switchover the stack for the current thread can be dummped with bt command . bt Once the back trace is dumped we can inspect each frame, in this case frame 0 looks interesting to us, by using below command : frame 0 frame <number>" command is use to dump the particular frame of stack trace. The command "list +" will show the source for the stack dump . list+
Post a Comment
Read more

Account creation process in OPH (oracle product hub) or any oracle e-business suite application

Image
·          Firstly ,Create a person using GUI . ·          Open in IE only ·          Login and Go to :  home >  Oracle Sales Administrator > HRMS > Setup > person ·          Create new people by clicking on new button on toolbar.  ·          Fill in all the details and save . ·          You can also search for existing user and link it with employee in the same window . ·          This will create entry in FND_USER   ,  EGO_USER_V , EGO_PEOPLE_V and FA_EMPLOYEES tables ·          Again search your user in same window ·          Make sure person field in populated with...
1 comment
Read more

Query to get Suspended Usage for a CTN/MSISDN/Number

Below is the query we can use to get all the suspended records for a particular B-Number. ========================================= set linesize 200 pagesize 0 feedback off heading off variable start_date NUMBER BEGIN         :start_date := d2u('2016/12/10 00:00:00 +01:00'); END; / select /*+ parallel(10) */ su.primary_msid||','|| s.service_code ||','|| su.called_to ||','|| to_char(u2d(su.start_time, 'LOCAL'),'yyyymmdd') ||','|| sem.errormsg from suspended_usage_t s,susp_usage_telco_info_t su,SUSPEND_USAGE_TELCO_T vs,suspense_error_msg sem where s.poid_id0 = su.obj_id0 and s.poid_id0 = vs.obj_id0 and s.status = 0 and s.error_code = sem.errorcode and su.start_time > :start_date and rownum < 10 --and su.primary_msid = 'XXXXXXXXXX' ========================================
4 comments
Read more

Validation and resolution for BIP generating invoice pdf of zero size

Image
You might come across some issue in BRM-BIP where you will find that BIP is generating blank pdf of zero bytes. Root Cause :  It can happen due to BIP mount point getting full but still docgen in running and pushing invoice xml from brm to BIP temp . It leads to incorrect behavior of BIP causing formation of zero byte temp file at location :   /opt/shared/bip11g/xdo/tmp in BIP . EDU (electronic document uploader) is another weblogic domain which retrieves invoice pdf from BIP and publish them to WCC ( web content centre) . It picks pdf based on http request recieved from BIP . No validation for file size is there.  Then it stores the document in WCC. Data is stored in below six tables of WCC :  If you check for file size in filestorage table , you will find it as 0 , which confirms that pdf has not data in it. Resolution :  Firstly increase the mount point size to reduce further occurrence of this issue. Then extract all such invoic...
Post a Comment
Read more