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 MARCH 25, 2016

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 <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 <patch 7504287> "Oracle General Ledger Journal Approvals Integration with Oracle Approvals Management and Oracle Workflow".

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