Duplicate Printer APP-FND-01564: ORACLE error - 1422 in SET_PRINT_OPTIONS

(Doc ID 2040789.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Concurrent Processing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

 In Oracle Applications Release 11i, duplicate printer names can be created with mixed case lettering, such as "NoPrint" and the seeded "noprint". Both printer names work without error, however. When upgrading to E-Business Suite (EBS) Release 12, selecting a duplicate printer name returns the following error message:

 
“APP-FND-01564: ORACLE error - 1422 in SET_PRINT_OPTIONS

Cause: SET_PRINT_OPTIONS failed due to ORA-01422: exact
fetch returns more than requested number of rows.”

Changes

 Upgrade from Release 11i to to Release 12

Cause

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