Thursday, October 4, 2007

Worflow Background Process errors with ORA-00600 internal error code, arguments: [4414]

Workflow Background Process concurrent request fails with the following error message when the request is submitted with Order Management Item type.
ORA-00600: internal error code, arguments: [4414], [12226], [1], [12226], [1], [], [],
ORA-01403: no data found

Workflow Background Process concurrent request is a Workflow Background Engine. Workflow Backedground Process concurrent request needs to be scheduled at regular intervals as it processes deferred activities and timed out activities.

Generally the 'Workflow Background Process' fails with the following error after upgrading to Oracle Applications and if the database is upgraded from to 9i.

What does "ORA-600 [4414] " followed by an "ORA-01403: no data found" mean ?

If a queue has messages enqueued for rule based subscribers prior to the upgrade, then dequeueing these messages on the upgraded database results in an "ORA-600 [4414]" followed by an "ORA-01403: no data found" error.

Reference from Metalink Note:200983.1


sqlplus "/ as sysdba"
SQL> exec sys.dbms_prvtaqis.upgrade_rulesub_msgs;

This should solve the issue.

The package "
dbms_prvtaqis.upgrade_rulesub_msgs" is not available in 8i, but available in 9i. The package "dbms_prvtaqis.upgrade_rulesub_msgs" upgrades "Rule Based Subscriber Messages" to 9i.

Enjoy !!


Anonymous said...

Hi Madhu,

Obviously a good blog, no second thoughts. By sharing a Knowledge, it saves lot of time of Hundreds of Professionals who struggles to get a solution.


Madhu Sudhan said...

Thanks Irfan.