Tuesday 22 July 2014

How to freeze EBS system date

EBS application frozen steps:


1.Stop application services

2.Login to database server as sys user with sysdba privileges and fire below commands ,
SQL>select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual; (to check current system date)

SQL>ALTER SYSTEM SET FIXED_DATE = '20014-05-01';

SQL>startup force

SQL>select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual; (to check whether system date being constant)

3.Start all EBS application services and check application for system date.

No comments:

Post a Comment