EAM: The Process AMIF1000 Invoked By The AMREVAL Returns No Success. (Doc ID 2006150.1)

Last updated on OCTOBER 10, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Upon submitting the Mass Revaluation at Asset Management > Asset Transactions > Financials Transactions > Revaluation in Mass, process AMIF1000 which is invoked by AMREVAL returns no success.

Error
----------
Stmt #: 1703  Error Position: 12  Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: INSERT INTO PS_AMIF_CT_TAO1 (PROCESS_INSTANCE, BUSINESS_UNIT, ASSET_ID, BOOK, INTFC_ID, INTFC_LINE_NUM, CT_COST) SELECT A.PROCESS_INSTANCE, A.BUSINESS_UNIT, A.ASSET_ID, ' ', A.INTFC_ID, A.INTFC_LINE_NUM, A.CT_COST FROM PS_AMIF_IPA_TMP4 A WHERE A.PROCESS_INSTANCE = 41499 AND A.CAP_THRSHLD_ID <> ' ' AND A.CAP_THR_ACTION = 'UNK'

Process 41499 ABENDED at Step AMIF1000.400200.Step55 (SQL) -- RC = 942 (108,524)

Steps
-------------
This issue can be replicated by performing the following step:

1. Navigate to Asset Management > Asset Transactions > Financials Transactions > Revaluation in Mass.
2. Enter the run the control parameters & click the run button.
3. Select Mass Revaluation and click OK.

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