ACTG_FUTURE_T In BILLINFO_T Table In BRM Wrongly Populated For FEB 1 Billed Customers
Last updated on APRIL 03, 2015
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.3.1 to 7.5.0]
Information in this document applies to any platform.
When billinfo details of customers billed on February 1 was analysed, it was found that ACTG_FUTURE_T field of BILLINFO_T table in BRM is populated as March 29. Due to this after billing on March 1, ACTG_NEXT_T is populated as 29th of March and ACTG_FUTURE_T is populated as 28th of April. This is causing wrong dates in the invoice in the production environment, which is leading to rejection of invoice distribution.
1 Creating a customer on 28th of Jan.
2 Since it's a one day billing, the DOM will be 1, after the one day billing. And the current billing cycle is (1st of Feb to 1st of Mar)
3 Move the PVT to 1st of Mar and perform billing, the current billing cycle is 1st of Mar to 29th of Mar
So, the problem is in step 3, billing cycle is 1st of Mar to 29th of Mar, instead of 1st of Mar to 1st of Apr.
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