Issues In Migrating Quarterly Customers Through CMT Utility (Doc ID 2413785.1)

Last updated on MARCH 11, 2019

Applies to:

Symptoms

On : 7.5.0.15.0 version, Conversion Manager

ACTUAL BEHAVIOR
------------------
CMT is unable to handle migration of quarterly customers to update all required fields (ACTG_LAST_T, ACTG_NEXT_T and ACTG_FUTURE_T) of BILLINFO table.

One can see the below data post migration in BILLINFO_T table whereas expected RODOD (Rapid Offer Design and Order Delivery) way is different. Please find same below (Both CMT and RODOD).

BILLINFO_T DB DATA:

CREATED_BY;BILLINFO_POID;CYCLE_LEFT;CREATED;ACTG_LAST_T;ACTG_NEXT_T;ACTG_FUTURE_T;LAST_BILL;NEXT_BILL;FUTURE_BILL
RODOD_E2E;110309541;3;19-May-18;18-May-18;01-Jun-18;01-Jul-18;18-May-18;01-Aug-18;01-Nov-18
CMT;110348675;3;08-May-18;01-Jul-18;01-Aug-18;01-Sep-18;01-May-18;01-Aug-18;01-Nov-18

One has below scenarios which we will performed as a part of migration :

1) Migration of quarterly customer in first month of billing cycles (I.e BILL_ACTGCYCLES_LEFT will be '3' and NEXT_BILL_T will be aligned accordingly).
2) Migration of quarterly customer in second month of billing cycles (I.e BILL_ACTGCYCLES_LEFT will be '2' and NEXT_BILL_T will be aligned accordingly).
3) Migration of quarterly customer in Third month of billing cycles (I.e BILL_ACTGCYCLES_LEFT will be '1' and NEXT_BILL_T will be aligned accordingly).

For all the above scenarios mentioned, the accounting cycle fields (ACTG_LAST_T, ACTG_NEXT_T and ACTG_FUTURE_T) remains same which is similar to monthly customer data (i.e. one month back compared to next_bill_t whereas expected to 3 month in ideal scenario).

EXPECTED BEHAVIOR
-----------------------
migration is done on 8th May with NEXT_BILL = 01-Aug-18, the ACTG_LAST_T;ACTG_NEXT_T;ACTG_FUTURE_T has to be 1st may, 1 June, 1 July 2018 respectively.
Actual result : ACTG_LAST_T;ACTG_NEXT_T;ACTG_FUTURE_T is coming as 01-Jul-18;01-Aug-18;01-Sep-18;01

Changes

Cause

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