My Oracle Support Banner

Territory Management does not assign winner in Collection process (Doc ID 415394.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


Invoice Collection process was run with the integration to Territory Assignment Engine.  However, no salesrep was assigned to the transaction from Territory Management.

Verified the setup of Territory Management and confirmed we should have a winner returned.

1. The value of CN_COMM_LINES_API_ID is returned using the following script for the transaction using the Accounts Receivables Invoice Number :

select comm_lines_api_id from CN_COMM_LINES_API_ALL where invoice_number = '&invoice_number' and source_doc_type = 'AR' and (adjust_status <> 'REVERSAL' or adjust_status is null) and (adjust_comments != 'Created by TAE' or adjust_comments is null);

2. Use the value for CN_COMM_LINES_API_ID in the following queries and have the following results :

select count(*) from JTF_TAE_1001_SC_TRANS where source_id = -1001 and
trans_object_type_id = -1002 and trans_object_id = &&comm_lines_api_id;

-- return 1

select count(*) from JTF_TAE_1001_SC_MATCHES where source_id = -1001 and
trans_object_type_id = -1002 and trans_object_id =&&comm_lines_api_id;

-- return a value greater than 0

select count(*) from JTF_TAE_1001_SC_WINNERS where source_id = -1001 and
trans_object_type_id = -1002 and trans_object_id = &&comm_lines_api_id;

-- return 0


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

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