My Oracle Support Banner

ORA-06502 PL/SQL Error Character String Buffer Too Small Numeric or Value on Deliverables Notification (Doc ID 1551397.1)

Last updated on JULY 22, 2020

Applies to:

Oracle Procurement Contracts - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.3  Spanish language, find  that there are Deliverables Notification Errors for users.

Error:

Error deliverable notification subject:
Error ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor Nombre del Error: -6502 Pila de Errores: wf_notification.GetAttrDoc2(xxxxxx, SUBJECTTEXT, text/plain)


Translation:  
Error executing PLSQL API Doc - OKC_DELIVERABLE_WF_PVT.get_subject_text -> ORA-06502: PL / SQL: error: character string buffer too small numeric or value

The error is just reproduced in Spanish language after 13877401 patch application
 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

FROM RFQ:
1. Create a RFQ,
a. Apply Contract template with deliverable
b. In the deliverable, the Status Change flag is on
2. Publish the RFQ
3. Access to iSupplier Portal with the supplier user and execute the deliverable
4. Access with the requester user deliverable in the worklist notification, there is a deliverable notification with the error:
Error ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor Nombre del Error: -6502 Pila de Errores: wf_notification.GetAttrDoc2(xxxxxx, SUBJECTTEXT, text/plain)


FROM PO:
1. Create a PO,
a. Apply Contract template with deliverable
b. In the deliverable, the Status Change flag is on
2. Approve the PO
3. Access to iSupplier Portal with the supplier user and execute the deliverable
4. Access with the requester user deliverable in the worklist notification, there is a deliverable notification with the error:
Error ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor Nombre del Error: -6502 Pila de Errores: wf_notification.GetAttrDoc2(xxxxxx, SUBJECTTEXT, text/plain)


Changes

 

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
Changes
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.