CUSTOMER IMPORT THROWING IDENTIFYING ADDRESS ERRORS

(Doc ID 1462630.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Trading Community Model - Version 11.1.3.0.0 and later
Oracle Fusion Trading Community Model Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Goal

 

  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.

 

1.

Customer ran one file import job for customers, and it went fine
but during ODI Import loading process, it got errors

 

ODI-1226: Step HZ_IMPORT_INTEGRATION fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: oracle.odi.runtime.agent.invocation.InvocationException: ODI-
1425: Agent application cannot be reached using
http://secondary.oracleoutsourcing.com:9032/oraclediagent.
at
oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.reThrowAgentErr
orAsInvocation(RemoteRuntimeAgentInvoker.java:1064)
at
oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke
(RemoteRuntimeAgentInvoker.java:246)


 

 2.
After this the next step is run as IMP_INSERT_PUA_PARTY_OF_INTEREST. and
which inserts data as 'Party_OF_INTEREST'. Below sql is passed for same :

 

 
  
Now with this sequence what happened was that few customers are created
using usage 'PARTY_OF_INTEREST' and question is how to convert them into
sales account now.
 

Solution

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