My Oracle Support Banner

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

Last updated on AUGUST 20, 2019

Applies to:

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


On : 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


According to this documentation link :

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.