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.

Symptoms

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.


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

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