Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)

Rama123-Oracle

Dear experts,

I have created a logical SQL analysis and created column prompt for Requisition Number and getting below error, it is displaying the results when i go to results table in analysis, not able to proceed further.. Please suggest.

Error details: (Error during query plrocessing (SQLExecDirectW).)

Attached the catalog, please suggest..

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24409/logical-sql-analysis-prompt-error-failed-to-load-error-during-query-plrocessing-sqlexecdirectw

Hi @Rama123-Oracle,

Please modify your prompt like following instead of 'All Column Values' under 'Choice List Values' use it with 'SQL Results'.

SQL to use:

SELECT    "Recruiting - Recruiting Real Time"."Job Requisition - Basic Information"."Requisition Number" s_1 FROM "Recruiting - Recruiting Real Time"

After changing as above; the results are coming without error in the Prompt.

Hope this help.

Cheers,

Hassan El Bouihi-Oracle

Hello Rama,

I checked the LOV you created and it is referring to the following:

"A"."Requisition_Number"

You may want to edit the LOV and drag and drop the correct column for the Requisition Number.

Thank you
Hassan