My Oracle Support Banner

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" (Doc ID 1454882.1)

Last updated on FEBRUARY 22, 2019

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.


  • And as a consequence of that problem, the Voucher Manager Service Management Server (SMS) management screen shows "No information available" in the Subscriber ID field for a redeemed voucher instead of the Subscriber ID:



    The OS user running the ccsCDRLoader may be modified.


    To view full details, sign in with your My Oracle Support account.

    Don't have a My Oracle Support account? Click to get started!

    In this Document

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