Update Existing Customer Ebiz To Siebel Fails after Configuring Order to Cash PIP. (Doc ID 810664.1)

Last updated on OCTOBER 20, 2016

Applies to:

Siebel CRM Integration Pack for Oracle Order Management: Order to Cash - Version 2.3 to 3.1.1 [Release 2.3 to 3.1]
Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite - Version 2.5 to 3.1.1 [Release 2.5 to 3.1]
Information in this document applies to any platform.
Siebel CRM Integration Pack for Oracle Order Management - Version: 2.3


Symptoms

-- Problem Statement:
After installing the Application Integration Architecture Foundation Pack 2.3 and configuring Order to Cash 2.3.  During testing when updating a customer in Ebiz is failing to update Siebel.  After turning on BPEL debugging in the BPEL Console find the following error in the log files:

(Error) Extension function error: Error invoking 'lookupXRef':'oracle.tip.xref.exception.ValidationException: Reference Column Name is empty for Cross Refrence Table Name "CUSTOMERPARTY_PARTYID"
Please ensure Reference Column Name is not-empty'

-- Steps To Reproduce:
Install and configure the Order to Cash PIP.
Create a new customer in Siebel and enter an order for the customer.
The customer will be created in Ebiz.
Update the customer and expect the update to be transferred to Siebel.
Fails in transferring the update to Siebel.

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