My Oracle Support Banner

Duplicate Printer APP-FND-01564: ORACLE error - 1422 in SET_PRINT_OPTIONS (Doc ID 2040789.1)

Last updated on SEPTEMBER 24, 2023

Applies to:

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


 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.”


 Upgrade from Release 11i to to Release 12


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.