The database screen is not clear as to what values need to be entered when installing against Oracle. This doc seeks to clarify this.
In the field for "Repository Database" enter your Oracle SID
The CA Process Automation installer creates the schema in the default tablespace of the specified user.
In the following example the PAM schema it will be created under the PAMADMIN users default tablespace.