The "Subscriber ID" from the Voucher Manager Screen Shows "No information available" AND the ccsCDRLoader Fails With the Message "ccsCDRLoader(847) ERROR: flush: UPDATE: ORA-01403: no data foun"
Last updated on OCTOBER 18, 2016
Applies to:Oracle Communications Network Charging and Control - Version 4.4.1 and later
Information in this document applies to any platform.
In a normal situation When a voucher is redeemed, two EDRs are created:
- EDR type 4 : a Voucher Redeem EDR is created as a consequence of the voucher redeem action.
- EDR type 15 : if the Voucher Redeem operation succeeds, the account's wallet is recharged with the voucher value. A Wallet Recharge EDR is created as a consequence of the recharge action.
These EDRs will be sent to the SMS by the cmnPushFiles process to be transferred in the ccsCDRLoader incoming directory. The ccsCDRLoader will apply a series of plugins, each of which runs actions based on the type and the content of CDR.
One of these plugins is the VoucherRedeemPlugin, which scans Type 4 EDRs to insert data of every redeeming action into the main database on the SMS.
This problem has several symptoms that may be observed together:
On the Type 15 EDR
As explained above, with each voucher recharge, a type 15 EDR (consequence of the wallet recharge) will be created. Despite the fact that the recharge itself worked, and as a consequence of this problem, it may show an incorrect value in the VOUCHER tag.
The OS user running the ccsCDRLoader may be modified.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms