Skip to content

Category: Apps Troubleshoot

Oracle EBS R12 Appslogin showing http 404

One of our EBS R12 was inaccessible and was throwing generic http-404 erorr for the login page. On the application side adopmnctl was showing status ACTIVE for all the required procesees.

Simple HTML file like http://<server_name>:<port>/OA_HTML/test.html was also not opening means it was Apache issue or Oacore issue since definition of OA_HTML in html link is given by OACORE.

Error message in the Browser was like below:

Not Found

The requested URL /OA_HTML/test.html was not found on this server.

In one of the Apache server log we were able to see that it is trying to find the file under portal directory which is not the correct place

    </EXEC_CONTEXT_ID>
  </CORRELATION_DATA>
  <PAYLOAD>
    <MSG_TEXT>File does not exist: /fs01/<SID>/inst/apps/<CONTEXT_NAME>/portal/OA_HTML/test.html</MSG_TEXT>
  </PAYLOAD>
</MESSAGE>

[Post Views: 238]

Leave a Comment

Java Classpath missing in Oracle Apps 11i

If you need to add any new classpath to the $CLASSPATH variable in Oracle Apps 11i please see below example:

VERIFY:

$ echo $CLASSPATH
/fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/jre/lib/rt.jar:/fh02/DBNAME/oraapps/common/util/
java/1.6/jdk1.6.0_45/lib/dt.jar:/fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/lib/tools.jar:
/fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/jre/lib/charsets.jar:/fh02/DBNAME/oraapps/common/
java/appsborg2.zip:/fh02/DBNAME/oraapps/8.0.6/forms60/java:/fh02/DBNAME/oraapps/common/java


$ echo $CONTEXT_FILE
/fh02/DBNAME/oraapps/11iApp/admin/DBNAME_SERVER.xml

[Post Views: 86]

Leave a Comment

REP-54002: file : Cache item is no longer valid

We have observed many requests of couple of concurrent prorgams in our R12 instance go into error with below kind of message:

Enter Password:
MSG-01001: Entering AfterPForm
MSG-01001: Starting to retrive former request parameter by request ID
MSG-01001: Exiting AfterPForm
MSG-01010: :S_BATCH_COUNT = 0
REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
REP-54002: file : Cache item is no longer valid

[Post Views: 149]

Leave a Comment

FND_NO_DATABASE_CONNECTION in Oracle EBS R12

R12: Login was Failing Intermittently With Error “oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION”

Or getting below error when trying to access EB R12 login page.

Error Page  
You have encountered an unexpected error. Please contact the System Administrator for assistance.

[Post Views: 74]

Leave a Comment

ORA-27300: OS system dependent operation:invalid_egid

In one of our EBS database we faced issue when connecting to SQLPLUS

Error message which was coming up was as below:

[oracle@dbserver bin]$ sqlplus apps/apps

Copyright (c) 1982, 2011, Oracle. All rights reserved.

ERROR:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 11 (asmadmin), current egid =
17 (oinstall)

[Post Views: 110]

Leave a Comment

Gather Schema Statistics fails with Ora-20001 errors in Oracle EBS

“Gather Schema Statistics” program reported following errors in request log files :
Error #1: ERROR: While GATHER_TABLE_STATS: 
object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** 
Error #2: ERROR: While GATHER_TABLE_STATS: 
object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** 
Error #3: ERROR: While GATHER_TABLE_STATS: 
object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #4: ERROR: While GATHER_TABLE_STATS:  object_name=FII.FII_FIN_ITEM_HIERARCHIES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***

[Post Views: 64]

Leave a Comment
error: Alert: Content is protected !!