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

The bind variable :{PARAMETER.TransactionTypeId} is not valid. (FND-2544)

Summary:I am trying to use a bind variable in my sql for Context segment

receive this error:The bind variable :{PARAMETER.TransactionTypeId} is not valid. (FND-2544)


Content (please ensure you mask any confidential information):

This is the sql

Select TRANSACTION_TYPE_NAME from inv_transaction_types_vl where transaction_type_id=:{PARAMETER.TransactionTypeId} and transaction_type_name in(select descriptive_flex_context_code from fnd_descr_flex_contexts where descriptive_flexfield_name='INV_MATERIAL_TXNS' and
enabled_flag='Y')

Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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