Historian Archive/Purge for 12.5 Overlays PUBSHIST.PUBENDTIME, RCPSHIST.RCPENDTIME and TRNSHIST.TRNENDTIME (Doc ID 2228763.1)

Last updated on FEBRUARY 05, 2017

Applies to:

Oracle Documaker - Version 12.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.5 version, Enterprise Edition

End times changed for some history tables by archive. 

ERROR
-----------------------
Historian archive/purge for 12.5 overlays PUBSHIST.PUBENDTIME, RCPSHIST.RCPENDTIME and TRNSHIST.TRNENDTIME. 

The other history tables seem to retain the original end times.


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Run historian archive/purge for 12.5.
2. Checked that the PUBSHIST.PUBENDTIME, RCPSHIST.RCPENDTIME and TRNSHIST.TRNENDTIME are being overlaid by the date/time of the archive, in the database.


Changes

 

Cause

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