After 7.5ps15 Upgrade,LAST_BILL_T Is Not Getting Aligned With The ACTG_LAST_T,when The Bill Is Suppressed (Doc ID 2166111.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.15.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.5.0.15.0 version, Core Billing

ACTUAL BEHAVIOR
---------------

Prior to 7.5PS15 upgrade , though the bill was suppressed the LAST_BILL_T would be aligned with the ACTG_LAST_T but now ,
the LAST_BILL_T is not getting changed until the bill is finalized(not suppressed).

On 7.5PS15 upgrade:
0 PIN_FLD_LAST_BILL_T TSTAMP [0] (1466028000) Thu Jun 16 00:00:00 2016
0 PIN_FLD_NEXT_BILL_T TSTAMP [0] (1470002400) Mon Aug 01 00:00:00 2016
0 PIN_FLD_ACTG_LAST_T TSTAMP [0] (1467324000) Fri Jul 01 00:00:00 2016
0 PIN_FLD_ACTG_NEXT_T TSTAMP [0] (1470002400) Mon Aug 01 00:00:00 2016

EXPECTED BEHAVIOR
-----------------------

On 7.5PS8 upgrade:
0 PIN_FLD_LAST_BILL_T TSTAMP [0] (1467324000) Fri Jul 01 00:00:00 2016
0 PIN_FLD_NEXT_BILL_T TSTAMP [0] (1470002400) Mon Aug 01 00:00:00 2016
0 PIN_FLD_ACTG_LAST_T TSTAMP [0] (1467324000) Fri Jul 01 00:00:00 2016
0 PIN_FLD_ACTG_NEXT_T TSTAMP [0] (1470002400) Mon Aug 01 00:00:00 2016

On 7.5PS8 LAST_BILL_T is aligned with the ACTG_LAST_T even the bill is suppressed

same behavior is expected in 7.5PS15


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. 14 June 2016: Create an account.
2. 01 July 2016: Do billrun for this account. bill would be suppressed. Review Billinfo_t values i.e, PIN_FLD_LAST_BILL_T,PIN_FLD_ACTG_LAST_T



Changes

New implementation was done in 7.5PS15 , according to that PIN_FLD_LAST_BILL_T field is changed only when bill is being finalized.
Previously in case of bill suppression it use to set the field PIN_FLD_LAST_BILL_T to PIN_FLD_END_T.

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