Procurement - EBS (MOSC)

MOSC Banner

Bulk Loading BPAs in R12

edited May 7, 2013 12:43PM in Procurement - EBS (MOSC) 1 commentAnswered ✓
Hello,
I was wondering if anyone knows the maximum number of lines within a .txt file or file size that should be bulk loaded? I tried to bulk load a file (with 60k lines or 19mb), but the concurrent program errored with the following: 

Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
	at java.lang.reflect.Array.newArray(Native Method)
	at java.lang.reflect.Array.newInstance(Array.java:52)
	at oracle.jdbc.driver.BufferCache.get(BufferCache.java:212)
	at oracle.jdbc.driver.PhysicalConnection.getByteBuffer(PhysicalConnection.java:7409)
	at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2792)
	at oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3749)
	at oracle.jdbc.driver.OraclePreparedStatement.alwaysOnClose(OraclePreparedStatement.java:10357)
	at oracle.jdbc.driver.OraclePreparedStatement.enterImplicitCache(OraclePreparedStatement.java:3114)
	at oracle.jdbc.driver.LRUStatementCache.addToImplicitCache(LRUStatementCache.java:238)
	at oracle.jdbc.driver.PhysicalConnection.cacheImplicitStatement(PhysicalConnection.java:7231)
	at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1574)
	at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1541)
	at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:77)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:78)
	at oracle.apps.icx.icatalog.loader.sql.JDBCDataLoader.processItemBatch(JDBCDataLoader.java:552)
	at oracle.apps.icx.icatalog.loader.sql.JDBCDataLoader.process(JDBCDataLoader.java:249)
	at oracle.apps.icx.icatalog.loader.processors.ItemElementProcessor.process(ItemElementProcessor.java:115)
	at oracle.apps.icx.icatalog.loader.handlers.ItemLineHandler.endLine(ItemLineHandler.java:456)
	at oracle.apps.icx.icatalog.loader.parsers.DataTXTParser.parse(DataTXTParser.java:90)
	at oracle.apps.icx.icatalog.loader.CatalogTXTLoaderBase.processJob(CatalogTXTLoaderBase.java:42)
	at oracle.apps.icx.icatalog.loader.CatalogLoaderBase.service(CatalogLoaderBase.java:141)
	at oracle.apps.icx.icatalog.loader.LoadRequest.start(LoadRequest.java:111)
	at oracle.apps.icx.icatalog.loader.LoadRequest.runProgram(LoadRequest.java:46)
	at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center