My Oracle Support Banner

Not Able to Create Internal Sales Order on HTML Parts Screen - Document Sequence Error APP-FND-01564 Get_seq_info (Doc ID 2231339.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to create a parts order from Parts Requirement HTML page the following error occurs:

Error populated but without any error message.
FND log shows:

APP-FND-01564: ORACLE error -1422 in get_seq_info
Cause: get_seq_info failed due to ORA-01422: exact fetch returns more than requested number of rows.
The SQL statement being executed at the time of the error was: select SEQ.DOC_SEQUENCE_ID, SEQ.TYPE, SEQ.NAME and was executed from the file AFSQNUMB.pls

1. Responsibility: Service and/or Order Management Super User
2. Navigate to Parts Requirement HTML page.
3. Enter the header and line details and try to save.
4. Error populated without any error message.


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.