FADSCF Failed Due To ORA-01779: Cannot Modify A Column Which Maps To A Non Key-Preserved Table (Doc ID 359343.1)

Last updated on JULY 09, 2021

Applies to:

Symptoms

    FADEPR module: Depreciation Run
    Depreciation Program Exception Report
    APP-OFA-48208: processing has the value of primary/reporting book .
    APP-FND-01564: ORACLE error 1779 in fadscf
   
    Cause:  fadscf failed due to ORA-01779: cannot modify a column which maps to a non key-preserved table
      
    The SQL statement being executed at the time of the error was:  and was executed from the file .
    APP-OFA-47649: Error: Unable to set depreciation status in FA_BOOK_CONTROLS table
    
    Error: function fadscf returned failure (called from FADEPR)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.