Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

No Columns available in CN_TP_EARNINGS to enable for Calcluation

in Incentive Compensation 6 comments

Summary:

Trying to enable the SOURCE_TRX_NUMBER for calculation in the CN_TP_EARNINGS table through the Configure Tables and Columns Task in Setup and Maintenance.

The use case is we would like to refer to the COMMISSION_VALUE field for a previous earning transaction record if the credit transaction fits certain criteria.

However, when I navigate to the table, no column is available for the CN_TP_EARNINGS table.

  1. Is this table not available for any types of calculation?
  2. If this table is available for calculation, how can I add more columns in?
  3. If this is a security issue (I am able to see columns for other table), any security role/data role I should be granting for my role? I can access earnings transaction records with no issue.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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