I am not sure what the Enterprise Manager Console is. CHAP IT does not need this password or any of the other passwords; CHAP IT only manages passwords for MICROs application configuration access (also known as SUPERVISOR access).
The Hotel is required to have the passwords for the Oracle Database & any others (for example: SYS, OXI, SQLPlus, etc...).