Certain ETL maps that 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 must 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 here. After the Knowledge Module (KM) fix, regenerate the scenarios present in these mapping folders. The Post Load Process (PLP) and Source Independent Load (SIL) scenarios are mandatory and Source Dependent Extract (SDE) scenarios of the PLVs you use need to be regenerated. For example, if you are using Oracle E-Business Suite, then regenerate those SDE, SIL, and PLP scenarios.
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