Monday, November 23, 2015

Important Schemas In Ebs

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

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