Important Schemas In Ebs
Suppose when we are Creating/Installing Apps. 3
important schemas are created in Database. They are :
1)
APPLSYSPUB/PUB
2)
APPLSYS/APPS
3)
APPS/APPS
Note: passwords for applsys and apps are same
password, bydefault password is apps.
4)
APPS_MRC : password is same as apps. It exits only
in 11.5.9. It doesn't exists in 11.5.10.
There are also some more schemas created for each
product. The passwords for all these schemas are same as username.
Note: We never use to change applications users
passwords, by using ' alter user' command. There is a command in applications.
It is FNDCPASS.
APPLSYSPUB
It is used to
initial signon of appliations users. It contains fnd synonyms like fnd_session,
fnd_signon etc. It conations only 18 synonyms.
APPLSYS
This is apps
dictionary which contains total application users responsibilities, menus. It
contains fnd tables, some of them are:
fnd_user
fnd_menus
fnd_nodes
fnd_respobsibility
fnd_tables
fnd_resp_functions etc.
APPS
It is universal schema. It contains synonyms, views
on all product tables and also it will have object grants with grant option on
all objects.
Note:- Every connection that is coming from
applications finally will be connected as apps only, we wil get this
information from v$session.
Important Tables
fnd_user
fnd_oracle_user_id
fnd_concurrent_requests
fnd_concurrent_programs_tr
fnd_concurrent_programs
fnd_responsibility
fnd_profile_option_values
fnd_menus
fnd_nodes
fnd_product_installations
fnd_application
fnd_product_groups
fnd_install_processes
ad_deferred_jobs
ad_applied_patches
ad_bugs
fnd_user
fnd_oracle_user_id
fnd_concurrent_requests
fnd_concurrent_programs_tr
fnd_concurrent_programs
fnd_responsibility
fnd_profile_option_values
fnd_menus
fnd_nodes
fnd_product_installations
fnd_application
fnd_product_groups
fnd_install_processes
ad_deferred_jobs
ad_applied_patches
ad_bugs
Concurrent
Manager
FND_CONCURRENT_QUEUES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_QUEUE_SIZE
FND
FND_APPL_TOPS
FND_LOGINS
FND_USER
FND_DM_NODES
FND_TNS_ALIASES
FND_NODES
FND_RESPONSIBILITY
FND_DATABASES
FND_UNSUCCESSFUL_LOGINS
FND_LANGUAGES
FND_APPLICATION
FND_PROFILE_OPTION_VALUES
AD
/ Patches
AD_APPLIED_PATCHES
AD_PATCH_DRIVERS
AD_BUGS
AD_INSTALL_PROCESSES
AD_SESSIONS
AD_APPL_TOPS
No comments:
Post a Comment