EAM: Asset Cost Adjust/Transfer Page Timeout Error on COST_BAL_DVW.IU_MAP_KEY

(Doc ID 1669653.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

In release 9.1, MP8/bundle #16 production, after going to the Asset Cost adjust/transfer page to select an existing 57,000 row asset, the following message occurs:

Assignment of "1000" to COST_BAL_DVW.IU_MAP_KEY failed. (2,119)
COST_BAL_DVW.IU_MAP_KEY.RowInit PCPC:73 Statement:2

The assignment to the specified field failed.

Business impact:
We are unable to create any cost related transactions against this asset (e.g adjustment, recat, transfer).

Steps to replicate:
1. Create an asset from PC to AM over time which has 57,000 ADD or ADJ rows.
2. Go to AM, Asset Transactions, Financial Transactions, Cost adjust/transfer asset.

Find an existing value: BU T7901

Asset RWALLOCATE

After the Search button is selected, the above message appears.

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