Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open

After upgrade during Data Loading using Java Program we got the error :

Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open
cursors exceeded

The Concurrent for Importing the items errored out. The log file of the concurrent is


+---------------------------------------------------------------------------+
Inventory: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
INCOIN module: Import Items
+---------------------------------------------------------------------------+
Current system time is 22-JUL-2009 11:04:39
+---------------------------------------------------------------------------+
**Starts**22-JUL-2009 11:04:40
**Ends**22-JUL-2009 11:05:25
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Import Items
--------------------------------------------------------------------------------
Argument 1 (ORG_ID) =
Argument 2 (ALL_ORG) = 1
Argument 3 (VAL_ITEM_FLAG) = 1
Argument 4 (PRO_ITEM_FLAG) = 1
Argument 5 (DEL_REC_FLAG) = 1
Argument 6 (PROCESS_SET) = 1001
Argument 7 (MODE) = 1
--------------------------------------------------------------------------------
************************************
TRANSACTION ID : 13652
ORGANIZATION ID : 103
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME :
MESSAGE NAME : BOM_PARSE_ITEM_ERROR
ERROR MESSAGE :
************************************
TRANSACTION ID : -1
ORGANIZATION ID : -1
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME :
MESSAGE NAME : INV_IOI_ERR
ERROR MESSAGE : *** BAD RETURN CODE b ***
************************************
TRANSACTION ID : -1
ORGANIZATION ID : -1
TABLE NAME : ENI_OLTP_ITEM_STAR
COLUMN NAME :
MESSAGE NAME : INV_IOI_ERR
ERROR MESSAGE : FND+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
ORACLE error 1000 in AFPRSR
Cause: AFPRSR failed due to ORA-01000: maximum open cursors exceeded
.
The SQL statement being executed at the time of the error was: and was executed from the file .
ORA-01000: maximum open cursors exceeded
Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open cursors exceeded

Contact your system administrator or support representative.
Shutting down Concurrent Manager : 22-JUL-2009 11:05:25
ORACLE error 1000 in AFPRSR
Cause: AFPRSR failed due to ORA-01000: maximum open cursors exceeded
.
The SQL statement being executed at the time of the error was: select FND_CONC_PRIVATE_UTILS.get_resub_time(:b0) into :b1:b2 from DU and w
List of errors encountered:
.............................................................................
_ 1 _
Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open
cursors exceeded

Contact your system administrator or support representative.
_ 2 _
Routine AFPPRD has encountered a fatal error. ORA-01000: maximum open
cursors exceeded

Contact your system administrator or support representative.
.............................................................................


As per the Metalink advise, we increased the open_cursors to double the value, still no improvement.
We were restricted to load the data only upto 1500 records at a stretch.

We fixed the problem like this
1. Identify the tablespace and datafile the table is residing in.
2. Add a datafile in the tablespace. (in my case the MTL_Tables were residing in APPS_TS_INTERFACE

3. The error resolved.