Monday, October 20, 2014

Entity () defined for attachment item (attachmentTable) is invalid

Issue

racle.apps.fnd.framework.OAException: Entity () defined for attachment item (attachmentTable) is invalid.
     at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1223)
     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1987)
     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
     at oa_html._OA._jspService(_OA.java:84)
     at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
     at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
     at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
     at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
     at oracle.jsp.JspServlet.service(JspServlet.java:156)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
     at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
     at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
     at oa_html._OA._jspService(_OA.java:94)
     at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
     at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
     at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
     at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
     at oracle.jsp.JspServlet.service(JspServlet.java:156)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
     at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
     at org.apache.jserv.JServConnection.run(JServConnection.java:294)
     at java.lang.Thread.run(Thread.java:619)
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Entity () defined for attachment item (attachmentTable) is invalid.
     at oracle.apps.fnd.framework.webui.OAAttachmentUtils.getEntityMappings(OAAttachmentUtils.java:205)
     at oracle.apps.fnd.framework.webui.OAAttachmentTableHelper.setMetaDataProperties(OAAttachmentTableHelper.java:188)
     at oracle.apps.fnd.framework.webui.OAAttachmentTableHelper.createWebBean(OAAttachmentTableHelper.java:121)
     at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.createWebBeanUsingHelper(OAWebBeanFactoryImpl.java:1475)
     at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.createWebBeanFromCustomTables(OAWebBeanFactoryImpl.java:1255)
     at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.createWebBean(OAWebBeanFactoryImpl.java:732)
     at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.createWebBean(OAWebBeanFactoryImpl.java:712)
     at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.addAkChildren(OAPageLayoutHelper.java:760)
     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.setMetaDataProperties(OAWebBeanContainerHelper.java:200)
     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.setMetaDataProperties(OAWebBeanContainerHelper.java:126)
     at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.setMetaDataProperties(OAPageLayoutHelper.java:258)
     at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.createWebBean(OAPageLayoutHelper.java:209)
     at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.createWebBeanUsingHelper(OAWebBeanFactoryImpl.java:1475)
     at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.createWebBeanFromCustomTables(OAWebBeanFactoryImpl.java:1407)
     at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.createWebBean(OAWebBeanFactoryImpl.java:1292)
     at oracle.apps.fnd.framework.webui.OAPageBean.createRootWebBean(OAPageBean.java:4477)
     at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2168)
     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1735)
     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
     at oa_html._OA._jspService(_OA.java:84)
     at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
     at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
     at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
     at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
     at oracle.jsp.JspServlet.service(JspServlet.java:156)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
     at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
     at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
     at oa_html._OA._jspService(_OA.java:94)
     at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
     at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
     at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
     at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
     at oracle.jsp.JspServlet.service(JspServlet.java:156)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
     at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
     at org.apache.jserv.JServConnection.run(JServConnection.java:294)
     at java.lang.Thread.run(Thread.java:619)

Cause: Due to Entity bad data defined by user

Solution:
Navigate to Functional Administrator
Click on Personalizations --> Enter the Document (/oracle/apps/ar/cusstd/acctoview/webui/AcctOviewPG) in this case its Attachments 
To identify the page link you need to enable all personalizations enabled and open up the page which you worked on

Click on Manage Personalizations

Deactivate the site and Organization -

In Parallel, open Customer page (where user has personalizational links enabled) click on Attachments
you should be able to open the Personalization attachments, now be on the same page
Go to Functional Administrator, activate the site level and come back to Personalization attachment page, refresh the same, you should be able to find the details, now click on Choose Context and come back again to Personalization attachments page
Now you will be able to see the Entity you have defined, click on Update Icon verify and then Delete the same

Now on otherhand once deletion is done, go to Functional Administrator enable the organization and activate the same

Now close all your browsers, clear cache, relogin and verify the results

you should be able to find the Attachment categories you have defined

Refer to below document ids for creating document categories

Customer Form Issue: How to Add Different Categories for Attachments ( Doc ID 1080508.1 ) 

No comments:

Post a Comment