Will Manual (Spend) Classifications Be Lost After DW Reset And/or Full Load and how to avoid that? (Doc ID 2226328.1)

Last updated on MARCH 29, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.

Symptoms

The customer was experiencing the following error during the incremental load
ODI-1228: Task SIL_PositionDimensionHierarchy.W_POSITION_DH (Integration)
fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-01427: single-row subquery returns more
than one row.
.
Normally this issue is resolved by following:
'Technote_Bug22725263_1111101_Generic.zip' but the customer wanted to avoid the Full Load and DW reset requirement due to concerns about losing manual classifications (spend classifications).
.
The technote did resolve the original problem after making a minor change on the source (name change). No Full load was required with this change.

See note for additional workaround details:OBIA: SIL_PositionDimensionHierarchy returns: ORA-01427: Single-row Subquery Returns More Than One Row (Doc ID 2226325.1)
.
After reviewing the technote, the customer is concerned about losing 1000's of manual classifications (spend classification) if a full load and especially a DW reset is done. They do not want to risk losing weeks of work.
.
.
- OBIEE Version: 12.2.1.0.0
- BI Apps version/Patches: 11.1.1.10.1
- BI Apps modules: Procurement and Spend Analytics
- OS Platform/version: Oracle Linux 6
- Database versions/Patches: 12.1.0.1
- ODI Version/Patches: 11.1.1.9.1
- Source System: EBS 12.1.3
- Target System: OBIA 11.1.1.10.1
.
- Patches applied for 11.1.1.10.1? NO
- Patches applied for Database? NO
.
The questions we want to answer are:
.
Will Manual (Spend) Classifications Be Lost After DW Reset and/or Full Load?
.
How to safely run Full Loads so they are not lost?

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