Post process fails with the following errors in the event log
07/24/08 13:12 Error: Unexpected Oracle error: ORA-01843: not a valid month.ORA-06512: at line 1. (object name: SCHEMA_USER.OBJECT_NAME) [sp_opst_mt (for o.irv1-o.irv2 queue test01)/3972]
[4] 07/24/08 13:12 Notice: ORA-01843: not a valid month.ORA-06512: at line 1. [sp_opst_mt(osp)/3972]
The table has a function based index where the function has an error in it.
RESOLUTION:
1) Check the function for the function based index, make sure there are no errors on it.
2) Recompile it
3) Enable the index.