Category: ORACLE APPLICATIONS

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

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

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.

If webadi look and feel seems distorted in 11i/R12 then you can check below profile option

In our EBS R12 instance we have seen forms process consuming high CPU resources causing other applications processes to run slow. Our EBS R12 application…

We have seen this error couple of times in the Concurrent manager Administer screen in our 11i/R12 EBS instances.

Below steps have proven helpful in sorting out this issue:

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***