My Oracle Support Banner

Generate Asset Trace Errors with FA_ASSET_TRACE_PVT.GET_SYSTEM_OPTIONS and ORA-06502 (Doc ID 1677657.1)

Last updated on MAY 18, 2021

Applies to:

Oracle Assets - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Asset Trace - FATRACE program, errors with below message in the LOG:

fa_asset_trace_pvt.get_system_options: Error
fa_asset_trace_pub.run_trace: OTHERS Exception
ORA-06502: PL/SQL: numeric or value error
Error: function fa_asset_trace_pkg.do_trace returned failure

Steps to Replicate

From Oracle Assets, Menu:  Other>Requests>Run

1.  Select Single Request

2.  Pick Generate Asset Trace and enter parameter, submit

3.  Error is seen in log.

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
References


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