My Oracle Support Banner

When Attempting to Query Service Items, "ORA-00904: Invalid Identifier" Error is Thrown with "No Service Items Exist" Message (Doc ID 1576042.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Retail Point-of-Service - Version 13.4.5 and later
Information in this document applies to any platform.

Symptoms

When the user attempts to query Service Items, a SQL "ORA-00904: "ITM"."TY_ITM": invalid identifier" is thrown.

 

Steps to Reproduce:

1. Navigation: F3 POS => F4 Item => F7 Services.
2. POS produces the message: "No Service Items exist."

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
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.