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 SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Sales - Version 11.1.4.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.1.5.1 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.5.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
       

Cause

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