Error Occured When Attempting to Sort by Category Code in Commodities Page
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.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PoCommCategoryEO.CATEGORY_ID,
mcvl.DESCRIPTION AS DESCRIPTION,
The issue can be reproduced at will with the following steps:
- Navigate to Purchasing responsibility >Setup>Items>Commodities>Commodities
- Click the update for any commodity
- 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