My Oracle Support Banner

Collection for Custom Source does not recover after Collection Fails (Doc ID 827027.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

The Collections process failed because of an extent problem on the database.

When trying to run Collections again, the transactions left unprocessed were not picked up.
Trying to repopulate the source table, the transactions again fail to be processed.  There were corresponding rows in the CN_NOT_TRX tables with an event_id of 1000 (collections source) and a collected_flag = 'N'.  Those rows prevent user from re-collecting the transactions.

Steps To Reproduce:

Run the Collections with a custom source.
Have the database error with an UNABLE TO EXTEND
Try to collect the transactions again.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.