Tuesday 4 September 2012

Oracle Apps License Manager


There is a clause in deregistering part, If you have opted for Suite Licensing, you cannot deregister individual component.

"Selecting License E-Business Suite in the Product Licensing page opens the License E-Business Suite page. This page displays all products that will be registered when you choose to register the "E-Business Suite". Once the E-Business Suite is registered, individual products within the suite cannot be unregistered."

Oracle says, you cannot deregister a product, once registered.... "Once a product is registered, it has a check box that is grayed out and cannot be unregistered."

Reference:
Page 344, Oracle E-Business Suite System Administrator's Guide - Maintenance Release 12.1, Part No. E12894-04
Section: License Applications Products

Sunday 2 September 2012

How To Force All Applications Users To Change Their Password?


sqlplus -s apps/******* ${FND_TOP}/sql/AFCPEXPIRE.sql

 SET VERIFY OFF
 SET linesize 132

 WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
 WHENEVER OSERROR EXIT FAILURE ROLLBACK;
 REM dbdrv: none

/* ----------------------------------------------------------------------*/

 UPDATE FND_USER SET
   PASSWORD_DATE = NULL
 WHERE USER_ID <> 6;

 COMMIT;
 EXIT;

●● Alternately, you can submit "CP SQL*Plus Expire FND_USER Passwords" program to achive the same. This update all the user accounts except GUEST. Basically this program calls /u01/oracle/AGDEV1/apps/apps_st/appl/fnd/12.0.0/sql/AFCPEXPIRE.sql
●● This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire. It can also be run as a SQL*Plus concurrent program.  The user will need to create a new password upon the next login.
●● If you need you can modify the script as per your need