My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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

Goal

Intermittent problem with 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 4 lines of a large batch (some 800 lines on one occasion) loaded then the Exception Name>Fatal Exception error is seen. Records that fail to load are NOT being shown as errors.

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
  2. Create Batch Header in Monthly Batch Header
  3. Open BEE Spreadsheet Interface
  4. Search for batch header>Click on Create Lines>Process>Element = PAYE Details
  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 GB-PAYE 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.