Encountered Unexpected Exception When Sorting 'Item/Job' Column in Buyer Work Center
Last updated on FEBRUARY 03, 2018
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
Encountered "You have encountered an unexpected error. Please contact the System Administrator for assistance." error when sorting 'Item/Job' column in Buyer work center.
- Enable sorting feature for column via Personalization for column 'Item/Job'
- Navigate to Buyer Work Center > Requisition > Demand Workbench
- Search Requisitions lines
- After Requisition lines were populated, click the column label 'Item/Job' then error "You have encountered an unexpected error. Please contact the System Administrator for assistance."
Following error was captured in the "Exception Detail page
Detail 0 ## java.sql.SQLSyntaxErrorException: ORA-00904: "VIEW_ATTR": invalid identifier
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