Error Message Invalid LOB Locator Specified ORA-22275 ORA-06512 In Approval Notification (Doc ID 743148.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
*** Checked relevance on 01-Dec-2014***

Symptoms

The approval notification does not show the lines or action history of the document. It displays an error but it does not prevent the user from approving the document. The following error is displayed:

ERROR
ORA-06502: numeric value error: invalid LOB locator specified: ORA-22275 ORA-06512 at
"APPS_WF_NOTIFICATION". LINE 5585
ORA-06512 at line 5


Steps To Reproduce:
1. Log in as approver
2. Go to the notification summary
3. Open the approval notification

It displays the error in the notification body.

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