EAM: Ran What If Depreciation Job And Went Into Error

(Doc ID 1625598.1)

Last updated on OCTOBER 10, 2017

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').

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