Incorrect Aggregation Results With FCT_AggreGate Functional Module (Doc ID 1451982.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.4.0.0.0 [Release 7.3.0 to 7.4.0]
Information in this document applies to any platform.
***Checked for Relevance on 13th August 2015***

Symptoms

File with aggregation results contains incorrect data.
  Current results:
  00001000004568;20111122;20111220;PINUNIT-LOGIN:8832:14438231011133260;1
  ;20111122;20111220;PINUNIT-LOGIN:8832:14438231011133260;1
  ;20111122;20111220;PINUNIT-LOGIN:8832:14438231011133260;2
  Expected results:
  00001000004568;20111122;20111220;PINUNIT-LOGIN:8832:14438231011133260;3
 
  Steps to reproduce:
  1. Create aggregation scenario CDR_003  with following configuration
  a) Grouping fields
  - DETAIL.CUST_A.ACCOUNT_NO
  - DETAIL.CUST_A.BILL_LAST_DATE
  - DETAIL.CUST_A.BILL_NEXT_DATE
  - DETAIL.CUST_A.PRODUCT.SERVICE_LOGIN
  b) Field: DETAIL.RECORD_NUMBER
     Aggregation Function: Count
  c) Condition: none (aggregate all records)
  2. Rate 3 CDR via pipeline
  3. Verify aggregation results

  Here is the result on test system (ref. skalel)

  e.g. Process the following services usage for 0049100052 and 0049100060
  TEL;0049100052;004941067600;20110925133030;3600;0;0;NORM;123456;
  TEL;0049100052;004941067600;20110925133030;3600;0;0;NORM;123456;
  TEL;0049100060;004941067600;20110925133030;3900;0;0;NORM;123456;
  TEL;0049100060;004941067600;20110925133030;3900;0;0;NORM;123456;
  TEL;0049100060;004941067600;20110925133030;3900;0;0;NORM;123456;
  TEL;0049100052;004941067600;20110925133030;3600;0;0;NORM;123456;
  TEL;0049100052;004941067600;20110925133030;3600;0;0;NORM;123456;
  TEL;0049100060;004941067600;20110925133030;3900;0;0;NORM;123456;

  Expect Result:
  ;20111020;20111120;249-20110920-155152-1-29338--148342560-skalel.com;4
  ;20111020;20111120;622-20110920-162616-0-2467--148342560-skalel.com;4

  Actual Result:
  ;20111020;20111120;249-20110920-155152-1-29338--148342560-skalel.com;2
  ;20111020;20111120;622-20110920-162616-0-2467--148342560-skalel.com;1
  ;20111020;20111120;249-20110920-155152-1-29338--148342560-skalel.com;1
  ;20111020;20111120;622-20110920-162616-0-2467--148342560-skalel.com;2
  ;20111020;20111120;249-20110920-155152-1-29338--148342560-skalel.com;1
  ;20111020;20111120;622-20110920-162616-0-2467--148342560-skalel.com;1

 

Cause

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