JCA Adapter is Always Sending 1970-01-01 for NULL Timestamp Attribute
(Doc ID 2124623.1)
Last updated on AUGUST 16, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 7.5.0]
Information in this document applies to any platform.
On : 18.104.22.168.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)
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.
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