My Oracle Support Banner

Calculate Lease Interest and Expense - Error ORA-00001 (Doc ID 2491545.1)

Last updated on OCTOBER 23, 2020

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms

When running Calculate Lease Interest and Expense job to create Lease expenses the Job is completing in error with unique constraint error:

ERROR
-----------------------
fa_expense_summary_pkg.insert_row
ORA-00001: unique constraint (FUSION.FA_LEASE_EXPENSE_SUMMARY_U1) violated
fa_lease_expense_pkg.process_expense_rows
ORA-00001: unique constraint (FUSION.FA_LEASE_EXPENSE_SUMMARY_U1) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Go to Assets -> Depreciation infotile -> click on Calculate Lease Expense

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