APPS DBA

ERROR Unable To Create New Legal Entities – ORA-06512: at “CTXSYS.DRVDML” , ORA-06512: at “HR.DR$HR_LOCATIONS_N1TC   SOLUTION Disable the trigger HR.DR$HR_LOCATIONS_N1TC through APPS user. SQL>ALTER TRIGGER HR.DR$HR_LOCATIONS_N1TC DISABLE; Reference Note:  Doc ID …

Scripts Location In Oracle Application R12 Database Tier Scripts Database Scripts are located in Database_Install_Dir/db/tech_st/10.2.0/appsutil/scripts/$CONTEXT_NAME where CONTEXT_NAME is of format SID_HOSTNAME For Database Use script addbctl.sh For Database Listener Use …

ERROR Unable to determine SMTP server to use: set FND_SMTP_HOST Outpost Processor has encountered the below error. This error can be found in OPP logs: —————————————- [GC 14000K->8905K(20284K), 0.0074280 secs] ProcessorException: Unable …

ERROR ” An error occurred while attempting to establish an Applications File Server connection. There may be a network configuration problem, or the TNS listener may not be running on ” Solutions …

Forms Servlet mode to Socket mode conversion on Release 12 Apps Run the following command to enable Forms Socket Mode on Forms/web nodes (Place correct context file name and port …

ERROR “ORA-20001:FND_CANT_INSERT_USER_ROLE has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT”     SOLUTION Run concurrent program “Workflow Directory Services User/Role Validation” After Request completed normal and this, assign the responsibility Now to rectify …

ERROR Check the alerts.log file you will get the below error:

ERROR BI Publisher (formerly XML Publisher) Requests Are Failing With Error “OPP Error Oracle.apps.xdo.XDOException: Error Creating Lock File

ERROR While Running Supplier Payment History in Oracle E-Business Suite R12, we are getting following error.

How many users are connected to Oracle Applications.