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
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Default value of DFF segment using SQL

    edited Dec 9, 2018 12:41PM in Performance Management 2 comments

    Content

    I need to default of a segment based on another segment of the same DFF using SQL. I have used the following query: 

    Select  :{SEGMENT.ExecutionTargetManager.value} from dual.

    However I am getting the following error:

    The bind variable :{SEGMENT.ExecutionTargetManager.value} does not refer to a prior, enabled global segment or value set. (FND-2540)
    In application 10097, descriptive flexfield HRG_GOALS, and global segment Manager Achievement, the bind variable :{SEGMENT.ExecutionTargetManager.value} in SQL default value Select :{SEGMENT.ExecutionTargetManager.value} from dual must refer to a prior, enabled global segment or value set.

    Can anybody help me in this regard?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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