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
Last updated on JUNE 19, 2018
Applies to:Oracle Purchasing - Version 12.2.7 and later
Information in this document applies to any platform.
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
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms