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

Last updated on SEPTEMBER 06, 2016

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(243135, SUBJECTTEXT, text/plain)Wf_Notification.GetAttrDoc(243135,


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(243135, SUBJECTTEXT, text/plain) Wf_Notification.GetAttrDoc(243135,

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(243135, SUBJECTTEXT, text/plain) Wf_Notification.GetAttrDoc(243135,



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