Certain ETL maps which use the IKM BIAPPS Oracle Event Queue Delete Append KM can fail, requiring changes to the IKM BIAPPS Oracle Event Queue Delete Append KM.
Error Message
You need to fix the IKM BIAPPS Oracle Event Queue Delete Append KM when ETL maps fail with the following error:
ODI-17517: Error during task interpretation. Task: 11 java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: `` if (errLogSupport.equalsIgnoreCase("Y") && errLogOption.equalsIgnoreCase("Y") . . . '' : Attempt to resolve method: equals() on undefined variable or class name: isPartitioned : at Line: 8 : in file: inline evaluation of: `` if (errLogSupport.equalsIgnoreCase("Y") && errLogOption.equalsIgnoreCase("Y") . . . '' : isPartitioned .equals ( "Y" )
Affected Scenarios
The maps affected by the KM are listed below. After the KM fix, the scenarios present in these mapping folders need to be regenerated. PLP and SIL scenarios are mandatory and the SDE scenarios of the PLVs you use need to be regenerated. For example, if you are using E-Business Suite, then those SDE, SIL, and PLP scenarios need to be regenerated.
PLP:
PLP_WorkforceCompensationFact_Quarter
PLP_SupervisorHierarchy_Analysis_Top
PLP_SupervisorStatusDimension
PLP_WorkforceBalanceAggregate_Temp
PLP_WorkforceCompensationFact_Year
PLP_WorkforceEventFact_Age
PLP_WorkforceEventFact_Merge
PLP_WorkforceEventFact_Month
PLP_WorkforceEventFact_Pow
PLP_Workforce_GainLossFact_NonSupChanges
PLP_Workforce_GainLoss_Tmp_SupChanges
PLP_Workforce_Gen01_GainLossFact_Frozen
PLP_Workforce_Gen01_GainLossFact_Live
SIL
SIL_AbsenceEventFact
SIL_AssignmentSupervisorDimension
SIL_WorkforceEventFact
Fusion SDE
SDE_FUSION_AssignmentSupervisorDimension
SDE_FUSION_AssignmentSupervisorDimension
SDE_FUSION_DomainGeneral_ProjectAwardFundingSource
SDE_FUSION_DomainGeneral_ProjectAwardInstitution
SDE_FUSION_DomainGeneral_ProjectAwardKeyword
SDE_FUSION_PersistedStage_WorkforceEvent
SDE_FUSION_PersistedStage_WorkforceEvent
SDE_FUSION_WorkforceEventFact
SDE_FUSION_WorkforceEventFact
E-Business Suite SDE
SDE_ORA_AssignmentSupervisorDimension
SDE_ORA_HRPersonLegDimension
SDE_ORA_PersistedStage_WorkforceEvent
SDE_ORA_PersistedStage_WorkforceEvent_Supervisor
SDE_ORA_WorkforceEventFact
PeopleSoft SDE
SDE_PSFT_AssignmentSupervisorDimension
SDE_PSFT_HRPersonLegislation_XLegs
SDE_PSFT_PersistedStage_WorkforceEvent
SDE_PSFT_PersistedStage_WorkforceEvent_Headcount
SDE_PSFT_PersistedStage_WorkforceEvent_PositionHolder
SDE_PSFT_PersistedStage_WorkforceEvent_WorkerPosition
SDE_PSFT_WorkforceEventFact