Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-00932: inconsistent datatypes: expected DATE got NUMBER in SQL data model per KM 2888420.1

edited Sep 27, 2024 11:47AM in Costing 1 comment

Summary:

When trying to use the SQL provided in KM Fusion CST: SQL Running Behind Analyze Standard
Purchase Cost Variances (Doc ID 2888420.1) i am getting an error in the explain plan. Please review the SQL and Explain plan and help me resolve the issue.

This happens when I run the SQL: Analytics > Create DM> SQL Query > copy paste the SQL from KM: 2888420.1

as shown below, click on generate explain plan and get , Error Msg = ORA-00932: inconsistent datatypes: expected DATE got NUMBER

Please see uploaded explain plan and help me correct the SQL as clearly there is an issue with it and it comes from Oracle.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!