After Upgrade to Release 12 Transaction File Import Error JBO-27014: Attribute TransactionAmtSourceCurr in TransactionStagingEO is required. (Doc ID 2281553.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Fusion Incentive Compensation - Version 11.12.1.0.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

After R12 upgrade, Import Transactions Using File Based Data Import errors or show status as Unsuccessful .

ERROR

The process fails to load data into import interface tables. Cause: oracle.jbo.AttrValException: JBO-27014: Attribute TransactionAmtSourceCurr in TransactionStagingEO is required. oracle.jbo.server.JboMandatoryAttributesValidator.validate(JboMandatoryAttributesValidator.java:243) oracle.jbo.server.EntityDefImpl.validate(EntityDefImpl.java:3264) oracle.jbo.server.EntityCache.validate(EntityCache.java:3824) oracle.jbo.server.EntityImpl.validateEntity(EntityImpl.java:2770) oracle.apps.fnd.applcore.oaext.model.OAEntityImpl.validateEntity(OAEntityImpl.java:1459) oracle.jbo.server.EntityImpl.validate(EntityImpl.java:2952) oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4706) oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2192) oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2523) oracle.apps.marketing.commonMarketing.mktImport.loader.stagingLoader.StagingLoader.load(StagingLoader.java:2740) oracl

OR

The value 11321193.24 supplied for the attribute Original Transaction Value does not match the expected data type java.math.BigDecimal. (MKT-285231) Cause: The user provided a value in an incorrect data type. Action: The user must provide a value of the expected data type.(Original Transaction Value



STEPS
Navigator > Credits and Earnings > Import Transactions Using File Based Data Import
Object = Incentive compensation transactions

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