Data Corruption in FA_BOOKS When Rollback Impairment and Adjusting Cash Generating Unit Simultaneously (Doc ID 2082714.1)

Last updated on NOVEMBER 26, 2015

Applies to:

Oracle Assets - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

2 records of transaction_header_id_out being NULL exist in FA_BOOKS when performing to rollback Impairment and adjusting Cash Generating Unit simultaneously.

Steps to Reproduce
1.  Addition   
    ----------------------------------------------
    Cash Generating Unit : *NULL
    ----------------------------------------------

2.  Assign Cash Generating Unit
    ----------------------------------------------
    Cash Generating Unit : CGU001
    ----------------------------------------------

3.  Impairment

    FA_BOOKS ****
    TRANSACTION   TRANSACTION    CASH_GENERATING
    HEADER_ID_IN  HEADER_ID_OUT  UNIT_ID        
    ------------  -------------  ---------------
               9             27            *NULL  <-- Addition
              27             37            10000  <-- Assign Cash Generating Unit
              37                           10000  <-- Impairment

4.  Change the Cash Generating Unit on Workbench, but do not yet save it.
    ----------------------------------------------
    Cash Generating Unit : CGU001 --> CGU002
    ----------------------------------------------
       

Note: Don't save the change and leave Workbench opened

 
5.  Rollback Impairment
      

Note: Wait until the status of Impairment becomes "DELETING POST"


6.  Save the change of Step4 on Workbench.

    FA_BOOKS ****
    TRANSACTION   TRANSACTION    CASH_GENERATING
    HEADER_ID_IN  HEADER_ID_OUT  UNIT_ID        
    ------------  -------------  ---------------
               9             27            *NULL  <-- Addition
              27             37            10000  <-- Assign Cash Generating Unit
              37             48            10000  <-- Impairment
              48          *NULL            10001  <-- Change Cash Generating Unit

7.  After saving the change, Rollback Impairment ends successfully.

    FA_BOOKS ****
    TRANSACTION   TRANSACTION    CASH_GENERATING
    HEADER_ID_IN  HEADER_ID_OUT  UNIT_ID        
    ------------  -------------  ---------------
               9             27            *NULL  <-- Addition
              27          *NULL            10000  <-- Assign Cash Generating Unit
              37             48            10000  <-- Impairment
              48          *NULL            10001  <-- Change Cash Generating Unit

    -> Data corruption occurs




Changes

1.  Addition   

2.  Assign Cash Generating Unit

3.  Impairment

4.  Change the Cash Generating Unit on Workbench, but do not yet save it.

5.  Rollback Impairment

6.  When performing to save the change of Step4 on Workbench.

    Before fixing this issue
    It can be saved.

    After fixing this issue
    The following error occurs in order to prevent to save the change of Step4 on Workbench.

        Error Message:
        Impairment has been posted for the asset &FA_ASSET_ID for the current period.
        Please rollback posted impairment to perform this transaction

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