Search Results oracle ebs order change reason
The CN_REASON_HISTORY_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Incentive Compensation module (Oracle Incentive Compensation, or OIC). This table serves as a historical repository for tracking changes to commission adjustment reasons, providing an audit trail for modifications made to incentive compensation calculations. Below is a detailed breakdown of its purpose, structure, and key attributes:
Purpose and Functional Context
The CN_REASON_HISTORY_ALL table stores historical records of adjustments applied to commission calculations, including reasons for manual overrides, disputes, or corrections. It supports compliance, reporting, and reconciliation processes by maintaining a log of changes made to incentive payouts. This is particularly important for auditability in industries with strict regulatory requirements (e.g., financial services).Key Columns and Data Structure
The table typically includes the following columns:- REASON_HISTORY_ID: Primary key, uniquely identifying each historical record.
- REASON_CODE_ID: Foreign key linking to CN_REASON_CODES_ALL, referencing the reason for the adjustment.
- ADJUSTMENT_ID: Foreign key to CN_ADJUSTMENTS_ALL, associating the reason with a specific commission adjustment.
- START_DATE and END_DATE: Define the validity period of the reason's applicability.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle audit columns tracking who made changes and when.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1-15: Flexfield columns for custom extensions.
Integration with Other Modules
The table interacts with:- CN_ADJUSTMENTS_ALL: Captures adjustments to commission calculations.
- CN_COMMISSION_PAYMENTS_ALL: Ties adjustments to finalized payouts.
- CN_QUOTA_RULES_ALL: Links reasons to quota-based incentive rules.
Technical Considerations
- Multi-Org Support: The "_ALL" suffix indicates it stores data across operating units (multi-org enabled).
- Partitioning: In high-volume environments, partitioning by CREATION_DATE may improve query performance.
- Indexing: Common indexes include REASON_HISTORY_ID (PK), ADJUSTMENT_ID, and REASON_CODE_ID.
Usage Scenarios
- Dispute Resolution: Auditors trace why a commission was reduced or increased.
- Regulatory Reporting: Demonstrates compliance with compensation disclosure laws.
- Trend Analysis: Identifies frequent adjustment reasons for process improvements.
Customization Points
Organizations often extend functionality by:- Adding custom reason codes via CN_REASON_CODES_ALL.
- Leveraging descriptive flexfields for industry-specific metadata.
- Building triggers to enforce business rules on reason changes.
Data Retention and Performance
For implementations with large data volumes:- Archive older records to CN_REASON_HISTORY (without "_ALL") for historical reporting.
- Purge policies should align with legal retention requirements.
-
Lookup Type: ORDER
12.1.1
product: CN - Incentive Compensation , meaning: Order , description: Order ,
-
Lookup Type: ORDER
12.2.2
product: CN - Incentive Compensation , meaning: Order , description: Order ,
-
Lookup Type: ADJUSTMENT_REASON
12.2.2
product: CN - Incentive Compensation , meaning: Manual Adjustment Reason , description: Manual Adjustment Reason ,
-
Lookup Type: ADJUSTMENT_REASON
12.1.1
product: CN - Incentive Compensation , meaning: Manual Adjustment Reason , description: Manual Adjustment Reason ,
-
Concurrent Program: CNUPGPMTREASONSMGR
12.1.1
execution_filename: CN_UPG_PMT_REASONS_PKG.Notes_Mgr , product: CN - Incentive Compensation , user_name: Upgrade payment reason records to notes - Manager , description: Upgrade payment reason records to notes. This is needed for customer from 11i to 12.0 upgrade. , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: CNUPGPMTREASONSMGR
12.2.2
execution_filename: CN_UPG_PMT_REASONS_PKG.Notes_Mgr , product: CN - Incentive Compensation , user_name: Upgrade payment reason records to notes - Manager , description: Upgrade payment reason records to notes. This is needed for customer from 11i to 12.0 upgrade. , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: CNUPGPMTREASONSWKR
12.1.1
execution_filename: CN_UPG_PMT_REASONS_PKG.Notes_Worker , product: CN - Incentive Compensation , user_name: Upgrade payment reason records to notes - Worker , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: CNUPGPMTREASONSWKR
12.2.2
execution_filename: CN_UPG_PMT_REASONS_PKG.Notes_Worker , product: CN - Incentive Compensation , user_name: Upgrade payment reason records to notes - Worker , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: JE_BATCH_REASON
12.1.1
product: CN - Incentive Compensation , meaning: Reason for creating JE batch , description: Reason for creating JE batch ,
-
Lookup Type: JE_BATCH_REASON
12.2.2
product: CN - Incentive Compensation , meaning: Reason for creating JE batch , description: Reason for creating JE batch ,
-
Lookup Type: HOLD_REASON_CODE
12.2.2
product: CN - Incentive Compensation , meaning: HOLD_REASON_CODE , description: Hold Reason Code ,
-
Lookup Type: HOLD_REASON_CODE
12.1.1
product: CN - Incentive Compensation , meaning: HOLD_REASON_CODE , description: Hold Reason Code ,
-
Lookup Type: ANALYST_NOTE_REASON
12.2.2
product: CN - Incentive Compensation , meaning: Analyst Note Reason ,
-
Lookup Type: ANALYST_NOTE_REASON
12.1.1
product: CN - Incentive Compensation , meaning: Analyst Note Reason ,
-
Lookup Type: PAYMENT_CHANGE
12.1.1
product: CN - Incentive Compensation , meaning: payment change , description: payment change ,
-
Lookup Type: PAYMENT_CHANGE
12.2.2
product: CN - Incentive Compensation , meaning: payment change , description: payment change ,
-
Lookup Type: EVENT_NAME
12.1.1
product: CN - Incentive Compensation , meaning: event name , description: event name ,
-
Lookup Type: EVENT_NAME
12.2.2
product: CN - Incentive Compensation , meaning: event name , description: event name ,
-
Lookup Type: TRX TYPES
12.2.2
product: CN - Incentive Compensation , meaning: Transaction Types , description: Transaction Types ,
-
Concurrent Program: CN_ORD_GET_NOTICE
12.1.1
execution_filename: cn_notify_orders.get_notice_conc , product: CN - Incentive Compensation , user_name: CN_ORD_GET_NOTICE , description: Reads new Order Update Notifications from queue , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: APPLICATION_TYPE
12.1.1
product: CN - Incentive Compensation , meaning: Application Type , description: Application Type ,
-
Concurrent Program: CN_ORD_GET_NOTICE
12.2.2
execution_filename: cn_notify_orders.get_notice_conc , product: CN - Incentive Compensation , user_name: CN_ORD_GET_NOTICE , description: Reads new Order Update Notifications from queue , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
-
Lookup Type: APPLICATION_TYPE
12.2.2
product: CN - Incentive Compensation , meaning: Application Type , description: Application Type ,
-
Lookup Type: ADVANCED_SEARCH
12.2.2
product: CN - Incentive Compensation , meaning: Advanced Search , description: Advanced Search ,
-
Lookup Type: ADVANCED_SEARCH
12.1.1
product: CN - Incentive Compensation , meaning: Advanced Search , description: Advanced Search ,
-
Lookup Type: CN_QUOTA_DISP_ORD
12.2.2
product: CN - Incentive Compensation , meaning: Quota Display Order , description: Quota Display Order ,
-
Lookup Type: CN_QUOTA_DISP_ORD
12.1.1
product: CN - Incentive Compensation , meaning: Quota Display Order , description: Quota Display Order ,
-
Lookup Type: TRX_ROLLUP_METHOD
12.2.2
product: CN - Incentive Compensation , meaning: Transaction Rollup Method , description: Transaction Rollup Method ,
-
Lookup Type: TRX_ROLLUP_METHOD
12.1.1
product: CN - Incentive Compensation , meaning: Transaction Rollup Method , description: Transaction Rollup Method ,
-
Lookup Type: TRX TYPES
12.1.1
product: CN - Incentive Compensation , meaning: Transaction Types , description: Transaction Types ,
-
Table: CN_REASON_HISTORY_ALL
12.2.2
owner:CN, object_type:TABLE, fnd_design_data:CN.CN_REASON_HISTORY_ALL, object_name:CN_REASON_HISTORY_ALL, status:VALID, product: CN - Incentive Compensation , description: This table is an audit table for CN_REASONS_ALL table. Whenever an update or a delete happens to the CN_REASONS_ALL table, this table records the change. , implementation_dba_data: CN.CN_REASON_HISTORY_ALL ,
-
Table: CN_REASON_HISTORY_ALL
12.1.1
owner:CN, object_type:TABLE, fnd_design_data:CN.CN_REASON_HISTORY_ALL, object_name:CN_REASON_HISTORY_ALL, status:VALID, product: CN - Incentive Compensation , description: This table is an audit table for CN_REASONS_ALL table. Whenever an update or a delete happens to the CN_REASONS_ALL table, this table records the change. , implementation_dba_data: CN.CN_REASON_HISTORY_ALL ,
-
Lookup Type: COLLECTION_TRANS_SOURCES
12.2.2
product: CN - Incentive Compensation , meaning: Collection Transaction Sources ,
-
Lookup Type: COLLECTION_TRANS_SOURCES
12.1.1
product: CN - Incentive Compensation , meaning: Collection Transaction Sources ,
-
Lookup Type: MODULE_TYPE
12.2.2
product: CN - Incentive Compensation , meaning: Module Types , description: Module Types ,
-
Lookup Type: MODULE_TYPE
12.1.1
product: CN - Incentive Compensation , meaning: Module Types , description: Module Types ,
-
Lookup Type: TRX_ADV_SEARCH_CRITERIA
12.2.2
product: CN - Incentive Compensation , meaning: Additional Criteria for Advanced Search ,
-
Lookup Type: TRX_ADV_SEARCH_CRITERIA
12.1.1
product: CN - Incentive Compensation , meaning: Additional Criteria for Advanced Search ,
-
Lookup Type: SCA_TRX_SOURCES
12.1.1
product: CN - Incentive Compensation , meaning: SCA_TRX_SOURCES ,
-
Lookup Type: SCA_TRX_SOURCES
12.2.2
product: CN - Incentive Compensation , meaning: SCA_TRX_SOURCES ,
-
Concurrent Program: HIER_LIST
12.1.1
execution_filename: cndihier , product: CN - Incentive Compensation , user_name: CN_HIERARCHIES , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: TRX_REP
12.2.2
execution_filename: cntrxlst , product: CN - Incentive Compensation , user_name: CN_TRX_LST , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: PAYRUN_LST
12.1.1
execution_filename: cnsuprls , product: CN - Incentive Compensation , user_name: CN_PAYRUN_LST , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: SRP_PLAN_ASSIGNS
12.1.1
execution_filename: cnsrpass , product: CN - Incentive Compensation , user_name: CN_SRP_PLAN_ASSIGNS , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: COMM_Q_SUMM
12.2.2
execution_filename: cnsuqsum , product: CN - Incentive Compensation , user_name: CN_COMM_Q_SUM , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: TRX_REP
12.1.1
execution_filename: cntrxlst , product: CN - Incentive Compensation , user_name: CN_TRX_LST , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: HIER_LIST
12.2.2
execution_filename: cndihier , product: CN - Incentive Compensation , user_name: CN_HIERARCHIES , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: RATE_TABLES_LIST
12.1.1
execution_filename: cnplrt , product: CN - Incentive Compensation , user_name: CN_RATE_TABLES_LST , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: RATE_TABLES_LIST
12.2.2
execution_filename: cnplrt , product: CN - Incentive Compensation , user_name: CN_RATE_TABLES_LST , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: PROCESS_LOG
12.2.2
execution_filename: cnsyproc , product: CN - Incentive Compensation , user_name: CN_PROCESS , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,