DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, July 8, 2015

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;

1 comment:

Sridevi K said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.