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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

HCM Extract | Fast formula to get position budget details

Hi Experts,

I need your assistance.

I created a fast formula to get the budget amount in my extract file, and it's successfully compiled.

However, I can't see the values of this field in my extract.

For that, I created value sets and a fast formula.

Fast Formula:

DEFAULT FOR POSITION_BUDGET_AMOUNT IS 0

INPUTS ARE POSITION_ID (NUMBER)

 l_pos_id  = ' '

l_budget_amount  = ' '

 l_pos_id = TO_CHAR(POSITION_ID)

 l_budget_amount = GET_VALUE_SET('SEW_Position_Budget_Amount','|=POSITION_ID=''' || l_pos_id || '''')

 RULE_VALUE =   l_budget_amount

return RULE_VALUE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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