Error Occured When Attempting to Sort by Category Code in Commodities Page

(Doc ID 1953058.1)

Last updated on AUGUST 21, 2016

Applies to:

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


When attempting to sort by category code in commodities page,
the following error occurs.


Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PoCommCategoryEO.CATEGORY_ID,


The issue can be reproduced at will with the following steps:

  1. Navigate to Purchasing responsibility >Setup>Items>Commodities>Commodities
  2. Click the update for any commodity
  3. Click the Category code column header for sorting ascending/decending.




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