My Oracle Support Banner

NullPointerException Occurs When Uploading BEE Spreadsheet Interface With Validate Option (Doc ID 2343863.1)

Last updated on DECEMBER 11, 2023

Applies to:

Oracle Payroll - Version 12.2.1 to 12.2.8 [Release 12.2]
Oracle Payroll - Version 12.1 and later
Information in this document applies to any platform.
This note provides a brief overview of .

Symptoms

Problem Statement:

When attempting to use BEE Spreadsheet Interface to upload data with "Validate Before Upload" box checked, the following error occurs.
The issue occurs only when:

  • None of the segments in cost allocation KFF is populated.
  • When one or more of the fields in the flexfield are populated, no error occurs and able to create batch lines.
  • Able to save when creating element entry using Element Entries form. (cost allocation KFF is null).
  • Error occurs when the displayed box is unchecked for one of the segments in Cost Allocation KFF.
The upload process has completed with the following status:
- Upload processing did not complete
- Exception during parsing of upload document. java.lang.NullPointerException
Please select Close to return to the spreadsheet, fix the failed rows and reupload, or contact your system administrator for assistance.


Sample Error in BNE log

9/26/17 1:50 PM Web ADI Upload Job 3037145 ERROR
BneUploader.processUpload()%2C+fatal+exception%3A+java.lang.NullPointerExcepti
on
9/26/17 1:50 PM Web ADI Upload Job 3037145 ERROR
java.lang.NullPointerException%0A%09at+oracle.apps.bne.integrator.validators.B
neKFFValidator.validateGroup(BneKFFValidator.java%3A183)%0A%09at+oracle.apps.b
ne.integrator.upload.BneFineValidator.validateColumns(BneFineValidator.java%3A
872)%0A%09at+oracle.apps.bne.integrator.upload.BneSAXUploader.processDeepestLe
vel(BneSAXUploader.java%3A2233)%0A%09at+oracle.apps.bne.integrator.upload.BneS
AXUploader.startElement(BneSAXUploader.java%3A1176)%0A%09at+oracle.xml.parser.
v2.XMLContentHandler.startElement(XMLContentHandler.java%3A182)%0A%09at+oracle
.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java%3A159
8)%0A%09at+oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValida
tingParser.java%3A455)%0A%09at+oracle.xml.parser.v2.NonValidatingParser.parseD
ocument(NonValidatingParser.java%3A401)%0A%09at+oracle.xml.parser.v2.XMLParser
.parse(XMLParser.java%3A273)%0A%09at+oracle.apps.bne.integrator.upload.BneUplo
ader.processUpload(BneUploader.java%3A391)%0A%09at+oracle.apps.bne.integrator.
upload.BneAbstractUploader.processUpload(BneAbstractUploader.java%3A114)%0A%09
at+oracle.apps.bne.integrator.upload.async.BneAsyncUploadThread.run(BneAsyncUp
loadThread.java%3A152)%0A
9/26/17 1:50 PM Web ADI Upload Job 3037145 ERROR
Time+taken+to+BneUploader+840+milliseconds
9/26/17 1:50 PM Web ADI Upload Job 3037145 TRACE
BneOracleWebAppsContext.getUserId()+End%2C+userId+%3D+1084
9/26/17 1:50 PM Web ADI Upload Job 3037145 TRACE
XML+Generated%3A+%3Cbne%3Adocument+xmlns%3Abne%3D%22http%3A%2F%2Fwww.oracle.co
m%2Fbne%22%3E%3Cbne%3Amessage+bne%3Atype%3D%22ERROR%22+bne%3Atext%3D%22Excepti
on+during+parsing+of+upload+document%22+bne%3Acause%3D%22java.lang.NullPointer
Exception%22+bne%3Aaction%3D%22Please+contact+your+support+representative.%22+
%2F%3E%3Cbne%3Amessage+bne%3Atype%3D%22STATUS%22+bne%3Atext%3D%22Upload+proces
sing+did+not+complete%22+bne%3Avalue%3D%22%22+%2F%3E%3C%2Fbne%3Adocument%3E

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Go to BEE Spreadsheet Interface.
    •  HR responsibility
    • (N) Mass Information eXchange: MIX > BEE Spreadsheet Interface
  2.  Search for Batch Name.
  3.  Select batch name and select "Create Lines" from the list and click "Process" button.
  4.  Enter batch line information. Do not specify anything in the cost allocation KFF segments.
  5.  Check "Validate Before Upload" when uploading.
  6.  NullPointerException occurs.

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.