My Oracle Support Banner

Common Errors For Transactions Import Using File Based Import (Doc ID 2084845.1)

Last updated on NOVEMBER 13, 2019

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.18.05.0 and later
Oracle Fusion Incentive Compensation - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Purpose

This document lists some common errors why file based import for Incentive Compensation Transactions object completed with errors.



STEPS

Navigator > Credits and Earnings > Processes > Import Transactions Using File Based Data Import

Object = Incentive compensation transactions

 

NOTE

Import Transaction using File Based Import (CRM File Import) shows status as Base table upload in progress ( Release 11 ) or Importing Data ( Release 12 + ) . Is the process stuck ?

Answer : No, this is a valid and completed status designation for Incentive Compensation.
Incentive Compensation leverage the CRM File Import utility but does not use the full utility so it stops after just importing into the interface table therefore it will not reach the final "Completed" status. Development is looking into improving this process for Incentive Compensation. You can validate that your data was imported by checking CN_TP_TRANSACTIONS_STAGING_T table using direct query in BI or transaction webservice.

User can go ahead and run Collection process.
Take a look at the Collection process log, it has a detail message of how many transactions imported and how many error and why.
To validate, user can search for the transaction in Manage Transaction afterwards.

 

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.