You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using parameter within data model

Received Response
41
Views
3
Comments
edited Feb 27, 2020 3:45PM in Reporting and Analytics for ERP 3 comments

Summary

Using parameter within data model

Content

Hi,

I am using the following parameter within a BI Publisher data model sql where clause :

AND    PARTY.PARTY_NAME IN DECODE( :P_CUSTOMER_NAME, NULL, PARTY.PARTY_NAME, :P_CUSTOMER_NAME )

I have noticed that when the user choose more than 10 customers from the customer LOV then he get empty output. is there any limitation for the parameter length ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!