My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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