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

BI publisher report SQL error ; joining INV_TXN_REQUEST_HEADERS

edited Mar 12, 2025 2:24AM in Reporting and Analytics for SCM 1 comment

I'm creating report SQL, but when I executed the SQL I got an error.
When I executed the SQL I got an error.
There were no errors before I joined INV_TXN_REQUEST_HEADERS.
So I test with just two tables, WSH_DELIVERY_DETAILS and INV_TXN_REQUEST_HEADERS,
and it is not occured.
I don't get it why the error happened.

Here is my report SQL, test SQL, and screenshot.

[Add]

I figured out it comes from different datatype, but I don't know which column should I use for joining WSH_DELIVERY_DETAILS and INV_TXN_REQUEST_HEADERS.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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