EBS on Oracle Cloud Infrastructure (MOSC)

MOSC Banner

Getting WebADI Create Document Error "Cannot Execute SQL Statement"

Hello Team,

Need your assistance.

We are creating a new WebADI where data will get downloaded in the WebADI in create document step so that user can work on that data, We are getting Error "Cannot Execute SQL Statement" in WebADI Create Document step while using parameters list of Date type in WebADI content section, when we hard-code the Date in where clause of select statement the WebADI document got generated hence there is an issue while using the date parameter from parameter list.

Please guide how we can use the date parameter of parameter list in WebADI to download the data from Oracle using select query so that user can work on that data.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center