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 and later
Information in this document applies to any platform.


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:
- BI Apps version/Patches:
- BI Apps modules: Procurement and Spend Analytics
- OS Platform/version: Oracle Linux 6
- Database versions/Patches:
- ODI Version/Patches:
- Source System: EBS 12.1.3
- Target System: OBIA
- Patches applied for 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?


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