My Oracle Support Banner

Fusion Applications Business Intelligence - Attempt To Edit "Forecast Change Details" Analysis In Reports & Analytics Gives Error: Unable To Connect To The BI Presentation Server (Doc ID 1497946.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales - Version 11.1.4.0.0 and later
Oracle Fusion Sales Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Symptoms

You are in Fusion Applications on Reports & Analytics and are editing an analysis.  For example, the Forecast Change Details analysis.

Steps to replicate with Forecast Change Details analysis:

  1. Log in to Fusion Applications.
  2. Navigator --> Tools / Reports & Analytics.
  3. Drill through the folders as:  Sales>Analytic Library>Embedded Content>Sales Forecasting>Forecast Change Details.
  4. Click the report name and then select Edit from the short cut menu that appears.
  5. A pop-up menu appears:
    1. Warning
      Warning
      Analysis is incompatible.  Do you wish to open?
      Show Details
  6. Click Show Details and see:
    1. Hide details
      Unhandled member format in view
      Unhandled sub-total position
      Unhandled heading formatting
      Column:Revenue Item Id Unhandled Cell property format
      Column:Opportunity Unhandled Cell property format
      Column:Close Date Unhandled Cell property format
      Column:Prior Unhandled Cell property format
      Column:Prior Unhandled Cell property format
      Column:Current Unhandled Cell property format
      Unhandled XML elements/attributes: [appObjectID] criteria:[[prefix]]
  7. Click Yes to proceed. BI Composer opens.  Click next to get to the next screen.
  8. On screen error:
    1. Unable to connect to the BI Presentation Server. Please ensure that it is running, configured properly, and that the connection details within this application are correct.oracle.bi.presentation.soap.connection.BISoapException: javax.xml.ws.soap.SOAPFaultException: The current xml is invalid with the following errors: Bad xml instance! "Customer"."Customer Row ID"CustomerCustomer Row ID"Sales Forecast"."Forecast Type Code"Sales ForecastForecast Type Code"Opportunity"."Opportunity ID"OpportunityOpportunity ID"Forecast Item"."Revenue Item Id"Forecast ItemRevenue Item Id"Opportunity"."Opportunity Name"ADF Contextual Event__ADFContextualEvent__JScriptADF Contextual EventForecast ItemOpportunity"Territory"."Territory"Forecast ItemTerritory"Territory"."Territory Owner"Forecast ItemOwner"Customer"."Customer Unique Name"ADF Contextual Event__ADFContextualEvent__JScriptADF Contextual EventForecast ItemSales Account"Product"."Product Name"Forecast ItemProduct Group"Time"."Date"Revenue ItemClose Date"Forecast Item"."Revenue Item Status Name"Revenue ItemStatusFILTER("Revenue Forecast Facts"."Unadjusted Forecast" USING("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Previous"]}{'06-12'}))Unadjusted ForecastPriorFILTER("Revenue Forecast Facts"."Unadjusted Forecast" USING("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Current"]}{'2012 - 2012/01/29'}))Unadjusted ForecastCurrentFILTER("Revenue Forecast Facts"."Item Adjusted Forecast" USING("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Previous"]}{'06-12'}))Adjusted ForecastPriorFILTER("Revenue Forecast Facts"."Item Adjusted Forecast" USING("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Current"]}{'2012 - 2012/01/29'}))Adjusted ForecastCurrentifnull(FILTER("Revenue Forecast Facts"."Item Adjusted Forecast" USING("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Current"]}{'2012'})),0) - ifnull(FILTER("Revenue Forecast Facts"."Item Adjusted Forecast" USING ("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Previous"]}{'2011'})),0)Adjusted ForecastAdjusted Change AmountCASE WHEN (FILTER("Revenue Forecast Facts"."Item Adjusted Forecast" USING("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Previous"]}{'2011'})) IS NULL) THEN 'Added' WHEN (FILTER("Revenue Forecast Facts"."Item Adjusted Forecast" USING("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Current"]}{'2012'})) IS NULL) THEN 'Removed' WHEN (FILTER("Revenue Forecast Facts"."Item Adjusted Forecast" USING("Sales Forecast"."Forecast Name" = @{variables["Forecast Name Previous"]}{'2011'})) = FILTER("Revenue Forecast Facts"."Item Adjusted Forecast" USING("Sales Forecast"."Forecast Name"= @{variables["Forecast Name Current"]}{'2012'}))) THEN 'Unchanged' ELSE 'Changed' ENDAdjusted ForecastChange Type"Sales Forecast"."Sales Forecast Row ID""Territory"."Territory Id""Customer"."Customer Row ID""Sales Foreca
       

Changes

 

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