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

Last updated on JANUARY 12, 2017

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

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