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>