AIA/BRM: Future Date Is Getting Committed When PCM_OP_CUST_MODIFY_CUSTOMER Is Run
Last updated on JUNE 01, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 15-Apr-2013***
Checked for relevance on 28-May-2016
There are 5 hours difference in PURCHASE_START_T, USAGE_START_T, CYCLE_START_T when calling PCM_OP_CUST_MODIFY_CUSTOMER in the timestamp when a user passed them from AIA and at the time it reaches CM.
For example, for modify_customer from AIA:
in corresponding fragment of cm.pinlog
3 PIN_FLD_CYCLE_START_T TSTAMP  (18000) Thu Jan 1 00:00:00 1970
3 PIN_FLD_USAGE_START_T TSTAMP  (18000) Thu Jan 1 00:00:00 1970
3 PIN_FLD_PURCHASE_END_T TSTAMP  (31467600) Thu Dec 31 00:00:00 1970
3 PIN_FLD_CYCLE_END_T TSTAMP  (31467600) Thu Dec 31 00:00:00 1970
3 PIN_FLD_USAGE_END_T TSTAMP  (31467600) Thu Dec 31 00:00:00 1970
The BRM server timezone is UTC-5.
The offset 18000 should not be applied, as the purchased product should start now. When 18000 offset is applied, the time stamp is set to 5 hours ahead from the current time because this 18000 is relative time from current time for opcode PCM_OP_CUST_MODIFY_CUSTOMER.
AIA 2.4 and 7.4 PS3 JCA Adapter is used.
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