If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

changing the oracle system date for testing applications

Hopefully you guys can help me out

im am currently i am in the process of testing an oracle database application in particular Oracle HR suite.
To test the oracle HR database we will be cutting test data from the live production system. however been told by resident oracle experts that there might be issues in cutting the production data for testing purposes ( ie we have a exact instance of oracle application in test environment as in production)
the following example was given as the issues we might face

(i) If we take a cut of the oracle production data on 5th Oct 2007 and start testing in Jan 2007, the oracle processes that need to run for all the records for 4 weeks with dates before the system date , hence these processes wouldnt run because processes/functions in oracle are system date sensitive

as further explained below

the system date is in Jan 2007 and the data cut is from Oct 5 2007. so will need to alter the system date, such that oracle thinks it is in Novemeber not Jan 2007. Hence would therefore pick up data records from Oct 2007 and populate our test environment instance of the application

guys im not an oracle expert but doing this sounds complicated is there a easy and fail safe method to overcome this issue somehow.