This error is caused by corruptions that have crept into a table that stores cached queries. The only thing to do in this situation is to delete that table and clear cache by bouncing the Apache server.
There is patch available that can reduce the chance of these corruptions from happening in the future.
Please do the following
CREATE TABLE fnd_lov_choice_values_bak AS
SELECT * FROM fnd_lov_choice_values
;
DELETE fnd_lov_choice_values;
COMMIT;
Clear the cache
Then bounce the Apache server.
Then please download and apply patch Patch:9527712:R12.FWK.B
Afterwords, please try you test again.
Comments
Tags: Apache server, database oracle application, Oracle, Oracle Application Database, Oracle Database, Oracle DBA, Oracle Query
http://www.erp100.com/forum.php?mod=viewthread&tid=262269