WS: 43: WS: 00A: P00A12 SQL0012 Error - Correlation without Qualification Occurred for Column AVAN8 to Table F00A13

(Doc ID 2158117.1)

Last updated on MARCH 15, 2017

Applies to:

JD Edwards World Procurement - Version A9.4 and later
Information in this document applies to any platform.


Upon accessing Approvals Workbench (P00A12) in World A9.4, there is a system delay and informational error SQL0012 - Correlation without qualification occurred for column AVAN8 to table F00A13 is generated.

The severity of the error is a 10 and eventually the screen does display.  However, a number of cursor errors generate, such as:

Cursor CSR00A11_3 not open.
Cursor CSR00A11_1 not open

To see these behind the scenes errors follow these steps:
1. Go to menu G00A and select menu option 3.
2. Input inhibited will display for a period of time. Interrupt the job (shift/esc) and select option 10 from Display Job. Enter selection 10. Press F10 and page up. The SQL0012 will display.
3. In addition, error SQL0501 Cursor CSR00A11_3 not open generates as well in the interactive job log. To see this error, press F1 in Display Job.


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