Approval Workflow Database Error Occurs While Approving Standard Purchase Order (Doc ID 2085461.1)

Last updated on MARCH 29, 2017

Applies to:

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

Symptoms

When attempting to approve the standard Purchase order the following error occurs.

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

STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Create a new PO
2. Submit for approval
3. Once the Approver approves the PO , the document is approved but could see that the workflow errors out.

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