Opportunity Import & Export Stuck ODI-1226 oracle.security.jps.service.credstore.CredStoreException: JPS-01030 (Doc ID 1605070.1)

Last updated on OCTOBER 03, 2016

Applies to:

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

Symptoms

On :  11.1.7.0.0 version, File Import

When attempting to import Opportunities
the following error occurs.

ERROR
-----------------------
in log
ODI-1226: Step 5.Load fails after 1 attempt(s). ODI-1241: Oracle Data Integrator tool execution fails. at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53) at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1127) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:594) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProce.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigation: Setup & Maintenance --> Manage Import Activities --> Import
Navigation: Setup & Maintenance --> Schedule Export Process --> Export

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import opportunities

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