File Based Loader (FBL) Error: Constraint "PER_ACTION_REASON_USAGES_U1" Is Violated During Post Operation "Insert" (Doc ID 2024511.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Fusion Performance Management Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to load action reasons using File Based Loader (FBL), the following error occurs.

-- Error
 Constraint "PER_ACTION_REASON_USAGES_U1" is violated during post operation "Insert" using SQL statement "INSERT INTO PER_ACTION_REASON_USAGES(ACTION_REASON_USAGE_ID,ACTION_ID,ACTION_REASON_ID,BUSINESS_GROUP_ID,ACTION_CODE,ACTION_REASON_CODE,START_DATE,END_DATE,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,LAST_UPDATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14)".

 -- Steps
1. Data Exchange / Load Data for Coexistence / Import
2. Enter parameters: Business Object =Action
3. Try to load the batch

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms