ORACLE BILLING AND REVENUE MANAGEMENT

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+

·          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...

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' ========================================

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...

Problem Description :  We observed that customer centre is taking long  time to search when we put account number . Usually it takes 4-5 minutes to give the search results. Solution offered : We tried to capture sql being fired from OOTB search of customer centre  : Sql text : select  distinct  account_no, poid_DB, poid_ID0, poid_TYPE, poid_REV, brand_obj_DB, brand_obj_ID0, brand_obj_TYPE, brand_obj_REV from account_t   where lower( account_t.account_no ) = :1  We tried making some changes in query by removing lower function on account_no field and cost reduced enormously.Now the search if producing output in less 5-6 seconds. The best option here is to create function based index on the column account_id so that it can perform Index scan. 

Usually we came across situations where we need to get debug logs of some opcode without changing anything in account data . We can use below flist to get log by aborting the opcode transaction after successful execution . We can use below flist for following purpose : To get search being invoked in OOTB/Custom opcode. To get the flow of function being called as part of concerned opcode. To get debug logs of opcode. To triage failure reason for particular action. =============================================== r << XXX 1 0 PIN_FLD_POID           POID [0] 0.0.0.1 /plan 1 0 XXX xop PCM_OP_TRANS_OPEN 65536 1 r << XXX 1 0 PIN_FLD_POID        POID [0] 0.0.0.1 /account 1 1 0 PIN_FLD_COMPONENT    STR [0] "CM" 0 PIN_FLD_LOGLEVEL     INT [0] 3 XXX xop PCM_OP_INFMGR_SET_LOGLEVEL 0 1 r << XXX 1 .................put your ...