We used the Advanced Revenue Management module, and before we post revenue, we need to ensure all revenue arrangements and plans are updated.
We go to Transactions / Financial / Update Revenue Arrangements and Revenue Recognition Plans page
I'm honestly not sure when the "Preprocessing revenue recognition plans" started appearing, but it has slowed down our process immensely. It can take up to 7 hours for this step to be completed. What happens is that we start off with maybe 50,000 errors. Every time we refresh, they resolve themselves but it takes forever. I'm hoping someone can help me decipher that error on the bottom to at least get us looking in the right places to make sure this stops happening.
Here is the screenshot of the page with the errors:
Here is an example of one of the errors:
Unexpected error occurred: ORA-00060: deadlock detected while waiting for resource ORA-06512: at "NLCOMPANY.FLAG_ELEMENT_FOR_SCHEDULING", line 102 ORA-06512: at "NLCOMPANY.FLAG_ELEMENT_FOR_SCHEDULING", line 102 ORA-04088: error during execution of trigger 'NLCOMPANY.FLAG_ELEMENT_FOR_SCHEDULING' ORA-06512: at line 473 BAD SQL STATEMENT:/* SQL for: Block SQL Runner */ begin UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE nKey = ? ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET dMediatedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), dMediationChangedVersion = TO_DATE(?,'DD/MM/YYYY HH24:MI:SS','NLS_CALENDAR=''Gregorian'''), rQuantity = ? WHERE RatableEvent.nKey IN (SELECT column_value FROM TABLE(CAST(? AS NUMBER_LIST_TYPE))) ; UPDATE RatableEvent SET