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 188.8.131.52.1 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: 'Technote_Bug22725263_1111101_Generic.zip'
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