Can Not Login To The Applications: oracle.apps.fnd.framework.OAException: FND_NO_TRANSACTION_ID error

                     
            Error While login with username
in EBS:

Exception Details.
oracle.apps.fnd.framework.OAException: Could
not load application module

‘oracle.apps.fnd.sso.login.server.MainLoginPageAM’

## Detail 0 ##
oracle.apps.fnd.framework.OAException:
Application: FND, Message Name: FND_NO_TRANSACTION_ID.

at
oracle.apps.fnd.framework.webui.OAJSPHelper.getTransactionId(OAJSPHelper.java:350)

at
oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:133) 

at
oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1279) 

at
oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532) 

at
oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420) 

at _OA._jspService(_OA.java:216) 
at
com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) 

at
oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335) 

at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
Solution 1:

1. Check for any invalid objects in the database instance, by running for
instance the following sql statements as a DBA user in sqlplus:

select owner, object_type, count(*)
from dba_objects
where status=’INVALID’
group by owner, object_type;

select owner, object_name
from dba_objects
where status=’INVALID’
order by owner;

 3. Check for tablespaces free space, by
running for instance the following sql statement as a DBA user in
sqlplus:
 
select Total.name “Tablespace Name”, nvl(Free_space, 0)
Free_space,
nvl(total_space-Free_space, 0) Used_space, total_space
from
 (select tablespace_name, sum(bytes/1024/1024) Free_Space
  from sys.dba_free_space
  group by tablespace_name) Free,
  (select b.name, sum(bytes/1024/1024) TOTAL_SPACE
   from sys.v_$datafile a, sys.v_$tablespace B
   where a.ts# = b.ts#
   group by b.name) Total
where Free.Tablespace_name(+) = Total.name
order by Total.name;
  • July 8, 2015 | 25 views