APPLSYSPUB is the database schema. it is the first schema that is used in any connection in Oracle apps. APPLSYSPUB default password is PUB. It is not an application user and thus you cannot find that in the FND_USER table in the Oracle database of Oracle applications
Oracle forms, and OACORE all connect to it first then this schema has sufficient privileges to authenticate the username and password and change the connection to the APPS schema. This is a very important schema and Oracle recommended not to use mixed characters for its password.
The APPLSYSPUB account should have only these grants –
INSERT ON FND_UNSUCCESSFUL_LOGINS
INSERT ON FND_SESSIONS
EXECUTE ON FND_DISCONNECTED
EXECUTE ON FND_MESSAGE
EXECUTE ON FND_PUB_MESSAGE
EXECUTE ON FND_SECURITY_PKG
EXECUTE ON FND_SIGNON
EXECUTE ON FND_WEBFILEPUB
SELECT ON FND_APPLICATION
SELECT ON FND_APPLICATION_TL
SELECT ON FND_APPLICATION_VL
SELECT ON FND_LANGUAGES_TL
SELECT ON FND_LANGUAGES_VL
SELECT ON FND_LOOKUPS
SELECT ON FND_PRODUCT_GROUPS
SELECT ON FND_PRODUCT_INSTALLATIONS
These permissions are set in –
/admin/sql/afpub.sql
To check permissions
SELECT * FROM sys.dba_tab_privs
where grantee = 'APPLSYSPUB';
How to change the password for APPLSYSPUB in R12/R12.1
First, stop the EBS services on all the nodes, Change the password using the FNDCPASS utility and then update the context file with it and run autoconfig
FNDCPASS apps/apps 0 Y system/manager ORACLE APPLSYSPUB <passwd>
In the CONTEXT file, we need to locate the autoconfig variable “s_gwyuid_pass” and set
it to the new password, then run AutoConfig in each application node.
Once the autoconfig is completed, please verify the password in $CONTEXT_FILE, $FND_SECURE/*dbc and then start the EBS services
How to change the password for APPLSYSPUB in R12.2
First, stop the EBS services on all the nodes, Change the password using the FNDCPASS utility on the run filesystem and then update the context file with it and run autoconfig. It is advisable to keep the password in Upper case only
FNDCPASS apps/apps 0 Y system/manager ORACLE APPLSYSPUB <passwd>
In the CONTEXT file, we need to locate the autoconfig variable “s_gwyuid_pass” and “s_gwyuid” and set
it to the new password, then run AutoConfig in each application node.
Once the autoconfig is completed, please verify the password in $CONTEXT_FILE, $FND_SECURE/*dbc.
Now disable the logon trigger in the Database
alter trigger ebs_logon disable;
Source Patch filesystem, change password in Context file and run the Autoconfig on all the nodes
Now enable the trigger in the Database
alter trigger ebs_logon enable;
Now source the run filesystem and start the EBS services
I hope you like the post on the APPLSYSPUB schema in Oracle EBS. This is an important schema and should not be disabled. If it gets disabled, Oracle EBS will stop working
Related Articles
Guest User password in 11i/R12
How to resolve the ORA-01017: invalid username/password; logon denied
Changing the Oracle WebLogic Server Administration User Password in R12.2
Steps to change Admin Password which is lost or forgetten of an EBS WebLogic Domain R12.2