In the Create Physical Inventory Form, Receive FRM-40654 And/Or FRM-40735 ORA-20002 Errors When Trying to Update The Description of Descriptive Flexfield Values (Doc ID 2788670.1)

Last updated on JULY 01, 2021

Applies to:

Symptoms

Following errors are received when trying to update the existing Physical Inventory (PI) header description value or the Descriptive Flexfield (DFF) value(s) for an existing Physical Inventory.

Steps

1. Create Physical Inventory (PI)
   Navigate: Physical Inventory->Physical Inventories
   Click the New button
   Enter:
       Name=(enter PI header name)
       Description=(value)
       Date defaults to today's date
       Approvals Required=Never
       Check Allow Dynamic Tags, Exclude Zero Balances, Exclude Negative Balances
       Select a subinventory
      [Save]
2. Close the form, reopen and query the just saved PI.
3. Change the Description and the form will allow you to change without any errors.
4. Click the Snapshot button.
5. Close and open the Physical Inventory form again.
   This kicks off a concurrent request.
6. Open the form again and try to change the description and/or DFF values and the errors are displayed.
   
   

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.