My Oracle Support Banner

Need To Delete Inactive Source Systems From HZ_ORIG_SYSTEMS (Doc ID 2390947.1)

Last updated on MAY 01, 2018

Applies to:

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

Symptoms

On : 11.13.17.11.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
Need to delete Inactive Source Systems from HZ_ORIG_SYSTEMS

You created source systems from 'Manage Trading Community Source systems' task. Few are deleted from UI by mistake. We have created them again.

But, at the back end, HZ_ORIG_SYSTEMS_B table, we see same source systems, one Active and one Inactive.

While adding source system Confidence in 'Manage Source System Confidence', you can see both Active and Inactive Source systems.

Source systems impacted are

SAART
OMI
DNE
MDNCN


EXPECTED BEHAVIOR
-----------------------
Source system should be deleted from the backend.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OSC
2. Navigate to FSM-> Manage Source System Confidence
3. Create new -> Deleted source system is showing up

BUSINESS IMPACT
-----------------------
Business impact not provided. However, based on priority of the issue, the business impact seems minimal.

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.