Get ORA-20002: 3133: Activity Instance Error On Submitting Return From iStore Account (Doc ID 388070.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle iStore - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

 

When user sets iStore return profile to = 'Return with Approval' and set  'Pre-Booking profile' to Yes, they get application error on the customer UI.

"The application is currently not available or an unexpected error has occured.
Please try again later. If this message persists, please contact the system administrator".

Steps to reproduce bug: -
1. Set


2. Create an order
3. Click on 'Return Items' on the Order details page
4. On the 'Create Return: Select Items' page, provide qty and click on next button
5. On 'Create Return: Review and Submit' page click on 'Submit Return'

The View Source of the page shows the following java error stack:

Message: ORA-20002: 3133: Activity instance 'RMA_WAIT_FOR_SUBMISSION' is not a
notified activity for item 'OEOH/1666'. in Package OE_RMA_GRP Procedure
Submit_Order
Stack:
oracle.apps.jtf.base.resources.FrameworkException: ORA-20002: 3133: Activity
instance 'RMA_WAIT_FOR_SUBMISSION' is not a notified activity for item
'OEOH/1666'. in Package OE_RMA_GRP Procedure Submit_Order
at oracle.apps.ibe.postsales.OrderDB.save(OrderDB.java:1926)
at oracle.apps.ibe.postsales.Order.submitOrder(Order.java:312)
at _oa__html._ibeCOtdRetReviewMain._jspService(_ibeCOtdRetReviewMain.java:2012)
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:534)
ORA-20002: 3133: Activity instance 'RMA_WAIT_FOR_SUBMISSION' is not a notified
activity for item 'OEOH/1666'. in Package OE_RMA_GRP Procedure Submit_Order

Changes

 

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