How To Create User in Oracle Apps:

Navigation:

Go to System Administrator->Security->User->Define

Save.

Assign the  required responsibilities to user.
Save.

Query to check  from backend:
SELECT *
FROM FND_USER
WHERE USER_NAME LIKE 'KILL%'