When is this user created during database creation?
yes, during database creation.
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."
look sql.bsq and you can see a line
create user system identified by manager