EAM : Unique Constraint (SYSADM.PS_DEPR_RPT) on Composite Assets
Last updated on JANUARY 10, 2018
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms