Work Order Report Fails with "An error encountered either due to invalid Template details or due to null Data Input Stream" or EAM_WORKORDERREP_PVT is INVALID (Doc ID 2190812.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, REP

When attempting to run Work Order Report from Maintenance Super User Responsibility, the following error occurs.

ERROR

"An error encountered either due to invalid Template details or due to null Data Input Stream"

STEPS

The issue can be reproduced at will with the following steps:
1. Responsibility: Maintenance Super User
2. Navigation: Work Orders -> All
3. Query Work Orders
4. Select Work Orders and Click on Print Work Order Button
5. Select Operations check flag, Format : PDF , Locale : English, Template : Maintenance Work Order Report
6. Click on Run Button -> Above error is displayed

Others symptoms/issues that are related:

1). Check the package body EAM_WORKORDERREP_PVT (EAMVWRPB.pls)  in INVALID status. And package compilation fails with below errors:

APPS EAM_WORKORDERREP_PVT PACKAGE BODY 1 1215 17 PL/SQL: ORA-00932: inconsistent datatypes: expected LONG BINARY got CLOB ERROR 0
APPS EAM_WORKORDERREP_PVT PACKAGE BODY 2 1214 5 PL/SQL: SQL Statement ignored ERROR 0
APPS EAM_WORKORDERREP_PVT PACKAGE BODY 3 1233 58 PL/SQL: ORA-00932: inconsistent datatypes: expected LONG BINARY got CLOB ERROR 0
APPS EAM_WORKORDERREP_PVT PACKAGE BODY 4 1233 4 PL/SQL: SQL Statement ignored ERROR 0

2). Use below query to check data type of LONG_TEXT column of FND_DOCUMENTS_LONG_TEXT table to be "CLOB" (instead of "LONG")

     DESC FND_DOCUMENTS_LONG_TEXT ;

Changes

 ATG patch : 22630717:R12.FND.B introduced Data type change for LONG_TEXT column of FND_DOCUMENTS_LONG_TEXT table from "LONG" to "CLOB"

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