Not Able to Create Internal Sales Order on HTML Parts Screen - Document Sequence Error APP-FND-01564 Get_seq_info
Last updated on MAY 15, 2018
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
The issue can be reproduced at will with the following steps:
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.
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