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:

Symptoms

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


STEPS
-----------------------
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

Cause

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