AWS / Azure / GCP Cloud | Database | Data Analytics | LakeHouse | Machine Learning | Shrenik Parekh

Oracle E-Business Suite Daily SQL: Current version: SELECT RELEASE_NAME FROM APPS.FND_PRODUCT_GROUPS; Find out application server information from database server:   column name format a20 SELECT NAME, NODE_ID, SERVER_TYPE FROM APPS.FND_APP_SERVERS; NAME                                     NODE_ID       SERVER_TYPE --------------------                      ----------          ------------------------------ <hostname>_EBSDEV_APPS      10113            APPS <hostname>_EBSDEV_DB          10112            DB Find out Oracle E-Business Suite Shared products: set pagesize 0 column applicaiton_name format a500 column status format a200 SELECT at.application_name || '      ' ||    decode(pi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Unknown') STATUS    FROM APPLSYS.fnd_product_installations pi        ,APPLSYS.fnd_application a        ,APPLSYS.fnd_application_tl at   WHERE pi.application_id = a.application_

Oracle E-Business Suite Application Tables: APPLSYS FND_APPLICATION APPLSYS FND_APP_SERVERS_U2 APPLSYS FND_APPLICATION_S APPLSYS FND_APPLICATION_SERVERS APPLSYS FND_APPLICATION_SERVERS# APPLSYS FND_APPLICATION_SERVERS_U1 APPLSYS FND_APPLICATION_SERVERS_U2 APPLSYS FND_APPLICATION_TL APPLSYS FND_APPLICATION_TL# APPLSYS FND_APPLICATION_TL_U1 APPLSYS FND_APPLICATION_TL_U2 APPLSYS FND_APPLICATION_U1 APPLSYS FND_APPLICATION_U3 APPLSYS FND_APPL_SESSIONS APPLSYS FND_APPL_SESSIONS# APPLSYS FND_APPL_SESSIONS_N1 APPLSYS FND_APPL_SESSIONS_N2 APPLSYS FND_APPL_TOPS APPLSYS FND_APPL_TOPS# APPLSYS FND_APPL_TOPS_U1 APPLSYS FND_APPL_TOPS_U2 APPLSYS FND_APPS_SYSTEM APPLSYS FND_APPS_SYSTEM# APPLSYS FND_APPS_SYSTEM_U1 APPLSYS FND_APPS_SYSTEM_U2 APPLSYS FND_APP_SERVERS APPLSYS FND_APP_SERVERS# APPLSYS FND_APP_SERVERS_U1 APPLSYS FND_APPLICATION# APPLSYSPUB FND_APPLICATION APPLSYSPUB FND_APPLICATION_TL APPLSYSPUB FND_APPLICATION_VL APPS FND_APPFLDR APPS FND_APPLICATION_TL= APPS FND_APPLET_LAUNCHER APPS FND_AP

Oracle E-Business Suite FND product tables: APPLSYS FND_PRODUCT_DEPENDENCIES APPLSYS FND_PRODUCT_DEPENDENCIES# APPLSYS FND_PRODUCT_INSTALLATIONS_PK APPLSYS FND_PRODUCT_INSTALLATIONS# APPLSYS FND_PRODUCT_INSTALLATIONS APPLSYS FND_PRODUCT_INIT_DEPENDENCY_U1 APPLSYS FND_PRODUCT_INIT_DEPENDENCY# APPLSYS FND_PRODUCT_INIT_DEPENDENCY APPLSYS FND_PRODUCT_INIT_CONDITION_U1 APPLSYS FND_PRODUCT_INIT_CONDITION# APPLSYS FND_PRODUCT_INIT_CONDITION APPLSYS FND_PRODUCT_INITIALIZATION_U1 APPLSYS FND_PRODUCT_INITIALIZATION# APPLSYS FND_PRODUCT_INITIALIZATION APPLSYS FND_PRODUCT_GROUPS# APPLSYS FND_PRODUCT_GROUPS APPLSYS FND_PRODUCT_DEPENDENCIES_U1 APPLSYSPUB FND_PRODUCT_GROUPS APPLSYSPUB FND_PRODUCT_INSTALLATIONS APPS FND_PRODUCT_INIT_DEPENDENCY APPS FND_PRODUCT_INIT_CONDITION= APPS FND_PRODUCT_INIT_CONDITION+ APPS FND_PRODUCT_INIT_CONDITION APPS FND_PRODUCT_INITIALIZATION_PKG APPS FND_PRODUCT_INITIALIZATION_PKG APPS FND_PRODUCT_INITIALIZATION= APPS FND_PRODUCT_INITIALIZATION+ APPS FND_PRODUCT_INITIALIZ