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 FEBRUARY 07, 2017

Applies to:

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

Symptoms


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

ERROR
__________________
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



STEPS
__________________
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.


Cause

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