Is It Possible to Increase the Days_before_purge on SA_SYSTEM_OPTIONS Table to Four Characters?

(Doc ID 2415198.1)

Last updated on JUNE 29, 2018

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.

Goal

In order to accommodate 2555 days (7 Years), is it possible to increase the days_before_purge of SA_SYSTEM_OPTIONS table to four characters? Currently it is defined as three characters which is good for 999 days. 
 

Solution

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