Error ORA-01875 on FATRACE SLA Subrequest When Running the Generate Asset Trace
(Doc ID 1468730.1)
Last updated on MAY 01, 2020
Applies to:
Oracle Assets - Version 12.1.2 and laterInformation in this document applies to any platform.
FATRACE
Symptoms
The Generate Asset Trace program completed with error in the SLA sub-request (FATRACE) and it continues to submit the sub-request infinitely.
ERROR
-----------------------
add_subscriber: Unspecified Error
ORA-01875: time zone minute must be between -59 and 59
Error: function fa_asset_trace_pkg.submit_subrequest returned failure
ORA-01875: time zone minute must be between -59 and 59
Error: function fa_asset_trace_pkg.do_trace returned failure
The issue can be reproduced at will with the following steps:
1. Run Generate Asset trace
2. The FA and SLA sub-requests complete with error and the SLA sub-request is submitted continuously.
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 |
Cause |
Solution |
Still Have Questions? |
References |