Technology Patch Requirements for Extended Support of Oracle E-Business Suite Release 11.5.10

Oracle E-Business Suite Release 11.5.10 moved into Extended Support on December 1, 2010. To be eligible for Extended Support, a Release 11.5.10 system must meet defined minimum baseline patch requirements both for its core components (such as the database) and for the applications products in use. This document lists these minimum baseline patch requirements, and also describes additional considerations as on Aug 02, 2011.
 
Minimum Baseline Patch Requirements (Technology)
 
This section lists the minimum baseline patch requirements for Extended Support on Oracle E-Business Suite Release 11.5.10
 
1. EBS Version:
 
For a given product (Fully Installed, Pseudo as well as Shared), the code levels must be the equivalent of 11.5.10 CU2 plus any additional patches listed in Section 2 below (For more information on how to verify current code levels, see My Oracle Support Knowledge
 
Ref Mos # 316366.1 & 316365.1
 
2. ATG Rollup Level:
 
ATG Rollup Patchset 6 (11i.ATG_PF.H.delta.6, Patch 5903765)
 
Ref Mos # 444524.1
 
3. Database Version:
 
10.2.0.4 or 11.1.0.7
 
Ref Mos # 362203.1 & 452783.1 
 

Oracle EBS API to change user password and prompt to change their password the first attempt to login to the applications

The following API can be used to change the Ebs user password and prompt to change the same at the first logon,

begin
fnd_user_pkg.updateuser(
x_user_name => ‘204020779’
, x_owner => ‘CUST’
, x_unencrypted_password => ‘change123’,
x_password_date => to_date(‘2′,’J’)
);
commit;
end;

If we don’t want to force the user to change the password, then we can remove the x_password_date from the api.

The standard FND_USER_PKG does this:
decode(x_password_date, fnd_user_pkg.null_date, null,null,
u.password_date, x_password_date)
fnd_user_pkg.null_date is defined as to_date(‘2′,’J’),
which is 02-JAN-4712.

Hence, this decode says:

1. If the password_date parm = 02-JAN-4712, then set password date = null.
2. If the password_date is null, then set password date = existing password date (in effect does nothing)
3. Else use the existing password date (in effect does nothing).