Unable To Search Assets Using 'Vendor Name', or 'Invoice Number', or 'Purchase Order' as Search Criterias (Doc ID 1458734.1)

Last updated on AUGUST 01, 2022

Applies to:

Symptoms

When attempting to perform an advanced search in Fixed Assets tab of Asset Tracking module using either Vendor Name, or Invoice Number, or Purchase Order as search criteria the following error occurs.

ERROR
-----------------------
"java.sql.SQLSyntaxErrorException: ORA-00904: "PPA"."PO_VENDOR_ID": invalid identifier"
or
"java.sql.SQLSyntaxErrorException: ORA-00904: "PPA"."INVOICE_ID": invalid identifier"
or
"java.sql.SQLSyntaxErrorException: ORA-00904: "PPA"."PO_NUMBER": invalid identifier"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (R) Asset Tracking responsibility
2. Navigate to (N) Item Instance > Fixed Assets tab
3. Press on Advanced Search button
4. Add Vendor Name, or Invoice Number, or Purchase Order as an additional search criteria
5. Perform a search by providing a value to the recently added field. Getting error.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.