Oracle Error ORA-24014: invalid value string, RETENTION_TIME should be FOREVER or non-negative

Oracle Error Message

ORA-24014: invalid value string, RETENTION_TIME should be FOREVER or non-negative

Reason for the Error

Queue retention was specified, but the retention time was specified to be less than zero.

Solution

Specify the retention time to be non-negative or FOREVER. Alternately don’t specify retention.