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
Last updated on JUNE 14, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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.
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