ORA-00904: "SUGGESTED_BUYER_ID" Invalid Identifier When Autocreating PO (Doc ID 371293.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version: 11.5.10.2 to 11.5.10.4 - Release: 11.5 to 11.5
Information in this document applies to any platform.
FORM:POXBWVRP.FMB - AutoCreate Documents GUI

Symptoms

On 11.5.10.2, some Bbuyers cannot autocreate purchase orders from buyer purchasing responsibility due to the following error:

ORA-00904: "PO_REQUISITION_LINES_INQ_V"."SUGGESTED_BUYER_ID": invalid identifier.
FRM-40505: ORACLE error: unable to perform query.


STEPS
Purchasing Buyer responsibility
1. Autocreate -> Open-> Find
2. Autocreate -> Open -> enter an approved purchase requisition number -> Find

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