My Oracle Support Banner

Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001 when NULL value is Passed Inside SUM Function (Doc ID 2154545.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.
***Checked for Currency 15-FEB-23***

Symptoms

When attempting to run the Siebel BI Publisher reports for a standard/custom template with a custom code, the report runs fine the first time but fails the second time based on the data selected. Below errors can be seen in the XMLPReportServer*.logs:

Steps to Repro:

  1. Setup Siebel BI Publisher integration and execute reports from Siebel
  2. Add a piece of code for SUM or CONCAT in one of the Siebel RTF templates and check to see if report works
  3. Check to see if the report executes consistently upon every invocation

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.