Auto Invoice import doc fdssop failed due to ORA-01422

Hi,

I get Auto Invoice import failure due to the following error.

'

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 '