We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

How to Default a DFF Segment value based on value in another segment

Question
1
Views
0
Comments

Summary:

We are trying to default value of segment "Reporting Category (Attribute 6)" based on segment "Service Name (Attribute 1)" for DFF PJF_TASK_STRUCTURE_DFF using SQL defaulting method. It is not working.

Content (required):

Sample Query

Select Tag --It is the value we want to default

from FND_LOOKUP_VALUES

where Lookup_Type ='TEI_SERVICENAME_REPORTSEGMENT' -- Lookup for DFF "Service Name"

and Language ='US' and MEANING = 'Training Onsite' -- For now we are trying hardcoded value to do POC. Later we will like

-- to use :PARAMETER.Service Name

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

22A

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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