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

Issue with a field in a extract

Accepted answer
9
Views
2
Comments
edited Dec 9, 2020 6:03PM in HCM Integrations 2 comments

Summary

Pull up the Action type code

Content

Hi,

I have this fast formula 

DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT
INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)
L_****_ID = DATA_ELEMENTS['ASSIGNMENT_ID']
L_EFF1_DATE = TO_DATE(DATA_ELEMENTS['Effective_Date'],'YYYY/MM/DD')
L_ACTION_REASON_CODE = 'NULL'
L_ACTION_REASON_CODE     = GET_VALUE_SET('TEST_GET_ACTION_REASON_CODE_VS'
                                  ,'|=P_ASSIGNMENT_ID='''||L_****_ID||''''||'|L_EFF_DT='''||TO_CHAR(L_EFF1_DATE)||''''
                                  )
RULE_VALUE = L_ACTION_REASON_CODE
RETURN RULE_VALUE

that reads this VS

AND pav.action_code = paam.action_code

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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