My Oracle Support Banner

CCSCD1=QRY Command Returns Different Values when Invoked with BALANCE_TYPE set to "ALL" vs when Invoked with BALANCE_TYPE Specifically Set (Doc ID 1539592.1)

Last updated on MAY 06, 2020

Applies to:

Oracle Communications Network Charging and Control - Version 4.3.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Communications Network Charging and Control (OCNCC or NCC), when calling the CCSCD1=QRY Provisioning Interface (PI) command, the units of the returned balance can be different, for example:

Executing CCSCD1=QRY with BALANCE_TYPE=ALL returns small units of currency:

CCSCD1=QRY:MSISDN=<MSISDN>,BALANCE_TYPE=ALL,SYNSTAMP=2013031208215209;
CCSCD1=QRY:ACK:MSISDN=<MSISDN>,ACCOUNT_NUMBER=<Wallet Number>,PRODUCT=Product1,STATUS=P,WALLET_EXPIRY_DATE=,LANGUAGE=english,BALANCES=General Cash:1000:|Bad Pin|Monthly Exp|Yearly Exp|Wallet Exp|MMS Refund|SMS Refund,SYNSTAMP=2013031208215209;

Executing CCSCD1=QRY with BALANCE_TYPE=General Cash returns big units of currency:

CCSCD1=QRY:MSISDN=<MSISDN>,BALANCE_TYPE=General Cash,SYNSTAMP=2013031208215210;
CCSCD1=QRY:ACK:MSISDN=<MSISDN>,ACCOUNT_NUMBER=<Wallet Number>,PRODUCT=Product1,SERVICE_PROVIDER=Service Provider1,STATUS=P,CREATION_DATE=20130311150002,WALLET_EXPIRY_DATE=,BALANCE_EXPIRY_DATE=,BALANCE_OFFSET_DATE=,BALANCE=10,INITIAL_BALANCE=0,LANGUAGE=english,LAST_RECHARGE_DATE=,LAST_CC_RECHARGE_DATE=,LAST_USE_DATE=,LAST_RECHARGE_AMOUNT=0,PREV_WALLET_EXPIRY_DATE=,PREV_BALANCE_EXPIRY_DATE=,PREV_BALANCE=0,LAST_EXP_CREDIT=0,TOTAL_EXP_CREDIT=0,LAST_EXP_DATE=,FIRST ACTIVATION DATE=,LAST_STATE_CHANGE_DATE=20130311150002,LAST_STATE_CHANGE_REASON=,BYPASS_NUMBER=,WALLET_TYPE=Primary,CHARGING_DOMAIN=1,FFD=,FFN=,FDN=,CUG=,CURRENCY=UAD,FREE_SWAPS_REMAINING=0,LAST_SWAP_RESET_DATE=,SYNSTAMP=2013031208215210;

Changes

None

Cause

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
Symptoms
Changes
Cause
Solution


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