RXFAWD - RX-only: What-If Depreciation Analysis Report Ends With ORA-6500 ORA-4031 or ORA-04030 When Run for a Large Number of Assets (Doc ID 331487.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Assets - Version 11.5.10.2 and later
Information in this document applies to any platform.
RXFAWD - RX-only: What-If Depreciation Analysis report

Symptoms

The RX-only: What-If Depreciation Analysis Report terminates with error:

ORA-6500: PL/SQL: storage error
Error: function fa_cde_pkg.faxcde returned failure

...or with the error:

ORA-04030: out of process memory when trying to allocate 64084 bytes (session
heap,frame segment)
Error selecting FA_BOOKS information for asset_id ...
Error calling What-If Engine in Normal mode for asset_id ...



If only a group of assets is selected or one category, the report completes successfully.
If run for all assets and for several periods, the report errors.

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