Error Thrown In Creating New Sales Stage Using Sales Administrator Responsibility (Doc ID 2292740.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Sales Foundation - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

In 12.2.5, creating a new sales stage and clicking on update in Sales Stage page errors:

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error OrA-06512: at "APPS.AS_SALES_STAGES_PKG", line 137 ORA-06512: at line 1 java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "APPS.AS_SALES_STAGES_PKG", line 137 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTloer.processError(T4CTTloer.java:462) at oracle.jdbc.driver.T4CTTloer.processError(T4CTTloer.java: 405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver....


Where Issue Exist
===========
The error exists in production instance as well as prod clone and UAT.


Steps To Reproduce
==============
1. Sales Administrator responsibility
  N) Sales Administrator | Opportunities | Sales Stage, while trying to create a new sales stage and clicking on update.

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