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

Has anyone faced this behavior where SQL defaults work in dataset but don’t evaluate inside the DFF

in Human Capital Management 1 comment

Summary:

DFF SQL Default is not evaluating in the edit page (remains blank), but the same SQL works correctly when tested in dataset/SQL Developer.

Content (please ensure you mask any confidential information):

I am working with the descriptive flexfield PER_DOCUMENTS_OF_RECORD_DFF, context SA_NEW_MATERIAL_SUPPLIER_EVALUATION.
My requirement is to populate a DFF segment’s default value based on Documents Of Record ID (DORID), joining to workflow task data and value set phases.

  • When I test the SQL in dataset (BI Publisher / SQL Developer), it returns the correct results.
  • When I use the SQL as a

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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