When Same product is added multiple times in a Service Bundle instead of increasing quantity, PopulateXREF fails (Doc ID 1637881.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Communications Order to Cash Integration Pack for Oracle Communications Billing and Revenue Management - Version 11.3 and later
Information in this document applies to any platform.

Symptoms

Comms PIP 11.3 version, 

When attempting to add same product added in Service Bundle more than one time. Populate Xref fails with the error. Modify_Customer is being called successfully but in the OOB process ProcessFulfillmentOrderBillingBRMCommsAddSubProcess, getting failed while populating Xref values, the following error occurs.

ERROR
...

XPath expression failed to execute. An error occurs while processing the XPath expression; the expression is ora:processXSLT('xsl/Populate_and_Delete_XREF.xsl',bpws:getVariableData('inputSubProcess'),bpws:getVariableData('XREFParams')). The XPath expression failed to execute; the reason was: oracle.fabric.common.xml.xpath.XPathFunctionException: javax.xml.transform.TransformerException: oramds:/deployed-composites/default/ProcessFulfillmentOrderBillingBRMCommsProvABCSImpl_rev1.0/xsl/Populate_and_Delete_XREF.xsl<Line 32, Column 182>: XML-22044: (Error) Extension function error: Error invoking 'populateXRefRow':'oracle.tip.xref.exception.RepositoryException: 1.Reference value "31343036313033323831313438303835" in reference column "COMMON" in table "oramds:/apps/AIAMetaData/xref/INSTALLEDPRODUCT_ID.xref" not found OR 2.CrossReference Column "BRM_01" in Cross Reference Table "oramds:/apps/AIAMetaData/xref/INSTALLEDPRODUCT_ID.xref" has a value 1.Please ensure the Reference Value exists for the Reference Column 2.Please ensure the Column to be populated is empty
...

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