My Oracle Support Banner

Error In AME Journal Notification: Exception: ORA-20002: 3240: Error '-6502 - ORA-06502: PL/SQL: Numeric Or Value Error: Bulk Bind: Truncated Bind (Doc ID 2054505.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
AME Journal Approval notification

Symptoms

After applying unpublished <Patch 7504287> "Oracle General Ledger Journal Approvals Integration with Oracle Approvals Management and Oracle Workflow" there is an error message showing up in the Approval web page for all notifications.

ERROR
---------
Fnd.framework.webui.OAPageErrorHandler"OAF LOG: Event : Check Errors, in:oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: ORA-20002:3240: Error '-6502 - ORA-06502: PL/SQL: numeric or value error: Bulk Bind:Truncated Bind' in 'PLSQL' API 'GL_WF_JE_NOTIFICATION_PKG.GET_GL_JE_APPROVE_MSG'ORA-06512: at ""APPS.WF_NOTIFICATION"", line 5513ORA-06512: at line 6,In VO: null"


The journal details are not seen in the notification page.
However, the Approve button can be pressed and the journal is approved without error.

Changes

Recently applied unpublished <patch 7504287> "Oracle General Ledger Journal Approvals Integration with Oracle Approvals Management and Oracle Workflow".

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.