Interesting enhancements in 12.0.6 – R12.ATG_PF.A.DELTA.6

Posted on December 2, 2008. Filed under: Apps Technology Stack, DBA/Admin Tips, R12, Technology | Tags: , , |

Oracle Applications Technology Stack Release Update Pack 6 (R12.ATG_PF.A.DELTA.6)

Autoconfig has two new options

1. Parallel Mode
2. Profile Mode

Parallel Mode

This mode enables autoconfig to be executed parallel across all mid-tiers. Oh man, i love this feature … it really helps when you have multiple mid-tiers.

Just add -parallel to your normal adconfig command

Profile Mode

This option provides a drill down HTML report of the autoconfig run.

Just add -profile to your normal adconfig command

For more information on above options refer to Metalink Note 742110.1

cheers,
OraclePitStop

Read Full Post | Make a Comment ( 1 so far )

Script to list profile option values for a specific user

Posted on June 26, 2008. Filed under: DBA/Admin Tips, R12, Scripts | Tags: , |

col profile_option_name for a35
col profile_option_value for a30
col profile_option_id for 9999

set lines 500

select
 p.profile_option_name,
 substr(decode(v.level_id,10001,’Site’,10002,’Application’,
 10003,’Repsonsibiltiy’,10004,’User’,10005,’Server’,10006,’Organisation’),1,15) profile_level,
 substr(fu.user_name,1,12) user_name,
 v.level_value,
 v.profile_option_value
from
 fnd_profile_options p,
 fnd_profile_option_values v,
 fnd_user fu
where
 p.profile_option_id = v.profile_option_id
and  v.level_value = fu.user_id
and fu.user_name like upper(‘&USER_NAME’)
/

Read Full Post | Make a Comment ( None so far )

Liked it here?
Why not try sites on the blogroll...