Skip to main content
Question

History log in IFS CLoud - data retention period

  • April 21, 2026
  • 0 replies
  • 11 views

Forum|alt.badge.img+7

Hello, 

We added history log on some tables, by default the retention period is 30 days. We would like to have a history log of 30*12*12 on this table, but how to achieve this ?

 

<?xml version="1.0"?>
<HISTORY_LOG_CONFIG_EXPORT>
<ENTITY_TYPE>
<LU_NAME>FndUser</LU_NAME>
<TABLE_NAME>FND_USER_TAB</TABLE_NAME>
<AUTOMATIC_CLEANUP>FALSE</AUTOMATIC_CLEANUP>
<DAYS_TO_KEEP>30</DAYS_TO_KEEP>
<ATTRIBUTE>
<ATTRIBUTE_ROW>
<NAME>ACTIVE</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
<ATTRIBUTE_ROW>
<NAME>CREATED</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
<ATTRIBUTE_ROW>
<NAME>DEFAULT_IDP</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
<ATTRIBUTE_ROW>
<NAME>DESCRIPTION</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
<ATTRIBUTE_ROW>
<NAME>IDENTITY</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
<ATTRIBUTE_ROW>
<NAME>LAST_MODIFIED</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
<ATTRIBUTE_ROW>
<NAME>VALID_FROM</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
<ATTRIBUTE_ROW>
<NAME>VALID_TO</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
<ATTRIBUTE_ROW>
<NAME>WEB_USER</NAME>
<LOG_INSERT>TRUE</LOG_INSERT>
<LOG_UPDATE>TRUE</LOG_UPDATE>
<LOG_DELETE>TRUE</LOG_DELETE>
</ATTRIBUTE_ROW>
</ATTRIBUTE>
</ENTITY_TYPE>
</HISTORY_LOG_CONFIG_EXPORT>