Thursday, 3 January 2013

R12 backend scripts

Maintenance Mode:

SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')
--------------------------------------------------------------------------------
NORMAL

SQL> @/u02/appldev/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql
Enter value for 1: ENABLE
Enter value for 1: ENABLE

PL/SQL procedure successfully completed.

SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')
--------------------------------------------------------------------------------
MAINT

No comments:

Post a Comment