Skip to main content

Posts

Showing posts with the label SQL Statements

Oracle E-Business Suite Daily SQL Statements

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...