Here in this article, we will check how to check datafiles in the Oracle database, how to check datafile size in oracle,How to check datafile location in Oracle, how to check datafiles in tablespace How to check datafiles in Oracle/How to check datafile location in Oracle select file_name, bytes/1024/1024 from dba_data_files ; With CDB Databases, […]
how to check ebs version : Apache, Java, FMW, WebLogic , forms
We are often asked how to check ebs version, How to find the EBS R12 components Version. This includes all R12.0/R12.1 and R12.2. I will try to explain how to find out that with various EBS R12 versions with commands and reports. Apache Version/how to check oracle application server version in r12 We can log […]
Basic element(Application) of Oracle EBS
Here in this post, I am trying to explain one of the Basic elements i.e Applications of the Oracle EBS. This also includes Query to get application name in oracle apps, query to find application id in oracle apps/Query to get application short name in oracle apps, How to check installed modules in Oracle apps […]
Function in Oracle apps
Function Form Function: A function that invokes an Oracle Forms form Sub Function: A non-form function is a securable subset of forms functionality, which means a function executed from within a form One can navigate to a form function ( form) using the navigate window A sub-function can only be run from a form FND_FORM_FUNCTIONS […]
Menu in Oracle apps
Menu in Oracle apps It is a logical or hierarchical listing of functions (forms) so that the user can easily navigate through the forms once he is in responsibility. A menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator. Each responsibility has a menu assigned to it. Every […]
Query to check character set in oracle
In this post, we will check about Query to check character set in oracle, What is Database Character set What is Database Character set? Oracle Database uses character sets for the following: Data stored in SQL character data types (CHAR, VARCHAR2, CLOB, and LONG). Identifiers include table names, column names, and PL/SQL variables. Stored SQL […]
