APP-FND-01238: Cannot Set Value For Field

Applies to:

Oracle General Ledger - Version 11.5.10.0 to 11.5.10.0 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On : 11.5.10 version:

You are trying to add new rule in  'Cross Validation Rules' form , this following error occur

ERROR
-----------------------
APP-fnd-01238: Cannot set value for field RULE_LIST.CREATED_BY
APP-fnd-01238: Cannot set value for field RULE_LIST.CREATED_DATE
APP-fnd-01238: Cannot set value for field RULE_LIST.LAST_UPDATE_DATE

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Added a new Rule or updated an existing rule.

Cause

Bug 5936906 (91) ORA-1400 CANNOT INSERT NULL INTO FND_FLEX_VALUE_RULE_LINES.LAST_UPDATE_DATE:

The application of forms patchset 18 (version 6.0.8.27.0) has caused an issue with the call to FND_STANDARD.SET_WHO from Pre-Insert trigger(at block level).

Current Form
----------------------------------------
Form Application : Application Object Library
Form Name : FNDFFMCV
Form Version : 11.5.11
Form Last Modified : $Date: 2002/02/08 17:11 $

Solution

To implement the solution, please execute the following steps:

1. Please download and review the readme and pre-requisites for Patch 5216496 .
2. Please apply Patch 5216496 in a test environment.
3. Please test and verify the problem.
4. If the issue is resolved, please migrate the solution as appropriate to other environments.
or
5. Temporary workaround is to commit on each line as it is entered/updated in Cross Validation Rules.