Fusion Applications FSM Import Setup Data Errors - Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 0 ] (Doc ID 2069838.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to import setup data, an error occurs inApplication Common Lookup

From SetupStatus.log file

Business object: Application Common Lookup Status: Completed with errors Status details: ATGT2P: SDF Upload Failure on file FND_APP_STANDARD_LOOKUP/StandardLookupType1/ZSF/StandardLookupTypeSD.xml Error: Status=4 File=
Loader completed with error(s)
Exception[0]: oracle.apps.fnd.applseed.rt.loader.exception.SDLoaderException: Loading failed with a JboException: JBO-27023: Failed to validate all rows in a transaction..
Detailed Messages: JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 0 ] in LookupTypeEOJBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 0 ] in LookupTypeEOJBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 5 0 0 ] in LookupEOJBO-LookupValueEO_Rule_0: Start Date must be before End DateJBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 6 0 0 ] in LookupEOJBO-LookupValueEO_Rule_0: Start Date must be before End DateJBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 7 0 0 ] in LookupEOJBO-LookupValueEO_Rule_0: Start Date must be before End DateJBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 8 0 0 ] in LookupEOJBO-LookupValueEO_Rule_0: Start Date must be before End DateJBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 9 0 0 ] in LookupEOJBO-LookupValueEO_Rule_0: Start Date must be before End Date
[01]: oracle.jbo.RowValException: JBO-27024: Failed to validate a row with key oracle.jbo.Key[ZSF_FCST_PROD_HIERARCHY_DEPTH 0 ] in LookupTypeEO

    at oracle.apps.fnd.applseed.rt.loader.core.SDDataHandler.handleJboException(SDDataHandler.java:439)
    at oracle.apps.fnd.applseed.rt.loader.core.SDDataHandler.commitTrans(SDDataHandler.java:353)
...
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: oracle.jbo.TxnValException: JBO-27023: Failed to validate all rows in a transaction.
    at oracle.jbo.server.DBTransactionImpl.validate(DBTransactionImpl.java:4732)
    at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2189)
...
    at oracle.apps.fnd.applseed.rt.loader.core.SDSAXHandler.performLoad(SDSAXHandler.java:162)
    at oracle.apps.fnd.applseed.rt.loader.handler.sax.SDBaseSAXHandler.loadEntity(SDBaseSAXHandler.java:634)
    ... 143 more


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