JCP002 -1405 ORA-1405: fetched column value is NULL Fetch C_WOLINES During Revenue Recognition

Issue/Symptom/Question

An Error has been detected in the SQL Statement. JCP002 -1405 ORA-1405: fetched column value is NULL Fetch C_WOLINES

Applies To

Penta for Windows

Service Management > Setup > Service Type

Finance & Accounting > Revenue Recognition

Resolution/Fix/Answer

A new Work Order Service Type was set up and the WIP accounts were not entered. The user corrected this information and was able to run the revenue recognition.