Problem during Creation of Worklist in Collections Management

[Former Member]

Hi,

I get the following runtime error when I run the transaction UDM_GENWL:

Short text

The ABAP/4 Open SQL array insert results in duplicate database records.

What happened?

Error in the ABAP Application Program

The current ABAP program "CL_UDM_PARALLEL_RUN===========CP" had to be

terminated because it has

come across a statement that unfortunately cannot be executed.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "SAVE_PARALLEL_RUN" "(METHOD)", nor was it propagated by a RAISING

clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the same error

situation, processing does not terminate, but SY-SUBRC is set to 4.)

Any idea what this could be due to? Is this an errorin the standard program?

Thanks and Best Regards,

Madhu

[Former Member · Accepted solution]

When you are generating the worklist are you running this in the foreground or the background?

What selection parameters have you run for the transaction?

The error seems to indicate duplicate processing, so this could be a one off, or if it keeps happening there maybe an issue with the master data or the way the generation program is being run.

[Former Member · Accepted solution]

Hi Mark,

I'm selected the checkbox "Start Online" in the selection screen for Generating Worklists. So, I believe I'm running it in the foreground. As for the selection screen parameters, here they are:

Collection Segment: TEST_SEG

Worklist Valid From: 10.10.2010

Distribute Items: Yes (Checkbox selected)

Distribution Method: Even Distribution to Collection Specialists

Start Online: Yes (Checkbox selected)

The master data and configuration have been made in the usual way for Collections Management as per the help documents.

I've created a customer via the Business Partner using the Master Data Synchronization.

Any idea what the issue could be?

Best Regards,

Madhu

[Former Member · Accepted solution]

what are the volumes of data going through to Collections Management?

Have you tried running this program in the background - does the error still occur?

If this keeps on occuring, try getting an ABAP'er to debug it to see why this is occuring.

[Former Member · Accepted solution]

Hi Mark,

The volume of data is very less since we're just running this to tests a sample scenario. We have just two items from FI-AR matching our dummy Customer (which had just been created before the worklist creation run), which have been transferred to Collections Management.

Also, I debugged the code and found the short dump in the parallel processeing code. Anyway, now I somehow can't run the transaction again since it says the segment is blocked by another run! And when I check the monitor, I find that the run mentioned is totally irrelevant to my current run! Totally confused!

I also tried creating the worklist for a new segment, selecting only one Company Code to reduce the size of the segment. But this doesn't work too!

Best Regards,

Madhu

[Former Member · Accepted solution]

Why dont you send the data from AR to FSCM again, and try to generate with different data.

[Former Member · Accepted solution]

Hi Mark,

Thanks for your suggestion. I started all over again with fresh data (CCode, BP and new config in Collections Management). I don't get the dump anymore. So, one issue solved so far!

However, the worklist is not created. In the monitor when i see the details of the run i find multiple error messages. There is an error message corresponding to the Business Partner I've created (4246) for my example. The message says "No BP roles with BP role category UDM000 exist for partner 4246". I guess this is reason for the worklist not being created. I checked the Business Partner in BP and found that the BP is maintained in role UDM000. Any idea what the problem could be then?

Also, there are multiple error messages corresponding to all Business Partners selected between a lower limit and upper limit. I don't know where these limits have been set and how I can change this.

Best Regards,

Madhu

[Former Member · Accepted solution]

Hi Madhu ,

Kindly confirm whether the error mentioned occured during the transfer of FI-AR to FSCM collection or during the creationof the worklist . check whether the BP has been created with tha role and collection segment has been mainatained . while transffering the data did u use intial data transfer .

[Former Member · Accepted solution]

Please check your BP partner config for Collections Management.

There is a guide on the FSCM wiki page.

[Former Member · Accepted solution]

Hi,

I've created the BP in the role "UDM000" and also maintained the Collection Profile, Collection Grioup and Collection Specialist entries in it.

The BP resulted in an automatic creation of the Customer via the Business Partner Synchronization. So, the direction I used was BP to Customer.

I posted a Customer Invoice for this customer which satisfies the rules in the Collection Strategy. I then made the transfer of data from FI to Collections Management.

So, as far as the configuration is concerned I've covered all the settings. Any idea if I've missed something?

Best Regards,

Madhu

[Former Member · Accepted solution]

I would suggest you check the BP role set up.

Is the BP role linked to an Account Group in AR?

Do they use the name number range?

[Former Member · Accepted solution]

Hi All,

I recreated the entire scenario with new business partner and customer data and it seems to work now! I somehow think the problem must have been with the Strategy also.

Anyway, thanks for your valuable suggestions.

Best Regards,

Madhu