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

Fetch Element Entries in WFC Worksheet Columns.

Received Response
25
Views
3
Comments

Summary:

Hello All,

I am trying to write a formula behind workforce compensation plan columns in order to fetch and display the values for element entries for certain individual compensation plan elements attached to an employee.

One sample formula I found on the oracle docs for this was:

/=========== INPUT VALUES DEFAULTS BEGIN =====================/
INPUTS ARE CMP_IV_PLAN_ID (number),
CMP_IV_PERIOD_ID (number),
CMP_IV_COMPONENT_ID (number),
CMP_IV_ITEM_NAME (text),
CMP_IV_PLAN_START_DATE (date),
CMP_IV_PLAN_END_DATE (date)

/=========== INPUT VALUES DEFAULTS ENDS======================/

DEFAULT FOR CHF_REPRESENTATION_FEES_AMOUNT_ASG_ENTRY_VALUE IS 0

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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