Purchase Order Stuck In Inprocess with Error "PO_REQAPPROVAL_INIT1.SET_STARTUP_VALUE" ORA-06502: PL/SQL: numeric or value error: character string buffer too small

(Doc ID 2412706.1)

Last updated on JUNE 19, 2018

Applies to:

Oracle Purchasing - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version when attempting to approve Standard POs or Blanket Agreements the workflow does not initiate properly and error occurs An error notification is sent to user with this in the notification body

The PO remains incomplete status and no wf_item_type or wf_item_key is populated in po headers table

ERROR
-----------------------
PL/SQL procedure: PO_REQAPPROVAL_INIT1.SET_STARTUP_VALUES
Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small


This issue is occuring on UAT and testing has stopped on UAT because of the issue. It is an upgraded 11.5.10 to 12.2.7 system.

On three other environments previously this upgrade was done and this error did NOT occur on those.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from 11i to 12.2.7
2. Test approval of POs
3. Error occurs
 

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