My Oracle Support Banner

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 FEBRUARY 23, 2019

Applies to:

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


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:  ''

This requires a Full Load and DW reset which cause concerns of losing manual classifications (spend classifications).
The technote does 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.

Questions 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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.