Fusion Middleware (FMW) products like Oracle SOA, WebCenter, Identity Management (OIM, OAM) etc , you must create schema using Repository Creation Utility (RCU). This schema version and status in maintained in registry table ( schema_version_registry ) under sys schema.
You can use the below method to find schema version of fusion middleware components from schema_version_registry
Login to the database with sys user follow the below steps :
1. Login to host where database is running
2. Set environment variable
3. Connect to database as sysdba
sqlplus “/as sysdba”
SQL>Select * from schema_version_registry;
SQL>select COMP_ID, COMP_NAME, version, status from schema_version_registry;
Leave a comment if you need more information or need any other information.