Encountered Unexpected Exception When Sorting 'Item/Job' Column in Buyer Work Center

(Doc ID 2356924.1)

Last updated on FEBRUARY 03, 2018

Applies to:

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

Goal

Encountered "You have encountered an unexpected error. Please contact the System Administrator for assistance." error when sorting 'Item/Job' column in Buyer work center.

Reproducible Steps

  1. Enable sorting feature for column via Personalization for column 'Item/Job'
  2. Navigate to Buyer Work Center > Requisition > Demand Workbench
  3. Search Requisitions lines
  4. 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

Solution

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