My Oracle Support Banner

eSignature Notification To Supplier Fails If Supplier Name(Email) > 30 Characters (Doc ID 2563692.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

On : 12.2.5 version, Purchase Order

Signature Notification To Supplier errors and it is not sent.

For POs with eSignature turned on, when the notification is sent to the supplier, it fails with the error below:

ERROR
ORA-06512: at line
Wf_Engine_Util.Function_Call(PO_SIGNATURE_PVT.Set_Startup_Values, POAPPRV, PO_DOC_BIND_7255547_1_PA_452270, 358771, RUN)

Related sysadmin error notification shows:

  An Error occurred in the following Workflow.

  Item Type = POAPPRV
  Item Key = PO_DOC_BIND_7255547_1_PA_452270
  User Key =

  Error Name = -6512
  Error Message = ORA-6512: at line
  Error Stack = Wf_Engine_Util.Function_Call(PO_SIGNATURE_PVT.Set_Startup_Values, POAPPRV, PO_DOC_BIND_7255547_1_PA_452270, 358771, RUN)
  Activity Id = 358771
  Activity Label = DOCUMENT_SIGNATURE_PROCESS:SET_PO_SIGN_ATTRIBUTES
  Result Code = #EXCEPTION

FND Debug log shows:

  PO_SIGNATURE_PVT.SET_STARTUP_VALUES error msg: ORA-6502: PL/SQL: numeric or value error: character string buffer too small
  itemtype: POAPPRV itemkey: PO_DOC_BIND_7255547_1_PA_452270
  Message Text: PO_REQAPPROVAL_INIT1.send_error_notif: 50 Parent Itemtype: POAPPRV
  Parent Itemkey: PO_DOC_BIND_7255547_1_PA_452270
  Error Itemtype: POERROR Error

Steps to Reproduce:
1. Create PO with eSignature enabled
2. Route document for approval
3. Notification is sent to Supplier
4. Error occurs

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