EAM : Unique Constraint (SYSADM.PS_DEPR_RPT) on Composite Assets (Doc ID 2153890.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

Error on reporting process when composite assets are used

1 Create a composite asset 000000000138 where you need to use a department and check the composite asset checkbox. An ADD row with department will be create on cost table and cf_seqno 0
2 Create another asset 000000000139 which you associate with a composite asset 000000000138. Here we don't use a department
3 Create a Mass change using composite template
4 Fill in the asset details EVEN IF you get an error on magnifying glass: value can not be found. Save the mass change and execute SQL or just save and run after that the process. After that you should get the rows in he interface
5 This will create a second row ADD on asset 000000000138 without department and cf_seqno 0 . If we test and use here cf_seqno 1 , the reporting process finishes in success.
6 Calculate depreciation, Create accounting , Create reporting , Error on reporting process: unique constraint (SYSADM.PS_DEPR_RPT) violated

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