My Oracle Support Banner

In Items Form INVIDITM, get Error FRM-40735 or FRM-40654 when attributes Encumbrance Account Or Expense Account Or Serial Tagging flag are updated (Doc ID 1980046.1)

Last updated on JANUARY 16, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Item Issues

FRM-40735 and/or FRM-40654 Error during update in Items INVIDITM form

ERROR
-----------------------
1.1 For Encumbrance Account -
FRM-40735: ON-LOCK trigger raised unhanded exception ORA-20001

1.2 For Expense Account -
FRM-40654: Record has been updated. Re query block to see change.

Another case :

2. Related to Serial_Tagging_Flag -

FRM-40654: Record has been updated. Requery block to see change.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Inventory responsibility
2. Master Items
3. Try to update Item
4. See one or both errors.

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
Cause
 Case 1 : Related to Encumbrance Account OR Expense Account
 Case 2 : Related to serial_tagging_flag
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.