SQL Predicate For Partner Program Enrollments So That Log in User See Only Partner Program Enrollments in which It is member of the Partner and Partner Program Enrollments is not in status of REJECTED Or DRAFT (Doc ID 2276676.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Sales Predictor

Need custom SQL predicate for Partner Program Enrollments

We have a requirement where Partner Administrator/Partner Sales Manager should not be able to see enrollments which are not approved.

Currently we have used below OOTB condition:
Access the partner program enrollment for table ZPM_PROGRAM_ENROLLMENTS where the user is a member of the partner organization

Along with this we need filter on Status. Please provide the SQL predicate for the same.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms