My Oracle Support Banner

EAM9.2:Adding an Asset with Project Chartfield Returns Errors: 'ORA-00942:table or view does not exist' and 'SQL error in Exec'. (Doc ID 2702298.1)

Last updated on AUGUST 19, 2020

Applies to:

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

Symptoms

Adding an Asset with Project Chartfield, when Project Costing Integration disabled, results to errors:


Steps to replicate:
1.  Navigate to Project Costing > Project Definition > General Information - Asset Integration Rules tab, and deselect 'Enable Integration' option.
2.  Navigate to Asset Management > Asset Transaction > Owned Assets > Basic Add to add an Asset.
     Under 'Asset Acquisition Detail' tab, click 'Acquisition Detail Chartfields' and enter CF values, including Project ID.
3.  Then, click Capitalize button.

Changes

 

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
Changes
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.