My Oracle Support Banner

Intermittent Problems With BEE Spreadsheet Interface On Creation And Loading (Doc ID 858177.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Payroll - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

Intermittent problem with Batch Element Entry (BEE) Spreadsheet Interface both with creation of the batch and uploading it to Oracle.  Several attempts to load a batch loads 1 line successfully and then the server connection error message is seen. Subsequent attempts to load, see a further few lines of a large batch loaded then the Exception Name>Fatal Exception error is seen. Records that fail to load are NOT being shown as errors.

Example of messages found in the log file:

"5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Error trying to check whether the job will be importing.
5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Parameter value is not a Boolean.
5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Error trying to check whether the job will be importing.
5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Parameter value is not a Boolean.
5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Error trying to check whether the job will be importing.
5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Parameter value is not a Boolean.
5/11/09 3:26 PM ERROR BneRequiredValidator.generateOverrideValues() method: Error occured while attempting to generate an override value. Nested Exception, Level 0:
Stack Trace:
oracle.apps.bne.exception.BneInvalidException: Make sure that you enter a valid assignment.
at oracle.apps.pay.ssloader.bee.validators.PayBeeAssignmentIdGenerator.process(PayBeeAssignmentIdGenerator.java:231)
at oracle.apps.bne.integrator.validators.BneDefaultValueGenerator.process(BneDefaultValueGenerator.java:136)
at oracle.apps.bne.integrator.upload.BneRequiredValidator.generateOverrideValues(BneRequiredValidator.java:778)
at oracle.apps.bne.integrator.upload.BneSAXUploader.processDeepestLevel(BneSAXUploader.java:2154)
at oracle.apps.bne.integrator.upload.BneSAXUploader.startElement(BneSAXUploader.java:1178)
..........
at oracle.apps.bne.integrator.upload.BneAbstractUploader.processUpload(BneAbstractUploader.java:109)
at oracle.apps.bne.integrator.upload.async.BneAsyncUploadThread.run(BneAsyncUploadThread.java:141)

5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Error trying to check whether the job will be importing.
5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Parameter value is not a Boolean.
5/11/09 3:26 PM ERROR BneAsyncUploadPage.renderPage Error trying to check whether the job will be importing."


The issue occurs from time to time and no matter of the number of lines (10 or 100).

Steps To Reproduce:

  1. Payroll Manager responsibility
  2. Create Batch Header in Monthly Batch Header
  3. Open BEE Spreadsheet Interface
  4. Search for batch header > Click on Create Lines > Process > Element = <ELEMENT NAME>
  5. Wait for batch to be created>Unprotect Sheet>Add additional lines into the middle of the spreadsheet
  6. Update sheet with Date>Assignment Number>Tax Code>Tax Basis>Pay Previous> Tax Previous>Refundable=YES>Authority=SOY
  7. Copy <VALUE> into added lines
  8. Click on Oracle>Upload>Select Tagged Lines for Upload

How can this be overcome?

Solution

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
Goal
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.