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

Setting Default Value to DFF using SQL is not working

Received Response
28
Views
1
Comments
edited Mar 9, 2022 6:30AM in Enterprise Contracts 1 comment

Summary:

I am trying to set a default value to a DFF in Contracts Line page based on Contract Line Type but the default value is not working.

I have done the below

1) Defined Contracts and Contract Line Type = Default Line Type









2) Created a Lookup with a lookup value = Default Line Type







3) Created DFF Attribute in Contract Lines to default value based on below SQL

SELECT TAG FROM FND_LOOKUP_VALUES

WHERE LOOKUP_TYPE = 'XX_CONTRACT_LINE_REV_ACCT'

AND ENABLED_FLAG = 'Y'

AND MEANING = :{PARAMETER.LineTypeCode}







4) When I create a contract line with this value, it is not defaulting the expected value

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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