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