4 Replies Latest reply on Feb 11, 2015 4:53 AM by 895773

    java.lang.ArrayIndexOutOfBoundsException: 3      at oracle.sql.DATE.toTimestamp(DATE.java:338)

    895773

      Hi,

       

      I am extending a seeded VO (OpportunityDetailsVO) and added few columns in the SQL query as below:

      NVL (

                (SELECT 'Y'

                   FROM jtf_rs_resource_extns ext, as_accesses_all acc

                  WHERE     ext.user_id = fnd_global.user_id

                        AND ext.resource_id = acc.salesforce_id

                        AND ROWNUM = 1

                        AND acc.lead_id = OpportunityEO.lead_id),

                'N')

                IS_SALES_TEAM,

             DECODE (OpportunityEO.attribute10, 'Private', 'Y', 'N') IS_CARRIER,

             DECODE (OpportunityEO.freeze_flag, 'Y', 'Y', 'N') IS_FROZEN,

             OpportunityEO.freeze_flag,

             OpportunityEO.close_competitor_id,

             OpportunityEO.close_comment,

             TO_DATE (OpportunityEO.attribute14, 'YYYY/MM/DD HH24:MI:SS')

                offer_valid_from,

             TO_DATE (OpportunityEO.attribute13, 'YYYY/MM/DD HH24:MI:SS')

                offer_valid_until,

             fnd_global.user_id user_id,

             fnd_global.resp_id responsibility_id,

             hp.attribute4 concern,

             ext.source_name owner,

             (SELECT SALES_LEAD_ID

                FROM AS_SALES_LEAD_OPPORTUNITY

               WHERE AS_SALES_LEAD_OPPORTUNITY.OPPORTUNITY_ID =

                        OpportunityEO.lead_id)

                AS source_lead_id

       

      But I am getting exception in the OAF page after its deployment. Please find below error stack:

       

       

      Exception Details.
      oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 3 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3483) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3237) at _pages.__oa._jspService(__oa.java:252) at weblogic.servlet.jsp.JspBase.service(JspBase.java:34) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119) at java.security.AccessController.doPrivileged(Native Method) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324) at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460) at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) ## Detail 0 ## java.lang.ArrayIndexOutOfBoundsException: 3 at oracle.sql.DATE.toTimestamp(DATE.java:338) at oracle.sql.DATE.timestampValue(DATE.java:847) at oracle.apps.fnd.framework.webui.OADictionaryDataString.convertValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADictionaryDataViewObject.selectGoodValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADictionaryData.selectValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADictionaryDataViewObject.selectValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADataBoundValue.selectValue(OADataBoundValue.java:278) at oracle.apps.fnd.framework.webui.OADataBoundValue.getResultValueFromDataOjbect(OADataBoundValue.java:238) at oracle.apps.fnd.framework.webui.OADataBoundValue.getValue(OADataBoundValue.java:158) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1844) at oracle.apps.fnd.framework.webui.beans.message.OAMessageStyledTextBean.getAttributeValueImpl(OAMessageStyledTextBean.java:238) at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source) at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source) at oracle.cabo.ui.collection.AttributeMapProxy.getAttribute(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source) at oracle.cabo.ui.laf.base.BaseLafUtils.getLocalTextAttribute(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.StyledTextRenderer.getText(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.StyledTextRenderer.getElementName(Unknown Source) at oracle.cabo.ui.ElementRenderer.prerender(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.prerender(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.StyledTextRenderer.prerender(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.RowLayoutRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.InlineMessageRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer.renderColumn(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer._renderColumns(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.apps.fnd.framework.configpage.renderer.FlexibleContentRenderer.renderContentOfFlexibleContent(FlexibleContentRenderer.java:346) at oracle.apps.fnd.framework.configpage.renderer.FlexibleContentRenderer.renderExpandedState(FlexibleContentRenderer.java:243) at oracle.apps.fnd.framework.configpage.renderer.FlexibleContentRenderer.renderContent(FlexibleContentRenderer.java:114) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.apps.fnd.framework.configpage.renderer.FlexibleLayoutRenderer.renderVerticalLayout(FlexibleLayoutRenderer.java:458) at oracle.apps.fnd.framework.configpage.renderer.FlexibleLayoutRenderer.renderContentOfFlexibleLayout(FlexibleLayoutRenderer.java:411) at oracle.apps.fnd.framework.configpage.renderer.FlexibleLayoutRenderer.renderExpandedState(FlexibleLayoutRenderer.java:245) at oracle.apps.fnd.framework.configpage.renderer.FlexibleLayoutRenderer.renderContent(FlexibleLayoutRenderer.java:116) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.apps.fnd.framework.webui.beans.OABodyBean.render(OABodyBean.java:403) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.partial.PartialPageUtils.renderPartialPage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.render(OAPageBean.java:3833) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3473) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3237) at _pages.__oa._jspService(__oa.java:252) at weblogic.servlet.jsp.JspBase.service(JspBase.java:34) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119) at java.security.AccessController.doPrivileged(Native Method) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324) at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460) at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) java.lang.ArrayIndexOutOfBoundsException: 3 at oracle.sql.DATE.toTimestamp(DATE.java:338) at oracle.sql.DATE.timestampValue(DATE.java:847) at oracle.apps.fnd.framework.webui.OADictionaryDataString.convertValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADictionaryDataViewObject.selectGoodValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADictionaryData.selectValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADictionaryDataViewObject.selectValue(Unknown Source) at oracle.apps.fnd.framework.webui.OADataBoundValue.selectValue(OADataBoundValue.java:278) at oracle.apps.fnd.framework.webui.OADataBoundValue.getResultValueFromDataOjbect(OADataBoundValue.java:238) at oracle.apps.fnd.framework.webui.OADataBoundValue.getValue(OADataBoundValue.java:158) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1844) at oracle.apps.fnd.framework.webui.beans.message.OAMessageStyledTextBean.getAttributeValueImpl(OAMessageStyledTextBean.java:238) at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source) at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source) at oracle.cabo.ui.collection.AttributeMapProxy.getAttribute(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source) at oracle.cabo.ui.laf.base.BaseLafUtils.getLocalTextAttribute(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.StyledTextRenderer.getText(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.StyledTextRenderer.getElementName(Unknown Source) at oracle.cabo.ui.ElementRenderer.prerender(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.prerender(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.StyledTextRenderer.prerender(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.RowLayoutRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.InlineMessageRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer.renderColumn(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer._renderColumns(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.apps.fnd.framework.configpage.renderer.FlexibleContentRenderer.renderContentOfFlexibleContent(FlexibleContentRenderer.java:346) at oracle.apps.fnd.framework.configpage.renderer.FlexibleContentRenderer.renderExpandedState(FlexibleContentRenderer.java:243) at oracle.apps.fnd.framework.configpage.renderer.FlexibleContentRenderer.renderContent(FlexibleContentRenderer.java:114) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.apps.fnd.framework.configpage.renderer.FlexibleLayoutRenderer.renderVerticalLayout(FlexibleLayoutRenderer.java:458) at oracle.apps.fnd.framework.configpage.renderer.FlexibleLayoutRenderer.renderContentOfFlexibleLayout(FlexibleLayoutRenderer.java:411) at oracle.apps.fnd.framework.configpage.renderer.FlexibleLayoutRenderer.renderExpandedState(FlexibleLayoutRenderer.java:245) at oracle.apps.fnd.framework.configpage.renderer.FlexibleLayoutRenderer.renderContent(FlexibleLayoutRenderer.java:116) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.HeaderRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.apps.fnd.framework.webui.beans.OABodyBean.render(OABodyBean.java:403) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.partial.PartialPageUtils.renderPartialPage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.render(OAPageBean.java:3833) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3473) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3237) at _pages.__oa._jspService(__oa.java:252) at weblogic.servlet.jsp.JspBase.service(JspBase.java:34) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119) at java.security.AccessController.doPrivileged(Native Method) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324) at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460) at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)   

       

       

      Please help!

       

      Thanks,

      Anupam

       

        • 1. Re: java.lang.ArrayIndexOutOfBoundsException: 3      at oracle.sql.DATE.toTimestamp(DATE.java:338)
          ocol

          Hi Anupam,

           

          Please share the xml of the VO.

          Make sure in Jdevloper you do not have any duplicated attribute in the VO definition.

           

          I found this similar thread Error when Extending VO

           

          Regards,

          Olivier

          • 2. Re: java.lang.ArrayIndexOutOfBoundsException: 3      at oracle.sql.DATE.toTimestamp(DATE.java:338)
            895773

            Hi Olivier,

             

            Please find below xml content of the VO:

             

            <?xml version="1.0" encoding="WINDOWS-1252"?>

             

             

            <!DOCTYPE ViewObject SYSTEM "jbo_03_01.dtd">

             

             

            -<ViewObject UseGlueCode="false" ComponentClass="oracle.apps.xxfe.f426.asn.opportunity.server.OpportunityDetailsVOExImpl" RowClass="oracle.apps.xxfe.f426.asn.opportunity.server.OpportunityDetailsVOExRowImpl" CustomQuery="true" BindingStyle="OracleName" Extends="oracle.apps.asn.opportunity.server.OpportunityDetailsVO" Name="OpportunityDetailsVOEx">

             

             

             

             

            -<SQLQuery>

             

             

            <![CDATA[ /* Formatted on 2/5/2015 12:36:25 PM (QP5 v5.185.11230.41888) */ SELECT OpportunityEO.lead_id, OpportunityEO.description, OpportunityEO.status, OpportunityEO.sales_stage_id, OpportunityEO.total_amount, OpportunityEO.currency_code, OpportunityEO.decision_date, OpportunityEO.win_probability, OpportunityEO.close_reason, OpportunityEO.sales_methodology_id, OpportunityEO.channel_code, DECODE (OpportunityEO.sales_methodology_id, NULL, 'N', 'Y') AS sales_meth_flag, OpportunityEO.customer_id, hp.party_name, hp.party_type, OpportunityEO.attribute1, OpportunityEO.attribute2, OpportunityEO.attribute3, OpportunityEO.attribute4, OpportunityEO.attribute5, OpportunityEO.attribute6, OpportunityEO.attribute7, OpportunityEO.attribute8, OpportunityEO.attribute9, OpportunityEO.attribute10, OpportunityEO.attribute11, OpportunityEO.attribute12, OpportunityEO.attribute13, OpportunityEO.attribute14, OpportunityEO.attribute15, OpportunityEO.attribute_category, OpportunityContactEO.contact_party_id AS relationship_party_id, OpportunityEO.source_promotion_id, amsc.arc_source_code_for, DECODE ( amsc.arc_source_code_for, 'CAMP', (SELECT campaign_name FROM AMS_CAMPAIGNS_ALL_TL WHERE campaign_id = amsc.source_code_for_id AND language = USERENV ('LANG')), 'EVEH', (SELECT event_header_name FROM AMS_EVENT_HEADERS_ALL_TL WHERE event_header_id = amsc.source_code_for_id AND language = USERENV ('LANG')), 'EONE', (SELECT event_offer_name FROM AMS_EVENT_OFFERS_ALL_TL WHERE event_offer_id = amsc.source_code_for_id AND language = USERENV ('LANG')), 'EVEO', (SELECT event_offer_name FROM AMS_EVENT_OFFERS_ALL_TL WHERE event_offer_id = amsc.source_code_for_id AND language = USERENV ('LANG')), 'CSCH', (SELECT schedule_name FROM ams_campaign_schedules_tl WHERE schedule_id = amsc.source_code_for_id AND language = USERENV ('LANG')), 'OFFR', (SELECT description FROM qp_list_headers_tl WHERE list_header_id = amsc.source_code_for_id AND language = USERENV ('LANG')), NULL) AS source_name, amsc.source_code, (SELECT SUM (opp_forecast_amount) FROM as_sales_credits ascs WHERE ascs.lead_id = OpportunityEO.lead_id AND ascs.credit_type_id = :1) AS forecast_amount, '' AS empty_string, DECODE ( 1, ( SELECT 1 FROM as_sales_lead_opportunity aslo WHERE aslo.opportunity_id = OpportunityEO.lead_id GROUP BY opportunity_id HAVING COUNT (1) > 1), 'ASNOpptyDetSrcNm', NVL ( (SELECT 'ASNOpptyDetSrcNmLnk' FROM as_sales_lead_opportunity aslo, as_sales_leads asl WHERE asl.source_system = 'SALES_CAMPAIGN' AND asl.source_promotion_id IS NOT NULL AND aslo.sales_lead_id = asl.sales_lead_id AND aslo.opportunity_id = OpportunityEO.lead_id AND ROWNUM = 1), 'ASNOpptyDetSrcNm')) AS source_name_upd_flag, amsc.source_code_for_id, OpportunityEO.object_version_number, OpportunityContactEO.object_version_number AS contact_object_version_number, OpportunityContactEO.lead_contact_id, DECODE (OpportunityEO.sales_stage_id, NULL, 'N', 'Y') AS sales_stage_flag, OpportunityEO.address_id, NULL AS address, OpportunityEO.prm_referral_code, OpportunityEO.lead_number, OpportunityEO.vehicle_response_code, hp.email_address AS Cust_Email, NULL AS Cust_Formatted_Phone, hp.primary_phone_contact_pt_id AS primary_phone_contact_pt_id, hl.location_id, hp.primary_phone_country_code, hp.primary_phone_area_code, hp.primary_phone_number, hp.primary_phone_extension, --R12 Upgrade changes start NVL ( (SELECT 'Y' FROM jtf_rs_resource_extns ext, as_accesses_all acc WHERE ext.user_id = fnd_global.user_id AND ext.resource_id = acc.salesforce_id AND ROWNUM = 1 AND acc.lead_id = OpportunityEO.lead_id), 'N') IS_SALES_TEAM, DECODE (OpportunityEO.attribute10, 'Private', 'Y', 'N') IS_CARRIER, DECODE (OpportunityEO.freeze_flag, 'Y', 'Y', 'N') IS_FROZEN, OpportunityEO.freeze_flag, OpportunityEO.close_competitor_id, OpportunityEO.close_comment, TO_DATE (OpportunityEO.attribute14, 'YYYY/MM/DD HH24:MI:SS') offer_valid_from, TO_DATE (OpportunityEO.attribute13, 'YYYY/MM/DD HH24:MI:SS') offer_valid_until, fnd_global.user_id user_id, fnd_global.resp_id responsibility_id, hp.attribute4 concern, ext.source_name owner, (SELECT SALES_LEAD_ID FROM AS_SALES_LEAD_OPPORTUNITY WHERE AS_SALES_LEAD_OPPORTUNITY.OPPORTUNITY_ID = OpportunityEO.lead_id) AS source_lead_id --R12 Upgrade changes end FROM as_leads_all OpportunityEO, hz_parties hp, as_lead_contacts_all OpportunityContactEO, ams_source_codes amsc, hz_party_sites hps, hz_locations hl, fnd_territories_tl ftt, --R12 Upgrade changes start jtf_rs_resource_extns ext --R12 Upgrade changes end WHERE OpportunityEO.customer_id = hp.party_id AND OpportunityEO.lead_id = OpportunityContactEO.lead_id(+) AND OpportunityEO.customer_id = OpportunityContactEO.customer_id(+) AND OpportunityContactEO.primary_contact_flag(+) = 'Y' AND OpportunityEO.source_promotion_id = amsc.source_code_id(+) AND OpportunityEO.address_id = hps.party_site_id(+) AND OpportunityEO.customer_id = hps.party_id(+) AND hps.location_id = hl.location_id(+) AND hl.country = ftt.territory_code(+) AND ftt.language(+) = USERENV ('LANG') AND OpportunityEO.lead_id = :2 AND ext.resource_id(+) = OpportunityEO.owner_salesforce_id ]]>

             

             

            </SQLQuery>

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_isCodegen" Value="true"/>

             

             

            <Attr Name="_isExpertMode" Value="true"/>

             

             

            <Attr Name="_version" Value="10.1.3.43.6"/>

             

             

            <Attr Name="_codeGenFlag2" Value="Access|Coll|VarAccess"/>

             

             

            </DesignTime>

             

             

             

             

            -<ViewAttribute Name="SalesMethFlag" SQLType="VARCHAR" Expression="SALES_METH_FLAG" AliasName="SALES_METH_FLAG" ColumnType="VARCHAR2" Type="java.lang.String" Precision="1" IsPersistent="false" IsQueriable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="1"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="PartyName" SQLType="VARCHAR" Expression="PARTY_NAME" AliasName="PARTY_NAME" ColumnType="VARCHAR2" Type="java.lang.String" Precision="360" IsPersistent="false" IsQueriable="false" IsNotNull="true">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="360"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="PartyType" SQLType="VARCHAR" Expression="PARTY_TYPE" AliasName="PARTY_TYPE" ColumnType="VARCHAR2" Type="java.lang.String" Precision="30" IsPersistent="false" IsQueriable="false" IsNotNull="true">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="30"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="RelationshipPartyId" SQLType="NUMERIC" Expression="RelationshipPartyId" AliasName="RELATIONSHIPPARTYID" ColumnType="Number" Type="oracle.jbo.domain.Number" IsPersistent="false" IsUpdateable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="ArcSourceCodeFor" SQLType="VARCHAR" Expression="ARC_SOURCE_CODE_FOR" AliasName="ARC_SOURCE_CODE_FOR" ColumnType="VARCHAR2" Type="java.lang.String" Precision="30" IsPersistent="false" IsQueriable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="30"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="SourceName" SQLType="VARCHAR" Expression="SOURCE_NAME" AliasName="SOURCE_NAME" ColumnType="VARCHAR2" Type="java.lang.String" Precision="2000" IsPersistent="false" IsQueriable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="2000"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="SourceCode" SQLType="VARCHAR" Expression="SOURCE_CODE" AliasName="SOURCE_CODE" ColumnType="VARCHAR2" Type="java.lang.String" Precision="30" IsPersistent="false" IsQueriable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="30"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="ForecastAmount" SQLType="NUMERIC" Expression="FORECAST_AMOUNT" AliasName="FORECAST_AMOUNT" ColumnType="Number" Type="oracle.jbo.domain.Number" IsPersistent="false" IsQueriable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="22"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="EmptyString" SQLType="VARCHAR" Expression="EMPTY_STRING" AliasName="EMPTY_STRING" ColumnType="VARCHAR2" Type="java.lang.String" Precision="1" IsPersistent="false" IsQueriable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="SourceNameUpdFlag" SQLType="VARCHAR" Expression="SOURCE_NAME_UPD_FLAG" AliasName="SOURCE_NAME_UPD_FLAG" ColumnType="VARCHAR2" Type="java.lang.String" Precision="40" IsPersistent="false" IsQueriable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="19"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="SourceCodeForId" SQLType="NUMERIC" Expression="SOURCE_CODE_FOR_ID" AliasName="SOURCE_CODE_FOR_ID" ColumnType="Number" Type="oracle.jbo.domain.Number" IsPersistent="false" IsQueriable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="22"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="SalesStageFlag" SQLType="VARCHAR" Expression="SALES_STAGE_FLAG" AliasName="SALES_STAGE_FLAG" ColumnType="VARCHAR2" Type="java.lang.String" Precision="1" IsPersistent="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="1"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="Address" SQLType="VARCHAR" Expression="ADDRESS_ID" AliasName="ADDRESS" ColumnType="VARCHAR2" Type="java.lang.String" Precision="4000" IsPersistent="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="4000"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="PrmReferralCode" SQLType="VARCHAR" Expression="PRM_REFERRAL_CODE" AliasName="PRM_REFERRAL_CODE" ColumnType="VARCHAR2" Type="java.lang.String" Precision="240" IsPersistent="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="240"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="LeadNumber" SQLType="VARCHAR" Expression="LEAD_NUMBER" AliasName="LEAD_NUMBER" ColumnType="VARCHAR2" Type="java.lang.String" Precision="30" IsPersistent="false" IsNotNull="true">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="30"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="CustEmail" SQLType="VARCHAR" Expression="CUST_EMAIL" AliasName="CUST_EMAIL" ColumnType="VARCHAR2" Type="java.lang.String" Precision="2000" IsPersistent="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="2000"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="CustFormattedPhone" SQLType="VARCHAR" Expression="CUST_FORMATTED_PHONE" AliasName="CUST_FORMATTED_PHONE" ColumnType="VARCHAR2" Type="java.lang.String" Precision="83" IsPersistent="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            <Attr Name="_DisplaySize" Value="83"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="HasContactRestriction" SQLType="VARCHAR" AliasName="HAS_CONTACT_RESTRICTION" ColumnType="VARCHAR2" Type="java.lang.String" Precision="15" IsPersistent="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="HasDtContactRestriction" SQLType="VARCHAR" AliasName="HAS_DT_CONTACT_RESTRICTION" ColumnType="VARCHAR2" Type="java.lang.String" Precision="15" IsPersistent="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="PrimaryPhoneContactPtId" SQLType="NUMERIC" Expression="PrimaryPhoneContactPtId" AliasName="PrimaryPhoneContactPtId" ColumnType="NUMBER" Type="oracle.jbo.domain.Number" Precision="15" IsPersistent="false" Scale="0">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="LocationId" SQLType="NUMERIC" Expression="LocationId" AliasName="LOCATIONID" ColumnType="NUMBER" Type="oracle.jbo.domain.Number" IsPersistent="false" IsUpdateable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="PrimaryPhoneCountryCode" SQLType="VARCHAR" Expression="PrimaryPhoneCountryCode" AliasName="PRIMARYPHONECOUNTRYCODE" ColumnType="VARCHAR2" Type="java.lang.String" Precision="10" IsPersistent="false" IsUpdateable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="PrimaryPhoneAreaCode" SQLType="VARCHAR" Expression="PrimaryPhoneAreaCode" AliasName="PRIMARYPHONEAREACODE" ColumnType="VARCHAR2" Type="java.lang.String" Precision="10" IsPersistent="false" IsUpdateable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="PrimaryPhoneNumber" SQLType="VARCHAR" Expression="PrimaryPhoneNumber" AliasName="PRIMARYPHONENUMBER" ColumnType="VARCHAR2" Type="java.lang.String" Precision="40" IsPersistent="false" IsUpdateable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

             

             

            -<ViewAttribute Name="PrimaryPhoneExtension" SQLType="VARCHAR" Expression="PrimaryPhoneExtension" AliasName="PRIMARYPHONEEXTENSION" ColumnType="VARCHAR2" Type="java.lang.String" Precision="20" IsPersistent="false" IsUpdateable="false">

             

             

             

             

            -<DesignTime>

             

             

            <Attr Name="_OverrideAttr" Value="true"/>

             

             

            </DesignTime>

             

             

            </ViewAttribute>

             

             

            <ViewAttribute Name="IsOpptyUpdSalesTeamC" SQLType="VARCHAR" Expression="IS_SALES_TEAM" AliasName="IS_SALES_TEAM" ColumnType="VARCHAR2" Type="java.lang.String" Precision="1" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="IsOpptyCarrierC" SQLType="VARCHAR" Expression="IS_CARRIER" AliasName="IS_CARRIER" ColumnType="VARCHAR2" Type="java.lang.String" Precision="1" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="IsOpptyFrozenC" SQLType="VARCHAR" Expression="IS_FROZEN" AliasName="IS_FROZEN" ColumnType="VARCHAR2" Type="java.lang.String" Precision="1" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="FreezeFlag" SQLType="VARCHAR" Expression="FREEZE_FLAG" AliasName="FREEZE_FLAG" ColumnType="VARCHAR2" Type="java.lang.String" Precision="255" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="CloseCompetitorId" SQLType="NUMERIC" AliasName="CLOSE_COMPETITOR_ID" ColumnType="NUMBER" Type="oracle.jbo.domain.Number" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="CloseComment" SQLType="VARCHAR" AliasName="CLOSE_COMMENT" ColumnType="VARCHAR2" Type="java.lang.String" Precision="255" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="OfferValidFrom" SQLType="DATE" Expression="OFFER_VALID_FROM" AliasName="OFFER_VALID_FROM" ColumnType="DATE" Type="oracle.jbo.domain.Date" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="OfferValidUntil" SQLType="DATE" Expression="OFFER_VALID_UNTIL" AliasName="OFFER_VALID_UNTIL" ColumnType="DATE" Type="oracle.jbo.domain.Date" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="UserId" SQLType="NUMERIC" Expression="USER_ID" AliasName="USER_ID" ColumnType="NUMBER" Type="oracle.jbo.domain.Number" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="ResponsibilityId" SQLType="NUMERIC" Expression="RESPONSIBILITY_ID" AliasName="RESPONSIBILITY_ID" ColumnType="NUMBER" Type="oracle.jbo.domain.Number" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="Concern" SQLType="VARCHAR" Expression="CONCERN" AliasName="CONCERN" ColumnType="VARCHAR2" Type="java.lang.String" Precision="150" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="Owner" SQLType="VARCHAR" Expression="OWNER" AliasName="OWNER" ColumnType="VARCHAR2" Type="java.lang.String" Precision="200" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            <ViewAttribute Name="SourceLeadId" SQLType="VARCHAR" Expression="SOURCE_LEAD_ID" AliasName="SOURCE_LEAD_ID" ColumnType="VARCHAR2" Type="java.lang.String" Precision="255" IsPersistent="false" IsUpdateable="false"> </ViewAttribute>

             

             

            </ViewObject>

             

            Thanks,

            Anupam

            • 3. Re: java.lang.ArrayIndexOutOfBoundsException: 3      at oracle.sql.DATE.toTimestamp(DATE.java:338)
              Kristofer Cruz

              Did you add the fields at the end of in the middle of the field list?

              • 4. Re: java.lang.ArrayIndexOutOfBoundsException: 3      at oracle.sql.DATE.toTimestamp(DATE.java:338)
                895773

                Hi Kristofer,

                 

                I added these new fields in the end.

                 

                Thanks,

                Anupam