Reports Produced By BI Publisher Connected To Agile PLM Have No Content (Doc ID 1622216.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.1.2 to 9.3.1.2 [Release 9.3]
Information in this document applies to any platform.

Symptoms

Reports produced by BI Publisher connected to Agile PLM have no content.
Can see below error in stderr.log:

Error
oracle.xml.parser.v2.XPathException: Namespace prefix 'ref' used but not declared.
at oracle.xml.parser.v2.XSLBuilder.startElement(XSLBuilder.java:419)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1224)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:311)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:278)

 

Steps to Reproduce

  1. Create RTF template using BI Publisher
  2. Log into Java Client as an Admin
  3. Go to Admin | Server Settings | Preferences and set Enable BI Publisher for Reports to Yes.
  4. Goto Admin | User Settings | Privileges | Administrator, and open Administrator privilege. Make sure "Manage Report Templates" is included in Applied To fields
  5. Log into Web Client
  6. Click Tools and Settings -> Administration -> Report Templates
  7. Select Report Name: Manufacturer BOM Report
  8. Create
  9. Select the problem RTF template for File, and Name it as "Test-Report" and OK
  10. Close
  11. Goto Reports->Standard Reports->Product Reports->Manufacturing BOM Reports
  12. Click Execute
  13. Select "Test-Report" as Layout
  14. Select Output Format: Excel
  15. Select the item object with BOM
  16. Click Finish button, and check the outputted Excel file.
  17. See the file is 0 kb. If you open the file, it shows blank

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