My Oracle Support Banner

When running Territory Assignment programs, JTY_ASSIGN_BULK_PUB.insert_trans_data is failing due to error "Invalid number of workers" (Doc ID 2888220.1)

Last updated on AUGUST 10, 2022

Applies to:

Oracle Territory Management - Version 12.2.10 and later
Information in this document applies to any platform.


When running the Territory Assignment programs, the following error is shown in the program logs:

jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.begin 2 Start of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data 30-06-2022 13:58:12
jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_invalid_workers 4 JTY_ASSIGN_BULK_PUB.insert_trans_data: Invalid number of workers : Valid range from 1 - 10
jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_trans_data 4 API JTY_ASSIGN_BULK_PUB.insert_trans_data has failed
jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_error 4 API JTY_ASSIGN_BULK_PUB.insert_trans_data has failed

The issue can be reproduced at will with the following steps:

1. Responsibility: Territory Management

2. Run Synchronize Territory Assignment Rules (STAR) and Territory Assignment programs


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.