My Oracle Support Banner

Cannot Update Descriptive Flexfield In Physical Inventory Form - Error "APP-FND-01238: Cannot set value for field FOLDER.LAST_UPDATE_DATE." (Doc ID 2765828.1)

Last updated on JUNE 09, 2021

Applies to:

Oracle Inventory Management - Version 12.2.9 and later
Information in this document applies to any platform.


The following error is encountered when trying to update the descriptive flexfield defined in the Physical Inventories form:

 APP-FND-1238: Cannot set value for field FOLDER.LAST_UPDATE_DATE.


  1. Create DFF.
    1. Nav: system Administrator > Application >  Flexfield > Descriptive > Segments
    2. Query for DFF = Physical Inventory
    3. Click Segments button
      Add 2 attributes
        Test 1, ATTRIBUTE1, Value Set = "10 Characters", Uncheck "Required" checkbox
        Test 2, ATTRIBUTE1, Value Set = "10 Characters", Uncheck "Required" checkbox
    4. Click "Freeze Flexfield Definition" (Compile)

  2. Enter DFF values
    1. Nav  Inventory > Counting > Physical Inventory >  Physical Inventories
    2. Perform blind query.
    3. Click Open button
    4. Open DFF.
        Try to enter a value and get error:

             APP-FND-1238: Cannot set value for field FOLDER.LAST_UPDATE_DATE.
             Review your error messages (Help -> Diagnostics -> Display Database Error...) to see the cause of the error.    

    5. Click the "Details" button to see the following message:

         APP-FND-01388: Cannot read value for profile option FND_INDICATOR_COLORS in routine &ROUTINE.
         FRM-40654: Record has been updated. Requery block to see change.
         FRM-40735: ON-LOCK trigger raised unhandled exception ORA-20002. 




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

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