My Oracle Support Banner

Error: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error at APPS.POR_APPROVAL_LIST While Click On Refresh Button From Edit And Submit Requisition Page (Doc ID 2668597.1)

Last updated on MAY 13, 2020

Applies to:

Oracle iProcurement - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Requisition Creation

When attempting to click on Refresh button from Edit and Submit Requisition page, the following error occurs:


ERROR

You have encountered an unexpected error.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.POR_APPROVAL_LIST", line 1182
ORA-06512: at "APPS.POR_APPROVAL_LIST", line 208
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:1051)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:258)
at oracle.apps.icx.por.approval.webui.ApprovalsCO.processRequest(ApprovalsCO.java:94)

..

## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.POR_APPROVAL_LIST", line 1182
ORA-06512: at "APPS.POR_APPROVAL_LIST", line 208
ORA-06512: at line 1

..

at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.getApprovalList(ApprovalListAMImpl.java:3099)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.poDefaultList(ApprovalListAMImpl.java:3332)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.poBuildApprovalListForPreparer(ApprovalListAMImpl.java:1869)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.buildApprovalListForPreparer(ApprovalListAMImpl.java:1586)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.buildApprovalList(ApprovalListAMImpl.java:278)
at oracle.apps.icx.por.approval.server.ApprovalListAMImpl.buildApprovalList(ApprovalListAMImpl.java:222)

..

 

STEPS

1. Navigate to iProcurement Responsibility -> iProcurement Home Page -> Requisitions

2. Select an Incomplete Requisition from All My Requisitions view, and click on Complete

3. From Edit and Submit Requisition page, click on Refresh

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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