Autoinvoice Import Program is completing in error -"ORACLE error 1422 in fdssop"
(Doc ID 3015029.1)
Last updated on MAY 20, 2024
Applies to:
Oracle Receivables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Autoinvoice Import Program is completing in error.
Cause: fdssop 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.NAME, SEQ.TYPE, SEQ.AUDIT_TABLE_NAME, SEQ.DB_SEQUENCE_NAME, SEQ.TABLE_NAME, SA.DOC_SEQUENCE_ASSIGNMENT_ID, SEQ.MESSAGE_FLAG, nvl(to_number(to_char(SA.START_DATE,'J')),-1), nvl(to_number(to_char(SA.END_DATE,'J')),-1), decode(sign(nvl(to_char(trunc(SEQ.START_DATE),'J'), :trx_date)- :trx_date), 1,'N', decode(sign(:trx_date- nvl(to_char(trunc(SEQ.END_DATE),'J'), :trx_date)), 1,'N', 'Y')) from FND_DOCUMENT_SEQUENCES SEQ, FND_DOC_SEQUENCE_ASSIGNMENTS SA where SEQ.DOC_SEQUENCE_ID = SA.DOC_SEQUENCE_ID and SA.APPLICATION_ID = :applid and SA.CATEGORY_CODE = :cat_code and (SA.SET_OF_BOOKS_ID = :sobid or SA.SET_OF_BOOKS_ID is NULL) and (SA.METHOD_CODE = :met_code or SA.METHOD_CODE is NULL) and to_date( :trx_date, 'J' ) between SA.START_DATE and nvl(SA.END_DATE, to_date( :trx_date, 'J' ))+.9999 and was executed from the file &ERRFILE.
Error calling fdssop()
Error calling raavdn()
Error calling raapic()
Responsibility: Receivables Manager
Navigation: Interfaces > AutoInvoice
1. Run the AutoInvoice Master Program.
2. Provide the required parameter.
3. Submit the request.
Cause
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
Symptoms |
Cause |
Solution |