Running BIP Report Gives Error: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo11g.xqxp.XQException: FORG0001

(Doc ID 2360623.1)

Last updated on FEBRUARY 13, 2018

Applies to:

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

Symptoms

On : 11.13.17.11.0 version, Analytics

When Running BIP report it gives error

Issue is only happening when BIP report is run. Underlying data model is showing correct data when that opportunity is queried
Customer is passing opportunity ID as a parameter

BIP report is based on logical SQL


ERROR
-----------------------
Error: (screen shot attached)
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo11g.xqxp.XQException: FORG0001

Error 2:
unable to write Parameter value in Data Model.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Customer runs the report through Opportunity, and it gives this error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run this report for particular opportunity

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