My Oracle Support Banner

Creating An Advance DCL Filter For Subscription PUIDs (Doc ID 2883552.1)

Last updated on JULY 15, 2022

Applies to:

Oracle Fusion Subscription Management Cloud Service - Version 11.13.22.04.0 and later
Information in this document applies to any platform.

Symptoms



Objective: To create a custom DCL field in credit memo object which should show PUIDs which are available only in a subscription. To filter PUIDs in DCL field based on subscription number.

Pre-requisite : Already having a field in custom object to capture Subscription Number and Subscription Id. Also having a custom DCL for PUID but unable to filter based on subscription number.

Getting the errors below.


ERROR
-----------------------
1. Error in filter, unaccepted token: <bind variable name>
2. Attempt to set a parameter that does not occur in the SQL :<Bind Variable Name> .

Cause

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
Symptoms
Cause
Solution
References


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