My Oracle Support Banner

CCB & MWM Integration Error On 'FS_ORDER_ID.xref' (Doc ID 2192861.1)

Last updated on OCTOBER 02, 2024

Applies to:

Oracle Process Integration Pack for Oracle Utilities Field Work - Version 12.1.0.0.0 and later
Oracle Utilities Mobile Workforce Management - Version 2.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
MWM - Oracle Utilities Mobile Workforce Management
PIP/PIP-FW - Oracle Process Integration Pack for Oracle Utilities Field Work
WAM - Oracle Utilities Work and Asset
EBS - E-Business Suite
XSD - XML Schema Documentation
OUAF/FW - Oracle Utilities Framework
XSL - eXtensible Stylesheet Language

 

ACTUAL BEHAVIOR
---------------
CCB & MWM Integration Error

When running PIP between CCB and MWM it is failing with the error that FS_ORDER_ID is empty. When it failed with the error in CCB we ran the Batch process FOD to generate the FO_ID to be passed to PIP to MWM (but that should not be required to run as Real Time transaction processing is going on using PIP).

In the implementation document it is given that there is nothing to be done to the Cross-reference table FS_ORDER_ID.xref when implementing PIP. “During implementation you do not need to do anything with this table.This table is populated by the integration processes as orders are created.”

PIP\soa_server1-diagnostic.log

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.