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 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!