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:
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
STEPS TO REPRODUCE
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