Sunday, December 30, 2012

Changing Password Oracle Applications (EBS)





SYSADMIN:
--------

- nav: Security:User:Define

- Query the user info

Press F11 (Query mode)

Enter user name

Press Cntrl+F11 ( To execute the query)

- Enter new password in password field ( 2 times)

- Cntrl+S to save

USER:
----

- Open any form

- Go to menu bar

Edit-> Preferences->Change Password

- Enter old password & enter new password(twice)

EBS File System(12.1.3): Oracle apps (EBS )


EBS R12
 |
-------------------------------------------------
| |
db-tier   apps-tier
|(base: /u01) |(base: /u02)
db -----------------
| | |
| apps      inst
  --------------- | |
  | | ----------------      apps
tech_st apps_st | | |
  | |    apps_st    tech_st   <context_name>
11.1.0 data | | |
  | | ---------------- |     ($INST_TOP)
  |      (C,R,D files) | | |
  | appl      comn |
($ORACLE_HOME)    ($APPL_TOP)  ($COMMON_TOP) |
  | |
  | |
  | |
  | |
  | |
  | -----------------
  | | |
  |    10.1.2     10.1.3
 ---------------- ($ORACLE_HOME) ($IAS_ORACLE_HOME)
 |              |
<CN>.env appsutil
(db-tier |
env file) |
|
----------------
| |
scripts <CN>.xml
|    (db-tier context file)
<CN>
|
 (db-tier control scripts)



*********************************************************************************
- APPL_TOP: Is the top directory for all the applications.

 It contains Appliction products files & directories.

  ex: gl, ap, ar, po, fnd, ad, au ......



APPL_TOP
  |
--------------------------------------------------------------------------
| | |   | | | | |
admin gl ap   au fnd po   <CN>.env   APPS<CN>.env ..
| | |   | | | | |
     <PROD> 12.0.0  12.0.0    12.0.0    12.0.0  12.0.0  (APPL_TOP (Consolidated
|  ($GL_TOP)($AP_TOP) ($AU_TOP) ($FND_TOP) ($PO_TOP) env file) env file)
  -----------   |
  |    |   |
 log  out   |
  |
(AD utilites   |
log & out files)   |
  |
--------------------------------------------------
| | | |
forms resources plsql bin ....
| | | |
    <lang> (.pll & .plx   (.pll used    (AU module executables)
| used by forms)    by reports)
(.fmbs of all
the modules)




$FND_TOP
  |
------------------------------------------------------------------
| | | | | | |
forms reports bin sql mesg log out ..
| |---- | | |
    <lang>     <lang>  | (FND utilites)(.sql files |
| |    |    of AOL)  <lang>.msb
(.fmx of AOL) (.rdf of AOL)|
    |  
(.prt files)





$GL_TOP
  |
---------------------------------------------------------------
| | | | | | | ...
forms reports bin sql mesg log out
| | | | |
<lang> <lang> (GL executables) |   <lang>.msb
| | |   (Message file
(.fmx of GL)      (.rdf of GL) (.sql files  of GL)
of GL)



*********************************************************************************
 COMMON_TOP: It contains common html files & java files.



$COMMON_TOP
   |
---------------------------------
| |
webapps java
| |
oacore classes
|    ($JAVA_TOP)
html($OA_HTML)
|
bin
|
appsweb.cfg

(Form server config file)


*********************************************************************************
INST_TOP: Instance_TOP contains log & out files, configuration files, apps-tier control scripts.


$INST_TOP
   |
---------------------------------------------------------------------------------
| | | |
admin appl logs ora($ORA_CONFIG_HOME)
| | |($LOG_HOME) |
scripts | | --------------------
| |   --------------- |   |
(apps-tier control scripts) |   |  | 10.1.2        10.1.3
|  appl  ora |   |
($ADMIN_SCRIPTS_HOME) -----------------   |  | -----------------     -
| |  conc ---------   | |     | | |
admin fnd   | | | <CN>.env    network  CN>.env Apache opmn
| | ---------    10.1.2   10.1.3 | | |
   <CN>.xml         12.0.0 | | | |     admin Apache conf
(apps-tier context file) | log out  network | | | |
    secure | | | |  (listener   conf opmn.xml
($CONTEXT_FILE) | | |apps_prod.log | & |   (opmn/OC4J config file)
  <SID>.dbc | | |    tns)      httpd.conf
| |(App listener | (Apache Server
       ($FND_SECURE) | | logfile) | ($TNS_ADMIN) files)
| | |
| | -----------------
       ($APPLCSF/$APPLLOG) | | |
| Apache opmn
($APPLCSF/$APPLOUT) | |
     error_log..   opmn.log
   (Conc Managers/Requests log & out files)  access_log..
|
   (Apache server logfiles)

Oracle Apps (EBS) User Management


> User Management:
-------------------

- Create application user & assign responsibility

- Modify the user info

- Changing Password of application users

- Creating copy of "System Administrator" resp

- Excluding menus & functions

- Monitoring application users.

-----------------------------------------------------------------------------------------

- Create application user & assign responsibility:
-------------------------------------------------

- Login as sysadmin

- select "System Administrator" resp

- nav: Security:User:Define



- Modify the user info:
----------------------

- nav: Security:User:Define

- Query the user info

Press F11 (Query mode)

Enter user name

Press Cntrl+F11 ( To execute the query)