In Oracle iProcurement, Punchout Catalog Requests Do Not Build The Complete Approvers List, and Errors May Occur- ORA-06502 ORA-06512 (Doc ID 2094172.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

Symptoms

In Oracle iProcurement, after returning from the supplier punchout site, the approver list is not appearing, or the complete list of approver is not displays.
Also, an error can occur when the requester user tries to submit the requisition for approval.

Error

Error Page
You have encountered an unexpected error. Please contact your System Administrator for assistance.
Click here for exception details.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 570
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1126
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1870
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 570
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1126
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1870
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 570
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 570
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1126
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1870
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 570
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 570
ORA-06512: at "APPS.WF_ITEM_ACTIVITY_STATUS", line 965
ORA-06512: at "APPS.WF_ITEM", line 873
ORA-06512: at "APPS.WF_ITEM_ACTIVITY_STATUS", line 207
ORA-06512: at "APPS.WF_ITEM_ACTIVITY_STATUS", line 314
ORA-06512: at "APPS.WF_ITEM_ACTIVITY_STATUS", line 304
ORA-06512: at "APPS.WF_ITEM_ACTIVITY_STATUS", line 201
ORA-06512: at "APPS.WF_ITEM", line 833
ORA-06512: at "APPS.WF_ITEM_ACTIVITY_STATUS", line 942
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 376
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 455
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1863
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1099
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 560
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 455
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1863
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1099
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 560
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1863
ORA-06512: at "APPS.WF_ENGINE_UTIL", line 1099
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.icx.por.common.server.ErrorUtil.handleFatalException(ErrorUtil.java:667)
at oracle.apps.icx.por.req.server.ReqSubActionSvrCmd.submitReqForApproval(ReqSubActionSvrCmd.java:401)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitReqNoValidation(RequisitionSvrCmd.java:965)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.continueSubmitReq(RequisitionSvrCmd.java:893)
at oracle.apps.icx.por.req.server.RequisitionSvrCmd.submitReq(RequisitionSvrCmd.java:595)
at oracle.apps.icx.por.req.server.RequisitionAMImpl.submitReq(RequisitionAMImpl.java:1019)
at oracle.apps.icx.por.req.webui.EditSubmitCO.processSubmitReq(EditSubmitCO.java:725)
at oracle.apps.icx.por.req.webui.EditSubmitCO.processFormRequest(EditSubmitCO.java:589)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:909)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1424)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1121)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1087)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:942)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1121)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1087)
..
..

Steps To Reproduce

1. Log in to Oracle Applications.
2. Navigate to the iProcurement responsibility > iProcurement Home Page.
3. Click the link to connect to the supplier punchout site.
4. On the supplier punchout site, add an item to cart and then return to iProcurement.
5. Upon return to iProcurement, see the punchout item in the shopping cart.
6. On the Edit and Submit Requisition page, see the informational message "It says “Based on your approval authority, this requisition does not require approval by others.” even though the user doesn’t have approval authority.
(Another case is that the approver list is showing only a partial list of the approvers, instead of the full list (one or more of the required approvers missing).
7. Submit the requisition for approval. The error occurs at this point.

** Workaround – The user can click on the browser Back button and resubmit the page. Then, the page loads correctly and the proper approver is shown.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.