Thursday, August 14, 2014

FIC-Import Credit Trx via File Import


To BottomTo Bottom

In this Document
Goal
Solution
  Step # 1.  Create a File Import mapping.
 Step # 2.  Create a CSV (comma delimited) data file
 Step # 3.  Create a File Import Activity
 Step # 4.  Run Collect Transaction  (see Collect Transaction Troubleshooting Guide Doc ID 1392581.1) 
 Step # 5. Verify credited transaction imported and collected successfully
References


APPLIES TO:

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

GOAL

This document will specify the required fields and mapping to import credited transactions using File Import for object Incentive Compensation Transactions.
Menu Path: Navigator > Incentive Compensation > Credits and Earnings > Import Transactions Using File Based Data Import

SOLUTION

 Step # 1.  Create a File Import mapping.

 Navigator > Setup and Maintenance > Search Task: Manage File Import Mappings
Screenshot of the mapping

 
Column HeaderSample ValueDescription
TRANSACTION_TYPEMANUALTask: Manage Incentive COmpensation Lookups - search on lookup type CN_TP_TRANSACTION_TYPE.  User can create new transaction types.  Use the lookup code as the value for the data file.
TRANSACTION_NUMBERImpTrx-1Normally, transaction number is unique. However for credited transactions, it can be the same as the next record as long as the credited_participant is not the same.  Meaning, you can load multiple credited participants for the same transaction.
EVENT_DATE01/16/2012 
CREDIT_DATE01/16/2012 
ROLLUP_DATE01/16/2012 
TRANSCTION_AMOUNT150.00 
QUANTITY25 
CURRENCY_CODEUSD 
CREDIT_CATEGORY300000001228758Use sql to find out the id value for the credit category:

SELECT eligible_cat_id, name
   FROM cn_eligible_cats_all_tl ;  
CREDIT_AMOUNT113.25 
CREDIT_SPLIT_PERCENT75.50Percentage. If this is not 100% then the credit_amount should reflect the transaction_amount X credit_split_percent.  Example: 150 X 75.50% = 113.25
CREDIT_REVENUE_TYPEREVENUE or NON_REVENUE
CREDITED_PARTICIPANT_ID10001Use sql to find out the id value for the credited_participant :

SELECT participant_id, participant_name
    FROM cn_srp_participants_all ;
PROCESS_CODECNRECThe process code will tell the system if the following process in this order (Classify, Credit, Rollup, Eligibility, Calculation) will be process or not.

CCREC = Normal,  process all
NCREC = Skip classification
NCNEC = Skip classification and rollup
CNNEC = Skip crediting and rollup
CNREC = Skip crediting
CCNEC = Skip rollup
NNREC = Skip classification and crediting
NNNEC = Skip classification, crediting, and rollup
Note: If you want to preserve the credit receivers and credit categories values, then use option to skip crediting (eg. CNREC)
BUSINESS_UNIT_ID300000001175314Use sql to find out value of business_unit_id.

SELECT DISTINCT bu.bu_id,   bu.bu_name
  FROM fun_all_business_units_v bu,
           fun_business_functions_b bf,
           fun_bu_usages_v buu
 WHERE bu.bu_id = buu.business_unit_id
     AND bf.business_function_code = 'INCENTIVE_COMPENSATION_BF'
     AND bf.business_function_id = buu.module_id ;
SOURCE_BUSINESS_UNIT_ID300000001175314 Use sql to find out value of business_unit_id.

SELECT DISTINCT bu.bu_id,   bu.bu_name
  FROM fun_all_business_units_v bu,
           fun_business_functions_b bf,
           fun_bu_usages_v buu
 WHERE bu.bu_id = buu.business_unit_id
     AND bf.business_function_code = 'INCENTIVE_COMPENSATION_BF'
     AND bf.business_function_id = buu.module_id ;
SALES_CHANNELEpipenOptional - example of Channel value used in classification or crediting rules.
ATTRIBUTE_NUMBER11220.00Optional - example of populating a numeric attribute value to be used for calculation.

SaaS  If you are a Software-as-a-Service (SaaS) customer, please log a Service Request in My Oracle Support for Oracle to get the results of the id values for business_unit_id. credit_category_id, and credited_participant_id queries for you.

Step # 2.  Create a CSV (comma delimited) data file

Download sample transaction data file here.
This sample csv data file will create three transactions:
      
 Transaction Number:  ImpCreditTrx-4  
 Transaction Amount:  150.00   
 ParticipantCredit AmountSplit PercentRevenue Type 
 10000$113.2575.5Revenue 
 10001$36.7524.5Revenue 
 10002$250.00100Non-Revenue 
      
 Transaction Number:  ImpCreditTrx-5  
 Transaction Amount:  150.00   
 ParticipantCredit AmountSplit PercentRevenue Type 
 10001$500.00100Revenue 
      
 Transaction Number:  ImpCreditTrx-6  
 Transaction Amount:  150.00   
 ParticipantCredit AmountSplit PercentRevenue Type 
 10000$75.00100Revenue 
      

Step # 3.  Create a File Import Activity

Navigation : Credits and Earnings > Import Transactions Using File Based Data Import
Screenshot of defining an import activity.


  
                             NOTE: When Status change to "Base table upload in progress" then this portion is completed.
  


Step # 4.  Run Collect Transaction  (see Collect Transaction Troubleshooting Guide Doc ID 1392581.1) 

Screenshot of submitting collect transaction.

Step # 5. Verify credited transaction imported and collected successfully

Navigator > Credits and Earnings > Manage Credits

No comments:

Post a Comment