Transaction and Credit Collection Errors

This table documents the possible status errors that the collection process can set for transactions, as well as their causes and corrective actions.

Error

Cause

Corrective Action

Error - Invalid Participant

The PARTICIPANT_ID was populated on a particular staging table transaction and it doesn't have a corresponding entry in CN_SRP_PARTICIPANTS_ALL.

The CREDITED_PARTICIPANT_ID was populated on a particular staging table transaction and it doesn't have a corresponding entry in CN_SRP_PARTICIPANTS_ALL.

Verify that the PARTICIPANT_ID for this transaction exists in the CN_SRP_PARTICIPANTS_ALL table.

Verify that the CREDITED_PARTICIPANT_ID for this transaction exists in the CN_SRP_PARTICIPANTS_ALL table.

Error - Period Not Opened

The transaction Process Date is for an unopened period.

Open the relevant period before collecting the transaction.

Error - Missing Mandatory Data

The staging table transaction has no data for the required fields.

Validate that the transaction has all of these required fields before collecting again:

  • Business Unit

  • Process Date

  • Transaction Amount

  • Transaction Currency Code

  • Transaction Type

  • Source Transaction Number

Error - Missing Currency Conversion

The transaction amount is in a currency that's different from the operating currency. The currency conversion code isn't marked on the transaction and no conversion rate exists for the Process Date between the transaction currency and operating currency.

Populate the currency conversion rate at the transaction level.

Or define the currency conversions for the Process Date using the Manage Incentive Currency Conversions task in the Setup and Maintenance work area.