Payment Tool - Date Filled Manually Is Converted With One Hour Less On Submission

(Doc ID 2301837.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

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

Symptoms

On : 7.4.0.14.0 version, Payment Tool

New payment batch created in PaymentTool using a payment type having two date fields. One of the fields is out of the box one (PIN_FLD_POSTED_T), the other is a custom field (XXX_FLD_PLAN_CREDIT_T).

These two fields are populated in PaymentTool as bellow:
PIN_FLD_POSTED_T = 10/14/2016
XXX_FLD_PLAN_CREDIT_T = 10/17/2016

Format of the date is: MM/DD/YYYY

In 2016, for Brasil, Dayligth Saving Time has started on "Sunday, 16 October,00:00" when the time difference compared with GMT has changed from GMT-3 to GMT-2.

So the two dates should be converted differently to GMT times, by adding 3 respectively 2 hours, as below.

 

Changes

 Issue was reproduced internally by following the below steps:

1. created new custom field in Cash payment type as per this KM note: Adding New Custom Columns In Payment Tool (Doc ID 778874.1)
2. set local PC (where PaymentTool is running) timezone to UTC-3=Brasilia timezone
3. created new account ; First billing cycle 17-Jul-2017 to 17-Aug-2017
4. moved pvt to 17-Aug-2017 and generated one bill B1-1
5. create a payment with 2017 dates for B1-1
6. moved pvt to 17-Sep-2017 and created B1-2
7. sent a payment with 2016 dates:
   Receipt date=14/10/2016
   David Test=17/10/2016  <-- this is the custom field

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