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 MAY 05, 2024

Applies to:

Symptoms

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:

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

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