Error "java.lang.NullPointerException" While Uploading The Data Using ANY Integrator.

(Doc ID 1942288.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

Oracle Web Applications Desktop Integrator - Version 11.5.10.2 to 12.2.3 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

Cannot upload the data using the Web ADI Integrators like Assets, GL etc.
Using Excel 2013 (also occurs with 2010), and trying to upload the Journal or other integrators via Web ADI.
At the time of upload the following error occurs:
The upload process has completed with errors. Press Close to return to the document and fix the errors.

- Upload processing did not complete
- Exception during parsing of upload document. java.lang.NullPointerException


The problem occurs even when the number of lines is 2.

Unable to do any uploads.


Testing with Desktop Integration responsibility.
Functional Actuals - Multiple
Document created ok,
Copies data into spread sheet from another spreadsheet.
validates
Uploads and it errors.


Excel session hung and have to use the Windows Task Manager to kill the excel session.


bne.log shows:

...

6/25/13 2:03 PM DETAIL Mapping query: SELECT LOOKUP_CODE,DESCRIPTION,DESCRIPTION FROM GL_LOOKUPS WHERE DESCRIPTION = ? AND LOOKUP_TYPE = 'BATCH_TYPE'
6/25/13 2:03 PM TRACE Mapper! Column name: GL_INTERFACE.ACTUAL_FLAG new value: A
6/25/13 2:03 PM TRACE BneSAXUploader.saveLineMessages(), enter method, element: line
6/25/13 2:03 PM TRACE BneSAXUploader.saveLineMessages(), columnIdx: 1
6/25/13 2:03 PM TRACE BneSAXUploader.saveLineMessages(), exit method
6/25/13 2:03 PM TRACE BneSAXUploader, calling BneCoarseValidator.validateDatatypes
6/25/13 2:03 PM CRITICAL ERROR BneUploader.processUpload(), fatal exception:java.lang.NullPointerException
6/25/13 2:03 PM CRITICAL ERROR java.lang.NullPointerException
at java.lang.String.getBytes(String.java:1058)
at oracle.apps.bne.integrator.upload.BneUploadColumn.setColumnValue(BneUploadColumn.java:482)
at oracle.apps.bne.integrator.upload.BneCoarseValidator.setColumnValueByRules(BneCoarseValidator.java:258)
at ...
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadThread.run(BneAsyncUploadThread.java:141)
6/25/13 2:03 PM CRITICAL ERROR BneUploader::Exception - going to tollback
6/25/13 2:03 PM TRACE XML Generated: <bne:document xmlns:bne="http://www.oracle.com/bne"><bne:message bne:type="ERROR"
bne:text="Exception during parsing of upload document"
bne:cause="java.lang.NullPointerException" bne:action="Please contact your support representative." /><bne:message bne:type="STATUS" bne:text="Upload processing did not complete" bne:value="" /></bne:document>
...

 

 

 

 

Changes

 Fresh install.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms