Job Console Entries...

Job console data is stored in table “HPS_JOB_STATUS” and when planning is restarted this data is cleared. After some research I finally found the details from here.

There is a property which can be set to never clear / delete these details or clear / delete periodically.

Property Name: JOB_STATUS_MAX_AGE

Value: 60000 (1000*60 for 1 minute – this is value in milliseconds)

Value: -1 (setting -1 will never clear / delete the data)

To set the property:

1.       Select Administration, then Application, then Properties.

2.       Select Application Properties to set properties and values for a Planning application.

3.       Add the property by clicking Add, entering the property in the blank row, and entering a value in Property Value

Reference / More Info:

1. http://docs.oracle.com/cd/E17236_01/epm.1112/hp_admin/frameset.htm?properts.html

2. https://community.oracle.com/thread/2516103?tstart=0