Skip to main content

Posts

Showing posts with the label APPS

Oracle E-Business Suite Schema Type

Oracle E-Business Suite Schema: Type 1 . Schemas that exist in every Oracle database - SYS, SYSTEM. Type 2 . A small set of critical core schemas used by shared components of Oracle E-Business Suite - APPLSYSPUB, APPLSYS, APPS, APPS_NE. APPYSYSPUB schema: It is public account , and has only Read-Only privileges on a few tables and views for signing on to Applications . The password for this account can be seen from the OS in the environment variable or logical GWYUID. It was pointless to change it before the security patch that allowed the APPLSYSPUB password to be encrypted. Warning: The APPLSYSPUB password is unique in that it must be maintained as an uppercase password . This means that if you opt to change the APPLSYSPUB password in Oracle Database 11g, you must enter the new password in all uppercase to preserve system functionality. Oracle recommend that the APPLSYSPUB password should be changed on all Release 12.x systems , using either AFPASSWD or FNDCPASS. Au...