JCA Adapter is Always Sending 1970-01-01 for NULL Timestamp Attribute (Doc ID 2124623.1)

Last updated on APRIL 20, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

On : 7.5.0.0.0 version, Webservices Mgr & JCA Adaptor

JCA adapter is always sending 1970-01-01 for NULL timestamp attribute.

We have configured the JCA for ZeroEpochAsNull=true, but all the NULL timestamp attributes are translated as

<PURCHASE_START_T>1970-01-01T00:00:00Z even though the FLIST response has null timestamp pointer like

  4 PIN_FLD_PURCHASE_START_T TSTAMP [0] (0)

According to this documentation link  http://docs.oracle.com/cd/E16754_01/doc.75/e16708/jca_resource_adapter_config.htm#BRMJC184 :

-------
From the WebLogic Server Administration Console or the Oracle Application Server ASC page, go to the resource adapter home page and create connection factories.

Set the ZeroEpochAsNull connection factory field to either of the following values:

true sends the date field value as NULL to represent an infinite start or end date.

false sends the date field value as the start of the epoch time. This is the default.
 ---------

Solution

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