How to check OIM build version and schema version of OIM 11g R1, 11gR2,11gR2 PS1, and 11gR2 PS2

To check the OIM build version run the below query in database

SELECT XSD_VALUE FROM XSD WHERE XSD_CODE='XL_BUILD_NUMBER';

To check the OIM Schema version run the below query in database

SELECT OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY;

Thank you
Arihant Baid