Maintenance Work Order Detail Report Produces Error ORA-20100 (Doc ID 1930025.1)

Last updated on AUGUST 20, 2016

Applies to:

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

Symptoms

When attempting to run the Maintenance Work Order Detail Report for range of work orders, the following error occurs.
The issue is not reproducible at will. The report has always completed successfully when printing work orders individually.


ERROR

ORA-20100: FND_FILE could not write to file o0048479.tmp.
An operation system error occurred during the write permission.
Contact your system administrator.


STEPS

The issue can be reproduced at will with the following example:

1. Responsibility: Enterprise Asset Management
2. Navigation: Reports
3. Name = Maintenance Work Order Detail Report
4. Enter parameters as shown in the example below:
  Work Order From = 2456
  To = 2457
  Display Operation = Yes
  Display Resources = Yes
  Display Materials = Yes
  Display Direct Items = Yes
  Display Work Request = Yes
  Display Meters = Yes
  Display Quality Plans = No
5. Click Ok
6. Select Options
7. Select Oracle seeded Template – Maintenance Work Order Report
8. Click on OK
9. Click on Submit
10. View Requests – Returns the above error.
11. Now, run the report for each work order individually (instead of range of work orders):
     Example:
     Work Order From = 2456
     To = 2456
12. Report completes normally.


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