Import Setup Data – Error In Application Key Flexfield

(Doc ID 2069829.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

If you are a Software-as-a-Service (SaaS) customer, there are multiple sections in this document that need not be performed by you. Please log a Service Request in My Oracle Support for Oracle to do this for you.

When attempting to import setup data, an error occurs in Application Key Flexfield


From SetupStatus.log

Business object: Application Key Flexfield Status: Completed with errors Status details: ATGT2P: SDF Upload Failure on file FND_APP_KEY_FLEXFIELD/KeyFlexfield/GL/KeyFlexfieldSD.xml Error: Status=8 File=
Loader completed with Data Validation error(s)
Exception[0]: Segment[StructureId:41,SegmentCode:XYZ_Account]oracle.apps.fnd.applseed.rt.loader.exception.SDLoaderException: Loading failed with a JboException: JBO-25072: Applying List binding LOV_ValueSetCode with given set of values leads to no matching row for a row of type :Segment, key oracle.jbo.Key[41 XYZ_Account ].
Detailed Messages: JBO-25072: Applying List binding LOV_ValueSetCode with given set of values leads to no matching row for a row of type :Segment, key oracle.jbo.Key[41 XYZ_Account ]

    at oracle.apps.fnd.applseed.rt.loader.core.SDDataHandler.handleJboException(SDDataHandler.java:439)
    at oracle.apps.fnd.applseed.rt.loader.core.SDDataHandler.handleJboException(SDDataHandler.java:416)
...
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: oracle.jbo.ListBindingMismatchException: JBO-25072: Applying List binding LOV_ValueSetCode with given set of values leads to no matching row for a row of type :Segment, key oracle.jbo.Key[41 XYZ_Account ]
    at oracle.jbo.server.ViewRowImpl.handleListBindingMismatch(ViewRowImpl.java:1710)
    at oracle.jbo.server.ListBinding.handleListBindingMismatch(ListBinding.java:36)
...
    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)
    ... 139 more

 

From the $APPLICATIONS_CONFIG/domains/server/CommonDomain/servers/HelpPortalServer_1/logs/apps/HelpPortalServer_1-diagnostic.log

[2015-10-06T05:28:48.173+00:00] [HelpPortalServer_1] [TRACE] [] [oracle.apps.appslogger] [tid: 53] [userId: username] [ecid: 0000L0vZwZrBHBY5trd9iX1M3yMS002pJF,0] [APP: ApplicationsCoreSetupApp#V2.0] [APPS_THREAD_NAME: [ACTIVE].ExecuteThread: '36' for queue: 'weblogic.kernel.Default (self-tuning)'] [APPS_TERRITORY: AR] [APPS_SESSION_ID: 2169A9B06C86FED8E0538497480AD508] [APPS_AUTO_LOG: false] [APPS_USER_NAME: username] [APPS_USER_ID: ###XX##XXXX####] [APPS_DB_CONNECTION_URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=fusiondb.domain.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dbservicenamei))] [APPS_SOURCE: fnd.applcore.flex.webservice.ValueSetWSAMImpl] [SRC_CLASS: oracle.apps.fnd.applcore.log.AppsODLHandler] [SRC_METHOD: publish] ATGT2P: WARNING: File /tmp/cb901ecd-851b-4652-ace3-db80c7a48e21/FND_APP_FLEX_VALUE_SET/ValueSet/EXM/US/ValueSetSD.xlf exceeds maximum export size and has been excluded.  File must be migrated manually.

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