ORA-00932 WHEN TRYING TO RETRIVE DATA FROM ECE_INO_HEADER_V (Doc ID 2281866.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle EDI Gateway - Version 12.1.3 and later
Oracle Receivables - Version 12.1.3.4 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

When trying to query   ECE_INO_HEADER_V view the following errors occurs within a 12.1.0.2 database:

1)
When using sql*plus:

SQL> SELECT * FROM ECE_INO_HEADER_V;
SELECT * FROM ECE_INO_HEADER_V
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got DATE

2)
when using sql*developer

SELECT * FROM ECE_INO_HEADER_V;
ORA-00932: inconsistent datatypes: expected NUMBER got DATE
00932. 00000 - "inconsistent datatypes: expected %s got %s"
*Cause:
*Action:
Error at Line: 1 Column: 30

The same query runs with no error in an 11.2.0.3 database.
Both are running in an E-Business Suite 12.1.3 environment.

Changes

 Database upgrade from 11.2.0.3 to 12.1.0.2

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