Error or Warning Message

When an user runs UKO030 Automatic Pass the error is shown in Spooled Output:

UKP030: INFO Processing file – dvi1718_23-OCT-2017.hmv

INFO: File validation complete

UKP030 Oracle Error Encountered

UKP030 SQL-02112 SELECT..INTO returns too many rows

This error occurred in Function: get_section_label

Solution

Connect into Oracle database and run the sql command:

select * from ukpms_sect_label;

there must be only one row/record in the output of this command, if there is more than one record please, remove the redundant record.

Original Author:

Renatas