oracle ebs的两个schema:apps applsys,apps schema:本身不拥有任何表,对于每一个独立schema下的表数据,在apps schema下要同
apps schema:本身不拥有任何表,对于每一个独立schema下的表数据,在apps schema下要同样有一个synonym存在。apps的默认密码为“apps”.
关于apps schema可以参见:[翻]why call it apps and not oracle erp ?
applsys schema:包含所有系统管理(administarative)相关的表,,比如workflow,ad,fnd...,默认密码和apps一样,也为“apps”
refer:https://forums.oracle.com/forums/thread.jspa?threadid=651979
applsys和apps的密码必须同时修改,保持一致。必须先修改applsys,再修改apps。为了防止不恰当的修改造成用户无法登陆系统,在更改前请备份fnd_oracle_id和fnd_user表。
note:160337.1:how to manually change the apps, applsys and applsyspub passwords in oracle applications
note:159244.1:how to use fndcpass to change the oracle users, apps, applsys and application module passwords (inv, ar, ap, etc.) for applications 11.5 in unix