Question

7
Replies
229
Views
RohithReddyJ Member since 2011 10 posts
Wells Fargo
Posted: 3 years ago
Last activity: 3 years 3 months ago
Closed
Solved

InCorrect Value for pxCreateDateTime for Oracle DB

Hello Team,

We are using oracle 12 version as DB for our pega environment, we identified that pxCreateDateTime is not holding milli seconds as the column type in DB is DATE(if the type is TIMESTAMP it holds full time stamp).

In our application, we have requirement to send complete work object created time stamp with milli seconds to 3rd party system along with assignmentID, but due this we are unable to send milli seconds part.

Can you please help by letting me know whether pega has any plan to update the column type for oracle DB in future. Mean time, can you also please help me by suggesting work around.

Thanks,

Rohith

Data Integration SR Exists
Moderation Team has archived post
Share this page LinkedIn