Fusion PIM: Getting error while Running CO Detail Report (Doc ID 1620274.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Fusion Product Hub - Version 11.1.6.0.0 and later
Information in this document applies to any platform.

Symptoms

When trying to run Change Order detail Report you are getting an error

Steps to Replicate the issue

  1. Create Change Order with effectivive Implementation date in Future.
  2. Go to Tools menu --> Schedule a Process
  3. Search for Change Order Detail Report
  4. Submit Report --> Report will error out.


Error Message
=================================================================== ================== Change Order Report Program ===================== =================================================================== --------------------------------------------------- ------------- Change Order Params ----------------- --------------------------------------------------- submit.argument1 ==> null submit.argument2 ==> null submit.argument6 ==> Y submit.argument5 ==> 2013-10-31 00:00:00.0 submit.argument4 ==> 2013-10-07 00:00:00.0 submit.argument3 ==> null submit.argument8 ==> null submit.argument7 ==> null --------------------------------------------------- ------------- end Change Order Params ------------- --------------------------------------------------- Unexpected error in Change propagation Program ----------------------------------------- java.lang.NullPointerException at oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.report.protectedModel.applicationModule.ChangeObjectReportAMImpl.queryCOsFromCoIdList(ChangeObjectReportAMImpl.java:432) at oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.report.protectedModel.applicationModule.ChangeObjectReportAMImpl.queryCOsFromParams(ChangeObjectReportAMImpl.java:415) at oracle.apps.scm.productCatalogManagement.changeManagement.changeObjects.report.protectedModel.applicationModule.ChangeObjectReportAMImpl.getReportXml(ChangeObjectReportAMImpl.java:400) at oracle.apps.scm.productCatalogManagement.changeObjects.ess.program.ChangeObjectReportJobDefImpl.executeInternal(ChangeObjectReportJobDefImpl.java:196) at oracle.apps.scm.productCatalogManagement.changeObjects.ess.program.ChangeObjectReportJobDefImpl.execute(ChangeObjectReportJobDefImpl.java:132) at oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.executeHelper(ExecutableWrapper.java:94) at oracle.apps.fnd.applcp.request.exec.ExecWrapperBase.execute(ExecWrapperBase.java:150) at oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.execute(ExecutableWrapper.java:80) at oracle.as.scheduler.rp.JavaSysExecWrapper$1.run(JavaSysExecWrapper.java:353) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315) at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:74) at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:83) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146) at weblogic.security.Security.runAs(Security.java:61) at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:51) at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:56) at oracle.as.scheduler.security.internal.SecurityExecutorBase.execute(SecurityExecutorBase.java:136) at oracle.as.scheduler.rp.JavaSysExecWrapper._executeJob(JavaSysExecWrapper.java:286) at oracle.as.scheduler.rp.JavaSysExecWrapper.finalizeExecution(JavaSysExecWrapper.java:169) at oracle.as.scheduler.rp.EndpointProcessor.finalizeExecute(EndpointProcessor.java:1018) at oracle.as.scheduler.rp.EndpointProcessor.finalizeExecuteWrapper(EndpointProcessor.java:980) at oracle.as.scheduler.adapter.EndpointImpl.finalizeExecute(EndpointImpl.java:561) at oracle.as.scheduler.ejb.EssAppEndpointBean.finalizeExecute(EssAppEndpointBean.java:162) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy187.finalizeExecute(Unknown Source) at oracle.as.scheduler.ejb.ESSAppEndpoint_t596cy_MDOImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.MDOMethodInvoker.invoke(MDOMethodInvoker.java:35) at oracle.as.scheduler.ejb.ESSAppEndpoint_t596cy_MDOImpl.finalizeExecute(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.invokeFinalizeExecute(RequestProcessor.java:8133) at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.execStage_Finalize(RequestProcessor.java:7331) at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.process_execute(RequestProcessor.java:4813) at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.dispatchHandler(RequestProcessor.java:2833) at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.processExecuteEvent(RequestProcessor.java:696) at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.processExecuteEvent(RequestProcessor.java:595) at oracle.as.scheduler.adapter.ra.WorkUnitWorkerBase.processWork(WorkUnitWorkerBase.java:194) at oracle.as.scheduler.adapter.ra.WAWorker.run(WAWorker.java:381) at weblogic.connector.security.layer.WorkImpl.runIt(WorkImpl.java:108) at weblogic.connector.security.layer.WorkImpl.run(WorkImpl.java:44) at weblogic.connector.work.WorkRequest.run(WorkRequest.java:95) at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
---

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms