Error 'ORA-00904: "PO_HEADERS_INQ_V"."PO_HEADER_ID": invalid identifier', While Trying To Search in Purchase Orders Summary Form (Doc ID 2242074.1)

Last updated on MARCH 15, 2017

Applies to:

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

Symptoms

When attempting to search for Blanket Purchase Agreements (BPA's) using as search criteria following fields: Operating Unit,Document Type, Results zone select for Headers,  Description (enter part of description between %, the following error occurs:

Error

ORA-00904: "PO_HEADERS_INQ_V"."PO_HEADER_ID": invalid identifier

Steps to reproduce

1. Go to Purchase Order SUmmary and enter values in following  search fields: Operating Unit, Document Type, Results zone select Headers, Description
  Results : Headers
  Description: %455%
2. Press on Find button > Error occurs

Cause

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