CN — Incentive Compensation
182 documented tables · 1 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CN_OBJECTS_ALL |
Collection of objects used by Sales Compensation. Tables, columns, sequences, packages, etc. | hub |
CN_REPOSITORIES_ALL |
System parameters table | hub |
CN_ATTAIN_SCHEDULES |
This table will store the name of attainment schedule to be used on compensation contracts. | hub-leaning |
CN_CREDIT_TYPES_ALL_B |
Credit Types | hub |
CN_QUOTAS_ALL |
Plan Elements | hub |
CN_PERF_MEASURES_ALL |
Contains information about performance measure. You need one row for each performance measure defined. | hub-leaning |
CN_RATE_SCHEDULES_ALL |
Compensation rate table | hub |
CN_REVENUE_CLASSES_ALL |
Revenue classes. | hub |
CN_MODULES_ALL_B |
Source modules generated by the Classification and Collection code generators. | hub |
CN_CALC_FORMULAS_ALL |
Contains information about calculation formula. You need one row for each calculation formula defined | hub |
CN_EVENTS_ALL_B |
Contains the various events used in the Collection and Classification processes. | hub-leaning |
CN_PROCESS_AUDITS_ALL |
Process execution log details | hub |
CN_COMP_PLANS_ALL |
Compensation Plans | hub-leaning |
CN_ROLE_MODELS_ALL |
Stores the different agreement versions (models) for an agreement (corresponding to a role) | hub-leaning |
CN_DIMENSIONS_ALL_B |
Stores dimensions of data. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
CN_API |
API | 83 | 132 packages |
CN_PERIODS_API |
API | 5 | 12 packages |
CN_PLAN_ELEMENT_PUB |
PUB | 4 | 11 packages |
CN_SRP_PMT_PLANS_PUB |
PUB | 6 | 5 packages |
CN_GET_TX_DATA_PUB |
PUB | 12 | 5 packages |
CN_SRP_PAYGROUP_PUB |
PUB | 4 | 4 packages |
CN_COMP_PLAN_PUB |
PUB | 1 | 4 packages |
CN_ROLE_PLANS_PUB |
PUB | 3 | 3 packages |
CN_RULEATTRIBUTE_PUB |
PUB | 3 | 3 packages |
CN_RULESET_PUB |
PUB | 2 | 3 packages |