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:

Symptoms

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

Steps

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. 
      
      
      

Changes

Cause

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