JCA Adapter is Always Sending 1970-01-01 for NULL Timestamp Attribute
Last updated on APRIL 20, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 7.5.0]
Information in this document applies to any platform.
On : 188.8.131.52.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.
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