Item LOV In Comments Screen Throws SQL Error

(Doc ID 2004857.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Invoice Matching - Version and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
|This article will be updated as official patch information becomes available.


The Item LOV on the comments screen throws an SQL error.

Steps to Reproduce:

  1. Create a purchase order (PO).
  2. Navigate to REIM - >Document Maintenance -> Document Search -> New -> DMC/CMC/CNRC/CNRQ/DMQ/CMQ/CN (any one of these docs replicates the same error).
  3. Enter all Header level details and click on Comments-Comments screen.
  4. In the Item description field enter the description and click on the Item LOV.
  5. Note the error below:
error.sql_error Please contact your system administrator.



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