AGIS stuck

+---------------------------------------------------------------------------+ Financials Common Modules: Version : 12.0.0 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. XXIM_XFER_TO_AGIS module: XXIM Transfer to AGIS Interface +---------------------------------------------------------------------------+ Current system time is 04-DEC-2013 08:00:11 +---------------------------------------------------------------------------+ **Starts**04-DEC-2013 08:00:11 ORACLE error 20100 in FDPSTP Cause: FDPSTP failed due to ORA-20100: main@Update APPS.XXIM_GL_INTERFACE_AGIS starting: ORA-20100: get_initiator_ccid@declare: ORA-20100: get_recipient_id@declare: ORA-20100: get_set_of_books_by_location@Fetching for p_locat +---------------------------------------------------------------------------+ Start of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ End of log messages from FND_FILE +---------------------------------------------------------------------------+ +---------------------------------------------------------------------------+ Executing request completion options... Finished executing request completion options. +---------------------------------------------------------------------------+ Concurrent request completed Current system time is 04-DEC-2013 08:00:11 +---------------------------------------------------------------------------+