My Oracle Support Banner

How to Use the Opportunity Additional Where Clause for Assign Territory Access Program (Doc ID 1540598.1)

Last updated on FEBRUARY 06, 2022

Applies to:

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


On : 12.1.3 version, Concurrent Requests

'Assign Territory Access for New Mode' concurrent program runs into error

We want to run the TAP program only for certain opportunities like for those having the sales channel = 'CALL CENTER'
For doing so we are running the Assign Territory Access for New Mode program with following parameters
     Account Type = ALL
     Lead status = ALL
     Opportunity status = OPEN
     Opportunity Addl where clause = CHANNEL_CODE = 'CALL CENTER'

When doing so the program completes with a user defined exception

When we run the same program without giving the Opportunity Addl where clause it runs successfully.

How do we use the Opportunity Addl where clause to update only certain opportunities?


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.