These issues and workarounds are related to the use of Oracle GoldenGate.
This change is required only when you use GoldenGate to replicate EBS data.
Model Change
Open Model Oracle E-Business Suite R12.2 , click Application Object Library and select FND_FLEX_VALUE_CHILDREN_V.
Open the Flexfields tab and set OBI SDS Load Tech Exclusion List to BIA_OGG_SDS.
Save the change.
Package Changes
Modify the following packages to support SDS:
SDE_ORA_Stage_BalancingSegmentDimensionHierarchy_Primary
SDE_ORA_Stage_GLSegmentDimensionHierarchy_Primary
SDE_ORA_State_NaturalAccountDimensionHierarchy_Primary
As an example, the following instruction uses Balancing Segment.
Take a backup of the ODI repository.
In ODI client, open Mappings, click SDE_ORAXXX_Adaptor and select SDE_ORA_Stage_BalancingSementDimensionHiearrchy_Primary.
Remove the link between SOFT_DELETE_PREPROCESS and SDE_ORA_Stage_BalancingSegmentDimensionHierarchy_Primary.W_BALANCING_SEGMENT_HIER_PS_PE.
Drag variable SDS_LOAD_TECHNO and IS_SDS_DEPLOYED to the package.
Rename the step name from SDS_LOAD_TECHNO to SDS_LOAD_TECHNO is BIA_OGG_SDS. Use Type “Evaluate Variable”, Operator “=”, and Value “BIA_OGG_SDS”.
Use Type Set Variable and value N for IS_SDS_DEPLOYED.
Connect SOFT_DELETE_PREPROCESS to SDS_LOAD_TECHNO is BIA_OGG_SDS .
Connect SDS_LOAD_TECHNO is BIA_OGG_SDS to interface SDE_ORA_Stage_BalancingSegmentDimensionHierarchy_Primary.W_BALANCING_SEGMENT_HIER_PS_PE.
Connect SDS_LOAD_TECHNO is BIA_OGG_SDS to IS_SDS_DEPLOYED .
Connect IS_SDS_DEPLOYED to interface SDE_ORA_Stage_BalancingSegmentDimensionHierarchy_Primary.W_BALANCING_SEGMENT_HIER_PS_PE .
Regenerate the scenario
Load Plan Change
Add variable SDS_LOAD_TECHNO and refresh it at root level.
Open BIAPPS Load Plan, click Load Plan Dev Components, click SDE and select EBS_XXX LP component above.
SDE Dims BALSEG_DIM
Go to the Variables tab.
Click Add. Search SDS_LOAD_TECHNO and click OK.
Go to the Steps tab.
Enable the Overwrite and Refresh checkboxes.
3 SDE Dims GLSEG_DIM
3 SDE Dims NAT_ACCT_DIM
3 SDE Dims GLACCNT_DIM (The corresponding package change is already included in the product for this load plan).