My Oracle Support Banner

EAM: Ran What If Depreciation Job And Went Into Error (Doc ID 1625598.1)

Last updated on FEBRUARY 12, 2019

Applies to:

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

Symptoms

When running the What If Scenario to change the Depreciation Method to Straight Line for assets defined with the Depreciation Schedule Method and Bonus Depreciation, the following abend occurs:

Error
-------

(SQR 3719) Columns names and expressions must be unique or be given unique pseudonyms  (&name) . TO-CHAR (TRANS_DT, 'DD-MON-YYYY')   &TRANS_DT ,

Steps
--------

This issue can be replicated by performing the following steps:

1) Create an asset with the Depreciation Schedule ('SC') Method and Bonus Depreciation.
2) Run depreciation for the asset.
3) Enter a What If Scenario to change the Depreciation Method to Straight Line ('SL').

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.