FA: SCM: OM: Querying Sales Orders Fails With: ORA-00904: "PARTYPEO"."STATUS": Invalid Identifier (Doc ID 2493062.1)

Last updated on JUNE 26, 2020

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Enter the goal of the document. What does the customer want to accomplish?

An Error is reported when querying a Sales Order, the user has a custom role assigned. This role is an Inquiry only role.

ORA-00904: "PARTYPEO"."STATUS": invalid identifier

Order details are returned, however the sold to customer information is blank.

	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

Goal

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