Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Jennifer Bruce
    Trial Balance report ends in error and no report is...
    Topic posted July 27, 2018 by Jennifer BruceBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Financial reporting, Public Sector, Reports 
    248 Views, 5 Comments
    Title:
    Trial Balance report ends in error and no report is generated
    Summary:
    Trial Balance report ends in error and no report is generated
    Content:

    Hi All

     

    We regularly run the Trial Balance report for the entire financial year from scheduled processes - this is a key report for my accountants, and one that our external auditors expect to receive as part of the audit working papers.  We have been using this report since 2014, when we went live on R7, and it is still working in our R12 production environment.  Test and Development have both been upgraded to R13, and the report has stopped running - ending in an error:

     

    dummy file is deleted

    ================ BIPJobExecutable Execution Started ============

    OutputFile : /u01/APPLTOP/instance/ess/rfd/365383/out/365383.xml

    Request ID: 365383 ClassLoader is weblogic.utils.classloaders.GenericClassLoader@4aab1ba3 finder: weblogic.utils.classloaders.CodeGenClassFinder@23c7912b annotation: ORA_FSCM_ESSAPP#V2.0.[00]JPTmSFPcPT63tKHTWqqe0Q]]@

    RequestId:365383

    ReportID : /Financials/General Ledger/Trial Balances/TrialBalance.xdo

    Skip : Notify

    The bipJobID : 3170

    bipJobID is updated to ESSRuntimeService

    BIP_STATUS_URL is added to ESSRuntimeService

    ================ BIPJobExecutable is running in async mode. ============

    ================ Please check the ess status for more detail info. ============

     

    I've raised an SR to try and get this resolved, but has anyone out there hit this problem, and how was it resolved?  Support have asked me to try increasing the SQL timeout value in the data model, but as this is a preseeded report, Fusion won't retain the change.  The process successfully runs for just a period, but we need this for a full financial year.

     

    Any help gratefully received as we are upgrading Prod this weekend, and I somehow need to get this report running by Monday morning

    Thanks in advance,

    Jenny

    Comment

     

    • Mark daynes

      Hi Jenny,

      As it works for a smaller quantity of data then it does sound like it's possibly hitting the timeout.  Have you tried scheduling the report when minimal transactional activity is occuring?

      Regards,

      Mark

    • Jennifer Bruce

      Hi Mark

       

      Yes, I've tried running it in my Dev environment, where I am the only person with a log in, and it fails there.  Worked fine in R12 with exactly the same amount of data...

       

      Regards

      Jenny

    • Mark daynes

      Jenny, Ah, OK - I was just thinking that perhaps you had a team concurrently doing a load of reconciliation activity that was perhaps having an impact.  It does look like timeout but obviously I can't see your system.  However if the upgrade is actually happening right now then you may well find out that it runs fine in production.

      Mark

    • sameer ashturkar

      Hi ,

      I am also getting same error while running the Trial Balance Report .

      dummy file is deleted
      ================ BIPJobExecutable Execution Started ============
      OutputFile : /u01/APPLTOP/instance/ess/rfd/1356259/out/1356259.xml
      Request ID: 1356259 ClassLoader is weblogic.utils.classloaders.GenericClassLoader@26103129 finder: weblogic.utils.classloaders.CodeGenClassFinder@69d5da69 annotation: ORA_FSCM_ESSAPP#V2.0.[00]C1[9JwP++fLHRzN6a3FfcQ]]@
      RequestId:1356259
      ReportID : /Financials/General Ledger/Trial Balances/TrialBalance.xdo
      The bipJobID : 109485
      bipJobID is updated to ESSRuntimeService
      BIP_STATUS_URL is added to ESSRuntimeService
      ================ BIPJobExecutable is running in async mode. ============
      ================ Please check the ess status for more detail info. ============

       

      Oracle provided Doc ID 2365849.1 won't useful. i hope, already some one attmped this error.

       

    • sameer ashturkar

      Hi Jenny ,

      Do you have any update on this from oracle. ? Did you hit this issue ? if yes then please share with us it would be great help.

       

      Thanks,
      Sam.