原文:
Error: Item Select a valid value: Cannot Create an Install Base Record, Page Prompts for Item Number after Clicking on 'APPLY'
Applies to:
Oracle Install Base - Version: 12.0.6 to 12.1.3 - Release: 12 to 12.1
Information in this document applies to any platform.
Symptoms
When attempting to create an Item Instance for a particular Item Number, the following error occurs:
ERROR
-----------------------
Error Item Select a valid value
EXPECTED BEHAVIOR
-------------------------------------
Expect the newly created Instance to save correctly
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Oracle Installed Base Agent User >> Item Instance >> Item Instances >> Click on the 'Create' button
2. Enter Item Number XXXXXXX (note that the page accepts the Item Number as a valid value)
3. Enter all other required data
4. Click on the 'Apply' button
5. Observe error message
Cause
The default value of the 'Use For validation' property is 'default', which means that if the form value has a value of 'Null' then OAF will try to validate the LOV again when the page is submitted. Then it will give the error 'select a valid value'.
Solution
1. Download and review the readme and pre-requisites for Patch.9124887:R12.CSI.A for 12.0.X and Patch.9124887:R12.CSI.B for 12.1.X.
2. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Bounce the Apache Server. In R12 the command to stop and start Apache only takes action on the Apache web server and not on the OC4J container that executes the JVM. To bounce the OC4J container there is a specific script (Note 555381.1):
$INST_TOP/admin/scripts/adoacorectl.sh
5. Confirm the following file versions:
12.0.X - CreateProductRN.xml 120.32.12000000.9
12.1.X - CreateProductRN.xml 120.33.12010000.6
You can use the commands like the following:
strings -a $CSI_TOP/mds/instance/general/webui/CreateProductRN.xml |grep '$Header'
6. Retest the issue.
7. Migrate the solution as appropriate to other environments.
NOTE: If you are using Oracle Asset Tracking (OAT), you may also need to apply Patch <9488094>.
References
BUG:9488094 - R12.1 FP BUG FOR 9124887
1203433.1
'Not able to create install base record'
Related
Products
Oracle E-Business Suite > Asset Lifecycle Management > Asset Lifecycle Management > Oracle Install Base
Keywords
VALID VALUES; ERROR MESSAGE; PROMPT; ITEM NUMBER; R12; INSTALL BASE; OA FRAMEWORK; VALIDATION FAILED
· Log in or register to post comments
译文:
错误:项目选择一个有效值:在点击’APPLY’后,不能为项目编号创建一个安装点记录以及页面提示。
症状:
当尝试为一个特别的项目编号创建一个项目实例时,会出现以下错误:
ERROR
-----------------------
Error Item Select a valid value
EXPECTED BEHAVIOR
-------------------------------------
Expect the newly created Instance to save correctly
重现问题的步骤:
这个问题能随着以下的步骤重现:
1. Oracle Installed Base Agent User >> Item Instance >> Item Instances >> 点击'Create' 按钮
2.输入项目编号XXXXXXX(注意,页面把项目编号作为一个有效值)
3.输入所有其他需要的数据
4.点击'Apply'按钮
5.观察错误信息
原因:
‘Use For validation’的属性默认值为’default’,这也就意味着当页面被提交,并且属性值为’Null’时,OAF(Oracle Application Framework:oracle应用程序框架)将会尝试再次去验证LOV(List of values:值列表)。接着,它就会报一个错’select a valid value’。
解决方案:
1. 下载并且查看Patch.9124887:R12.CSI.A for 12.0.X和Patch.9124887:R12.CSI.B for 12.1.X的readme和pre-requisites。
2. 在打补丁前,确保已经对你的系统做好了备份。
3. 在一个测试环境中应用补丁。
4. 关闭Apache服务。在R12中建议只在Apache web服务器上停启Apache服务,并且不在OC4J中执行JVM。关闭OC4J有一个指定的脚本(Note 555381.1):
$INST_TOP/admin/scripts/adoacorectl.sh
5. 查看以下文件的版本:
12.0.X - CreateProductRN.xml 120.32.12000000.9
12.1.X - CreateProductRN.xml 120.33.12010000.6
可以使用以下的命令来查看:
strings -a $CSI_TOP/mds/instance/general/webui/CreateProductRN.xml |grep '$Header'
6. 再一次测试这个问题。
7. 将这个解决方案应用到其他环境中。
注意:如果你正在使用Oracle Asset Tracking(OAT: Oracle资产追踪),你也可能需要去打补丁<9488094>。
Bug:9488094 –R12.1 FP BUG FOR 9124887
1203433.1
‘无法创建安装点记录’